Re: TOAST usage setting - Mailing list pgsql-hackers

From Bruce Momjian
Subject Re: TOAST usage setting
Date
Msg-id 200706072331.l57NVBm17383@momjian.us
Whole thread Raw
In response to Re: TOAST usage setting  (Gregory Stark <stark@enterprisedb.com>)
Responses Re: TOAST usage setting  (Gregory Stark <stark@enterprisedb.com>)
List pgsql-hackers
Gregory Stark wrote:
> "Bruce Momjian" <bruce@momjian.us> writes:
> 
> > Well, it is summarized here:
> >
> >     http://momjian.us/expire/TOAST/SUMMARY.html
> >
> > It made non-TOAST access 2x faster, but TOAST 7x slower, and that seemed
> > like a good compromise.
> 
> Is this still testing with all data fitting in RAM?

Yes.  Having things out of RAM is going to make access even slower, but
it is going to allow the heap to be in RAM more often.

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


pgsql-hackers by date:

Previous
From: Gregory Stark
Date:
Subject: Re: [COMMITTERS] pgsql: Avoid losing track of data for shared tables in pgstats.
Next
From: Josh Berkus
Date:
Subject: Re: .conf File Organization WAS: Controlling Load Distributed Checkpoints