Re: max_wal_size - Mailing list pgsql-docs

From David G. Johnston
Subject Re: max_wal_size
Date
Msg-id CAKFQuwZOwfUwOxNh5KjUjCSFaecUWxtHEbPHEK8CJF1+zn9Bjg@mail.gmail.com
Whole thread Raw
In response to max_wal_size  (PG Doc comments form <noreply@postgresql.org>)
Responses Re: max_wal_size
List pgsql-docs
On Wed, May 27, 2020 at 8:18 AM PG Doc comments form <noreply@postgresql.org> wrote:
The following documentation comment has been logged on the website:

Page: https://www.postgresql.org/docs/12/runtime-config-wal.html
Description:

About parameter max_wal_size the documentation says that "Maximum size to
let the WAL grow to between automatic WAL checkpoints."
Is it correct?
The size between automatic WAL checkpoints or the size of the whole pg_wal
directory?

Reading on... "This is a soft limit; WAL size can exceed max_wal_size under special circumstances"

The database doesn't provide an option that would basically mean "make sure the wal directory doesn't get larger than X even if that means that it will become corrupted should it crash".

This setting is the indirect means to ensure that the WAL directory doesn't get too large by forcing a checkpoint thus allowing the corresponding WAL to be removed.

David J.

pgsql-docs by date:

Previous
From: Egor Rogov
Date:
Subject: Re: max_wal_size
Next
From: p.luzanov@postgrespro.ru
Date:
Subject: Re: max_wal_size