Re: Postgres Parameters - Mailing list pgsql-admin

From Laurenz Albe
Subject Re: Postgres Parameters
Date
Msg-id ab2f49d04aa30f8382000d309b0eae491d9e8e64.camel@cybertec.at
Whole thread Raw
In response to Postgres Parameters  (Sam Stearns <sam.stearns@dat.com>)
List pgsql-admin
On Mon, 2025-11-10 at 15:28 -0800, Sam Stearns wrote:
> Could someone advise on how to determine the correct settings for the following, please?:
>
>  * checkpoint_timeout
>  * max_wal_size

Leave "checkpoint_timeout" as it is, and increase "max_wal_size" to 10GB.
Wait, and if pg_stat_checkpointer tells you that many checkpoints are *not*
triggered by timeout, increase "max_wal_size".

Yours,
Laurenz Albe



pgsql-admin by date:

Previous
From: Ron Johnson
Date:
Subject: Re: Postgres Parameters
Next
From: Fabrice Chapuis
Date:
Subject: Re: Postgres Parameters