Re: shared_buffers advice

Поиск
Список
Период
Сортировка
От Pierre C
Тема Re: shared_buffers advice
Дата
Msg-id op.u9nxzhryeorkce@localhost
обсуждение исходный текст
Ответ на Re: shared_buffers advice  (Nikolas Everett <nik9000@gmail.com>)
Ответы Re: shared_buffers advice  (Greg Stark <gsstark@mit.edu>)
Re: shared_buffers advice  (Greg Smith <greg@2ndquadrant.com>)
Список pgsql-performance
> I think the logic you are referring to is the clock sweep buffer
> accounting
> scheme.  That just makes sure that the most popular pages stay in the
> buffers.  If your entire db fits in the buffer pool then it'll all get in
> there real fast.


Actually, I meant that in the case of a seq scan, PG will try to use just
a few buffers (a ring) in shared_buffers instead of thrashing the whole
buffers. But if there was actually a lot of free space in shared_buffers,
do the pages stay, or do they not ?

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

Предыдущее
От: Nikolas Everett
Дата:
Сообщение: Re: shared_buffers advice
Следующее
От: Tom Lane
Дата:
Сообщение: Re: shared_buffers advice