Installing pg_buffercache (was Re: shared_buffers on Big RAM systems)

Поиск
Список
Период
Сортировка
От Ron
Тема Installing pg_buffercache (was Re: shared_buffers on Big RAM systems)
Дата
Msg-id 49ee13f3-036d-06fb-5382-8b38bc2c6a19@gmail.com
обсуждение исходный текст
Ответ на Re: shared_buffers on Big RAM systems  (Rene Romero Benavides <rene.romero.b@gmail.com>)
Ответы Re: Installing pg_buffercache (was Re: shared_buffers on Big RAM systems)
Список pgsql-general
On 12/13/2018 08:25 PM, Rene Romero Benavides wrote:
> This topic seems to be always open to discussion. In my opinion, it 
> depends on how big your work dataset is, there's no use in sizing 
> shared_buffers beyond that size. I think, the most reasonable thing is 
> analyzing each case as proposed here:
> https://www.keithf4.com/a-large-database-does-not-mean-large-shared_buffers/

https://www.postgresql.org/docs/current/pgbuffercache.html

Is this an extension or a shared preload library?  The documentation doesn't 
specify.

Thanks

-- 
Angular momentum makes the world go 'round.


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

Предыдущее
От: Thomas Munro
Дата:
Сообщение: Re: shared_buffers on Big RAM systems
Следующее
От: Guillaume Lelarge
Дата:
Сообщение: Re: Installing pg_buffercache (was Re: shared_buffers on Big RAM systems)