Re: RFD: ALTER COLUMN .. SET STORAGE COMPRESSED;

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: RFD: ALTER COLUMN .. SET STORAGE COMPRESSED;
Дата
Msg-id 18010.1213111545@sss.pgh.pa.us
обсуждение исходный текст
Ответ на RFD: ALTER COLUMN .. SET STORAGE COMPRESSED;  ("Dawid Kuroczko" <qnex42@gmail.com>)
Ответы Re: RFD: ALTER COLUMN .. SET STORAGE COMPRESSED;  ("Dawid Kuroczko" <qnex42@gmail.com>)
Список pgsql-hackers
"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 по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: libpq support for arrays and composites
Следующее
От: Alvaro Herrera
Дата:
Сообщение: Re: RFD: ALTER COLUMN .. SET STORAGE COMPRESSED;