| From: | Gregory Stark <stark(at)enterprisedb(dot)com> |
|---|---|
| To: | "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | "Bruce Momjian" <bruce(at)momjian(dot)us>, "Simon Riggs" <simon(at)2ndquadrant(dot)com>, "Chris Browne" <cbbrowne(at)acm(dot)org>, "Jan Wieck" <JanWieck(at)Yahoo(dot)com>, <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: Modifying TOAST thresholds |
| Date: | 2007-04-05 01:34:31 |
| Message-ID: | 87slbfk3iw.fsf@oxford.xeocode.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
"Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Andrew - Supernews | 2007-04-05 01:35:19 | Re: Bug in UTF8-Validation Code? |
| Previous Message | Gregory Stark | 2007-04-05 01:17:00 | Re: Auto Partitioning |