Re: Modifying TOAST thresholds - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Modifying TOAST thresholds
Date
Msg-id 19017.1175750198@sss.pgh.pa.us
Whole thread Raw
In response to Re: Modifying TOAST thresholds  (Chris Browne <cbbrowne@acm.org>)
List pgsql-hackers
Chris Browne <cbbrowne@acm.org> writes:
> tgl@sss.pgh.pa.us (Tom Lane) writes:
>> What I would definitely like to see for 8.3 is some performance testing
>> done to determine whether we ought to change the current defaults.
>> (Both TOAST_TUPLES_PER_PAGE and EXTERN_TUPLES_PER_PAGE ought to be looked
>> at.)

> It seems to me that changing the denominator from 4 to something
> somewhat higher (16 comes to mind) would probably be "the patch," and
> would likely be useful for a fair number of cases.  I'd really like to
> see something like this (e.g. - something that would start TOASTing
> for, say, tuples > 500 bytes) in 8.3; this seems to me to have the
> potential to be a significant optimization that would be VERY cheap to
> implement.  "Low hanging fruit," so to speak.

So let's see some performance measurements to back up that intuition.
        regards, tom lane


pgsql-hackers by date:

Previous
From: "Luke Lonergan"
Date:
Subject: Re: Modifying TOAST thresholds
Next
From: "Pavan Deolasee"
Date:
Subject: Re: pg_index updates and SI invalidation