Re: Higher TOAST compression.

Поиск
Список
Период
Сортировка
От Joshua D. Drake
Тема Re: Higher TOAST compression.
Дата
Msg-id 1247859399.31065.82.camel@jd-laptop.pragmaticzealot.org
обсуждение исходный текст
Ответ на Re: Higher TOAST compression.  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
Список pgsql-hackers
On Fri, 2009-07-17 at 14:21 -0500, Kevin Grittner wrote:
> "Joshua D. Drake" <jd@commandprompt.com> wrote: 
> > On Fri, 2009-07-17 at 12:50 -0500, Kevin Grittner wrote:
>  
> >> (3)  Allow override of the thresholds for individual columns.
>  
> > I would skip 1 and 2 and have (3).
>  
> Sure, pick the one which requires new syntax!  ;-)

Better than the argument for a new GUC :).

>  
> How about two new ALTER TABLE actions:
>  
>    ALTER [ COLUMN ] column SET COMPRESSION_THRESHOLD integer
>    ALTER [ COLUMN ] column SET EXTERNAL_THRESHOLD integer
>  
> Or can you suggest something better?

Seems reasonable to me.

Joshua D. Drake


-- 
PostgreSQL - XMPP: jdrake@jabber.postgresql.org  Consulting, Development, Support, Training  503-667-4564 -
http://www.commandprompt.com/ The PostgreSQL Company, serving since 1997
 



В списке pgsql-hackers по дате отправления:

Предыдущее
От: "Kevin Grittner"
Дата:
Сообщение: Re: Higher TOAST compression.
Следующее
От: Tom Lane
Дата:
Сообщение: Subtransactions and resource owners and such