Re: Best practices for data buffer cache setting/tuning (v15)

Поиск
Список
Период
Сортировка
От Laurenz Albe
Тема Re: Best practices for data buffer cache setting/tuning (v15)
Дата
Msg-id 13d41db5853d1e6a14d99958c3798352de576a03.camel@cybertec.at
обсуждение исходный текст
Ответ на Best practices for data buffer cache setting/tuning (v15)  (David Gauthier <dfgpostgres@gmail.com>)
Список pgsql-general
Дерево обсуждения 
On Mon, 2024-01-29 at 14:39 -0500, David Gauthier wrote:
> Is there a document which makes recommendations on sizing data buffer cache,
> tuning options which evict old/unused data in mem, and cache fragmentation
> avoidance for a v15.3 DB ?

Start with "shared_buffers" sized as a quarter of the available RAM and
define enough huge pages on the Linux kernel to fit shared buffers.

There are no tuning options for evicting buffers, and there cannot be any
fragmentation.

Yours,
Laurenz Albe

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

Предыдущее
От: David Gauthier
Дата:
Сообщение: Best practices for data buffer cache setting/tuning (v15)
Следующее
От: Alan Hodgson
Дата:
Сообщение: Re: Seeking help extricating data from Amazon RDS Aurora/Postgres