Re: max_wal_size
| От | David G. Johnston |
|---|---|
| Тема | Re: max_wal_size |
| Дата | |
| Msg-id | CAKFQuwZOwfUwOxNh5KjUjCSFaecUWxtHEbPHEK8CJF1+zn9Bjg@mail.gmail.com обсуждение исходный текст |
| Ответ на | max_wal_size (PG Doc comments form <noreply@postgresql.org>) |
| Ответы |
Re: max_wal_size
|
| Список | 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 по дате отправления: