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