Chris Browne <[EMAIL PROTECTED]> writes: > [EMAIL PROTECTED] (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 ---------------------------(end of broadcast)--------------------------- TIP 7: You can help support the PostgreSQL project by donating at http://www.postgresql.org/about/donate