[HACKERS] COMPRESS VALUES feature request

The use case is having a column with strings/floats, where some values are very common and can be compressed, while many other values are unique, making a lookup table not efficient.

It can be part of a column definition, set in CREATE TABLE/ALTER TABLE

e.g. field VARCHAR(255) COMPRESS (NULL, 'EREZ', 'SEGAL')

The feature exists in TeraData:
https://community.teradata.com/t5/Database/how-does-compress-work-in-tables/td-p/13950

In the IRC channel - johto suggested an implementation:

<johto> if you want to get really fancy you could have two columns where only one of set; one would be the value (if reasonably unique) and the other the id (if not)

I'd like to add that an ENUM can be used instead of the id+lookup table in the 2nd column for non unique values.