Postgres Pro
Downloads
Home   >   mailing lists

Re: RFD: ALTER COLUMN .. SET STORAGE COMPRESSED; - Mailing list pgsql-hackers

From Tom Lane
Subject Re: RFD: ALTER COLUMN .. SET STORAGE COMPRESSED;
Date
Msg-id 18010.1213111545@sss.pgh.pa.us
Whole thread Raw
In response to RFD: ALTER COLUMN .. SET STORAGE COMPRESSED;  ("Dawid Kuroczko" <qnex42@gmail.com>)
Responses Re: RFD: ALTER COLUMN .. SET STORAGE COMPRESSED;  ("Dawid Kuroczko" <qnex42@gmail.com>)
List pgsql-hackers
Tree view 
"Dawid Kuroczko" <qnex42@gmail.com> writes:
> As we already have four types of ALTER COLUMN .. SET STORAGE
> { PLAIN | EXTERNAL | EXTENDED | MAIN } I would like to add
> "COMPRESSED" which would force column compression (if column is
> smaller than some minimun, I guess somwehwere between 16 and 32 bytes).

Please see previous discussions about per-column toasting parameters,
for instance
http://archives.postgresql.org/pgsql-hackers/2007-08/msg00082.php
http://archives.postgresql.org/pgsql-general/2007-08/msg01129.php

I think the general consensus was that we want more flexible access to
the compression knobs than just another STORAGE setting.
        regards, tom lane

pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: libpq support for arrays and composites
Next
From: Alvaro Herrera
Date:
Subject: Re: RFD: ALTER COLUMN .. SET STORAGE COMPRESSED;