Re: Modifying TOAST thresholds - Mailing list pgsql-hackers

From Chris Browne
Subject Re: Modifying TOAST thresholds
Date
Msg-id 60wszyaqrw.fsf@dba2.int.libertyrms.com
Whole thread Raw
In response to Re: Modifying TOAST thresholds  (Gregory Stark <stark@enterprisedb.com>)
Responses Re: Modifying TOAST thresholds  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
bruce@momjian.us (Bruce Momjian) writes:
> I have seen no one do peroformance testing of this, so it seems it
> will have to wait for 8.4.

I didn't have time...

I'll see if I can find a decent place to document how to tweak the
threshold, as that seems like it could be worth doing in cases where
it is known that there is benefit to TOASTing smaller tuples for one's
well-understood workload.

(e.g. - we've got a case where dropping the threshold to ~900 bytes
would give us a big win for certain databases and tables.)
-- 
let name="cbbrowne" and tld="linuxfinances.info" in name ^ "@" ^ tld;;
http://linuxfinances.info/info/unix.html
recursion, n:       See recursion.


pgsql-hackers by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: Fwd: How does the partitioned lock manager works?
Next
From: Tom Lane
Date:
Subject: Re: [Fwd: PGBuildfarm member narwhal Branch HEAD Status changed from OK to InstallCheck failure]