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" <tgl@sss.pgh.pa.us> 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 <bruce@momjian.us> http://momjian.us EnterpriseDB
http://www.enterprisedb.com
+ If your life is a hard drive, Christ can be your backup. +