Re: why wal_max_size does not work?

Поиск
Список
Период
Сортировка
От Sergei Kornilov
Тема Re: why wal_max_size does not work?
Дата
Msg-id 5880831585051990@vla1-0bfbe4c1c324.qloud-c.yandex.net
обсуждение исходный текст
Ответ на why wal_max_size does not work?  (Fan Liu <fan.liu@ericsson.com>)
Ответы RE: why wal_max_size does not work?  (Fan Liu <fan.liu@ericsson.com>)
Список pgsql-bugs
Hello

max_wal_size is not the upper limit for pg_wal. Postgresql does not have upper limit for pg_wal at all. This is
documented:

https://www.postgresql.org/docs/10/runtime-config-wal.html
> Maximum size to let the WAL grow to between automatic WAL checkpoints. This is a soft limit; WAL size can exceed
max_wal_sizeunder special circumstances, like under heavy load, a failing archive_command, or a high wal_keep_segments
setting.

so check yours replication slots, archive_command (if archive_mode is enabled), wal_keep_segments

regards, Sergei



В списке pgsql-bugs по дате отправления:

Предыдущее
От: Fan Liu
Дата:
Сообщение: why wal_max_size does not work?
Следующее
От: Alvaro Herrera
Дата:
Сообщение: Re: Postgresql create a core while trying log a message to syslog