max_wal_size
A configuration parameter determining how large uncheckpointed WAL can grow before an automatic checkpoint is executed
max_wal_size
is a configuration parameter determining how large uncheckpointed WAL can grow before an automatic checkpoint
is executed.
max_wal_size
was introduced in PostgreSQL 9.5.
max_wal_size
does not imply an absolute upper limit on the total size of all WAL files
Default value
The default value for max_wal_size
is: 1GB
.
Change history
- PostgreSQL 9.5
- added (commit 88e98230)
max_wal_size
and min_wal_size
replaced checkpoint_segments
.
References
- PostgreSQL documentation: max_wal_size
Useful links
- Tuning max_wal_size in PostgreSQL - March 2022 blog article by EDB
- Checkpoint distance and amount of WAL - January 2017 blog article by CyberTec
- Basics of Tuning Checkpoints - November 2016 blog article by 2ndQuadrant