I have seen no one do peroformance testing of this, so it seems it will have to wait for 8.4.
--------------------------------------------------------------------------- Gregory Stark wrote: > "Tom Lane" <[EMAIL PROTECTED]> 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 will take some thinking before it's even clear what we should be measuring. > The "optimal" value will depend heavily on the usage pattern so the best value > for the default will be something hand-wavy like "the smallest tuple size > where the cost of a select including the column is greater than the time saved > on a select not including the column" or something like that. > > -- > Gregory Stark > EnterpriseDB http://www.enterprisedb.com > > > ---------------------------(end of broadcast)--------------------------- > TIP 7: You can help support the PostgreSQL project by donating at > > http://www.postgresql.org/about/donate -- Bruce Momjian <[EMAIL PROTECTED]> http://momjian.us EnterpriseDB http://www.enterprisedb.com + If your life is a hard drive, Christ can be your backup. + ---------------------------(end of broadcast)--------------------------- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
