Re: TOAST usage setting

Поиск
Список
Период
Сортировка
От Bruce Momjian
Тема Re: TOAST usage setting
Дата
Msg-id 200706072331.l57NVBm17383@momjian.us
обсуждение исходный текст
Ответ на Re: TOAST usage setting  (Gregory Stark <stark@enterprisedb.com>)
Ответы Re: TOAST usage setting  (Gregory Stark <stark@enterprisedb.com>)
Список 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 по дате отправления:

Предыдущее
От: Gregory Stark
Дата:
Сообщение: Re: [COMMITTERS] pgsql: Avoid losing track of data for shared tables in pgstats.
Следующее
От: Josh Berkus
Дата:
Сообщение: Re: .conf File Organization WAS: Controlling Load Distributed Checkpoints