Re: Postgres Parameters

From: Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>
To: Sam Stearns <sam(dot)stearns(at)dat(dot)com>, Pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org>
Subject: Re: Postgres Parameters
Date: 2025-11-11 08:57:13
Message-ID: ab2f49d04aa30f8382000d309b0eae491d9e8e64.camel@cybertec.at
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Fabrice Chapuis 2025-11-11 11:19:45 Re: Postgres Parameters
Previous Message Ron Johnson 2025-11-11 01:16:50 Re: Postgres Parameters