Re: Best practices for data buffer cache setting/tuning (v15) - Mailing list pgsql-general

From Laurenz Albe
Subject Re: Best practices for data buffer cache setting/tuning (v15)
Date
Msg-id 13d41db5853d1e6a14d99958c3798352de576a03.camel@cybertec.at
Whole thread Raw
In response to Best practices for data buffer cache setting/tuning (v15)  (David Gauthier <dfgpostgres@gmail.com>)
List 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 by date:

Previous
From: David Gauthier
Date:
Subject: Best practices for data buffer cache setting/tuning (v15)
Next
From: Alan Hodgson
Date:
Subject: Re: Seeking help extricating data from Amazon RDS Aurora/Postgres