Re: Higher TOAST compression. - Mailing list pgsql-hackers

From Joshua D. Drake
Subject Re: Higher TOAST compression.
Date
Msg-id 1247859399.31065.82.camel@jd-laptop.pragmaticzealot.org
Whole thread Raw
In response to Re: Higher TOAST compression.  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
List 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 by date:

Previous
From: "Kevin Grittner"
Date:
Subject: Re: Higher TOAST compression.
Next
From: Tom Lane
Date:
Subject: Subtransactions and resource owners and such