Re: Wal_keep_size - Mailing list pgsql-admin

From Raj
Subject Re: Wal_keep_size
Date
Msg-id CAJk5AtbR9NCx464baRxbAUesjJNgW5sPPRoMa6q_a9edd-47Ng@mail.gmail.com
Whole thread Raw
In response to Re: Wal_keep_size  (Laurenz Albe <laurenz.albe@cybertec.at>)
List pgsql-admin
Thanks for the clarification. 

On Tue, 7 Oct 2025 at 10:58, Laurenz Albe <laurenz.albe@cybertec.at> wrote:
On Tue, 2025-10-07 at 10:22 +0530, Raj wrote:
> If wal_keep_size is more than max_wal_size wouldn't it always trigger checkpoint ?

No.  "max_wal_size" has no direct connection with the size of WAL (and I
think we should have chosen a different name for that parameter).  The
parameter is about the amount of WAL *generated since the latest checkpoint*,
not about the absolute amount of WAL present.

Yours,
Laurenz Albe

pgsql-admin by date:

Previous
From: kaido vaikla
Date:
Subject: Veeam method for pg backup.
Next
From: Sam Stearns
Date:
Subject: Postgres Resource Sizing