Re: Modifying TOAST thresholds - Mailing list pgsql-hackers

From Luke Lonergan
Subject Re: Modifying TOAST thresholds
Date
Msg-id C3E62232E3BCF24CBA20D72BFDCB6BF802AF2A7F@MI8NYCMAIL08.Mi8.com
Whole thread Raw
In response to Modifying TOAST thresholds  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
<p><font size="2">Not just EDB :-)<br /><br /> - Luke<br /><br /> Msg is shrt cuz m on ma treo<br /><br />
 -----OriginalMessage-----<br /> From:   Chris Browne [<a
href="mailto:cbbrowne@acm.org">mailto:cbbrowne@acm.org</a>]<br/> Sent:   Wednesday, April 04, 2007 10:07 PM Eastern
StandardTime<br /> To:     pgsql-hackers@postgresql.org<br /> Subject:        Re: [HACKERS] Modifying TOAST
thresholds<br/><br /> tgl@sss.pgh.pa.us (Tom Lane) writes:<br /> > Bruce Momjian <bruce@momjian.us> writes:<br
/>>> The big question is whether this is for 8.3 or 8.4.<br /> ><br /> > What I would definitely like to
seefor 8.3 is some performance testing<br /> > done to determine whether we ought to change the current defaults.<br
/>> (Both TOAST_TUPLES_PER_PAGE and EXTERN_TUPLES_PER_PAGE ought to be looked<br /> > at.)<br /> ><br /> >
Whetherit's possible to get the storage parameter in there depends on<br /> > how soon someone produces a patch. 
Giventhat we understand this area<br /> > fairly well, I personally would be willing to give it a pass on the<br />
>"feature freeze" rule, as long as we have the patch by say mid-April.<br /><br /> If I had to end of April, I'd
volunteer. Alas, I will be unavailable<br /> between tomorrow and mid-April.<br /><br /> It seems to me that changing
thedenominator from 4 to something<br /> somewhat higher (16 comes to mind) would probably be "the patch," and<br />
wouldlikely be useful for a fair number of cases.  I'd really like to<br /> see something like this (e.g. - something
thatwould start TOASTing<br /> for, say, tuples > 500 bytes) in 8.3; this seems to me to have the<br /> potential to
bea significant optimization that would be VERY cheap to<br /> implement.  "Low hanging fruit," so to speak.<br /><br
/>EDB might like to use this as a route into a tunable "column store"<br /> some time later; I don't think that should
stopus from an improvement<br /> today...<br /> --<br /> "cbbrowne","@","linuxfinances.info"<br /><a
href="http://www3.sympatico.ca/cbbrowne/rdbms.html">http://www3.sympatico.ca/cbbrowne/rdbms.html</a><br/> "MSDOS didn't
getas bad as it  is overnight -- it took over ten years<br /> of careful development."  --
<dmeggins@aix1.uottawa.ca><br/><br /> ---------------------------(end of broadcast)---------------------------<br
/>TIP 4: Have you searched our list archives?<br /><br />                <a
href="http://archives.postgresql.org">http://archives.postgresql.org</a><br/><br /></font> 

pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: Interaction of PITR backups and Bulkoperationsavoiding WAL
Next
From: Tom Lane
Date:
Subject: Re: Modifying TOAST thresholds