Re: Modifying TOAST thresholds - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Modifying TOAST thresholds
Date
Msg-id 27347.1175609718@sss.pgh.pa.us
Whole thread Raw
In response to Re: Modifying TOAST thresholds  (Chris Browne <cbbrowne@acm.org>)
Responses Re: Modifying TOAST thresholds  ("Luke Lonergan" <llonergan@greenplum.com>)
List pgsql-hackers
Chris Browne <cbbrowne@acm.org> writes:
> Here's a "drafty" patch that *tries* to do this using a GUC variable;
> it passes some interactive testing.

BTW, it strikes me that a GUC variable is quite the wrong way to go
about this.  The right way is a table storage parameter, a la FILLFACTOR,
so that it can be set on a per-table basis.  That would also give us a
chance to fix my concern about needs_toast_table: the case where we
might need a toast table that we didn't need before is where the toast
threshold is lowered via ALTER TABLE SET, and we could reasonably make
that command recheck the situation.
        regards, tom lane


pgsql-hackers by date:

Previous
From: "Pavan Deolasee"
Date:
Subject: Plan invalidation
Next
From: Bruce Momjian
Date:
Subject: Re: [PATCHES] Arrays of Complex Types