Re: Modifying TOAST thresholds

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. +