Re: Modifying TOAST thresholds - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Modifying TOAST thresholds
Date
Msg-id 17489.1175574401@sss.pgh.pa.us
Whole thread Raw
In response to Re: Modifying TOAST thresholds  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Modifying TOAST thresholds  ("Zeugswetter Andreas ADI SD" <ZeugswetterA@spardat.at>)
List pgsql-hackers
I wrote:
> ... should we revel
> in configurability, and allow CREATE TABLE/ALTER TABLE behavior to vary
> depending on the current threshold setting?  We'd have to fix the
> toaster routines to not try to push stuff out-of-line when there is no
> out-of-line to push to ... but I think we probably had better do that
> anyway for robustness, if we're allowing any variability at all in these
> numbers.

Actually, upon looking closely at the toast code, it already does the
right thing when there's no toast table.  Good on someone for getting
that right.  But we still need to think about whether it's sane for
CREATE/ALTER TABLE to condition the create-a-toast-table decision on
a parameter that may now be changeable.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Modifying TOAST thresholds
Next
From: "Luke Lonergan"
Date:
Subject: Re: Synchronized Scan benchmark results