Re: PG 8.3 and large shared buffer settings

Поиск
Список
Период
Сортировка
От Aidan Van Dyk
Тема Re: PG 8.3 and large shared buffer settings
Дата
Msg-id 20090925161542.GK586@oak.highrise.ca
обсуждение исходный текст
Ответ на Re: PG 8.3 and large shared buffer settings  (Scott Carey <scott@richrelevance.com>)
Список pgsql-performance
* Scott Carey <scott@richrelevance.com> [090925 11:57]:
> That won't work well anyway because the postgres shared_buffers dos not cache things that are sequentially scanned
(ituses a ring buffer for each scan).  So, for any data that is only accessed by sequential scan, you're relying on the
OSand the disks.  If you access a table via index scan though, all its pages will go through shared_buffers. 

In older version too, or only since synchronized scans got in?

a.


--
Aidan Van Dyk                                             Create like a god,
aidan@highrise.ca                                       command like a king,
http://www.highrise.ca/                                   work like a slave.

Вложения

В списке pgsql-performance по дате отправления:

Предыдущее
От: Scott Carey
Дата:
Сообщение: Re: PG 8.3 and large shared buffer settings
Следующее
От: Jeff Janes
Дата:
Сообщение: Re: PG 8.3 and large shared buffer settings