Re: why wal_max_size does not work?

From: Sergei Kornilov <sk(at)zsrv(dot)org>
To: Fan Liu <fan(dot)liu(at)ericsson(dot)com>, PostgreSQL mailing lists <pgsql-bugs(at)lists(dot)postgresql(dot)org>
Subject: Re: why wal_max_size does not work?
Date: 2020-03-24 12:32:46
Message-ID: 5880831585051990@vla1-0bfbe4c1c324.qloud-c.yandex.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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_size under 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

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Alvaro Herrera 2020-03-24 14:59:12 Re: Postgresql create a core while trying log a message to syslog
Previous Message Fan Liu 2020-03-24 12:06:35 why wal_max_size does not work?