Re: Modifying TOAST thresholds

Chris Browne <cbbrowne(at)acm(dot)org> writes:
> tgl(at)sss(dot)pgh(dot)pa(dot)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