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

From: Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>
To: David Gauthier <dfgpostgres(at)gmail(dot)com>, pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: Best practices for data buffer cache setting/tuning (v15)
Date: 2024-01-29 21:05:11
Message-ID: 13d41db5853d1e6a14d99958c3798352de576a03.camel@cybertec.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Alan Hodgson 2024-01-29 21:12:09 Re: Seeking help extricating data from Amazon RDS Aurora/Postgres
Previous Message David Gauthier 2024-01-29 19:39:03 Best practices for data buffer cache setting/tuning (v15)