max_wal_size
A GUC parameter determining how large uncheckpointed WAL can grow before an automatic checkpoint is issued
max_wal_size is a GUC parameter determining how large uncheckpointed WAL can grow before an automatic checkpoint is issued.
max_wal_size was introduced in PostgreSQL 9.5; together with min_wal_size it replaces checkpoint_segments.
Default
Default value for max_wal_size is 1GB.
Change history
- PostgreSQL 9.5
- added, superseding
checkpoint_segments(commit 88e98230)
- added, superseding
References
- PostgreSQL documentation: max_wal_size
Useful links
- Basics of Tuning Checkpoints - November 2016 blog article by 2ndQuadrant
- Checkpoint distance and amount of WAL - January 2017 blog article by CyberTec