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  (p.luzanov@postgrespro.ru)
Список 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 по дате отправления:

Предыдущее
От: Egor Rogov
Дата:
Сообщение: Re: max_wal_size
Следующее
От: p.luzanov@postgrespro.ru
Дата:
Сообщение: Re: max_wal_size