On 27.05.2020 13:16, Andreas Kretschmer wrote:
Am 27.05.20 um 12:11 schrieb Pavel Luzanov:
Hello,
About parameter max_wal_size the documentation
<https://www.postgresql.org/docs/current/runtime-config-wal.html#GUC-MAX-WAL-SIZE>
says: "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 all WAL
files in the pg_wal directory?
size between checkpoints, size of all wal's can be higher, see
wal_keep_segments.
It is clear that total size can be higher due to wal_keep_segments,
replications slots, archive_command etc.
But does max_wal_size relate to the (a) two subsequent checkpoints (as
you may read the wording in the docs) or (b) to the past completed
checkpoint AND the current yet-uncompleted checkpoint (which together
may be up to TWO checkpoint intervals)?
If I read CalculateCheckpointSegments() in xlog.c correctly, the answer
is (b), and hence the documentation is misleading.
Regards,
Egor.