checkpoint_timeout
A configuration parameter defining the maximum time between checkpoints
checkpoint_timeout
is a configuration parameter defining the maximum time between automatic WAL checkpoints.
checkpoint_timeout
was added in PostgreSQL 7.1.
Default value
The default value for checkpoint_timeout
is: 5min
.
Log output
Typical log output(with log_checkpoints
set to "on
") for an automatic checkpoint triggered by a timeout:
[2021-03-29 03:30:48 UTC] LOG: checkpoint starting: time [2021-03-29 03:31:14 UTC] LOG: checkpoint complete: wrote 253 buffers (0.1%); 1 WAL file(s) added, 0 removed, 0 recycled; write=25.697 s, sync=0.014 s, total=25.838 s; sync files=87, longest=0.003 s, average=0.000 s; distance=1464 kB, estimate=5249 kB
Change history
- PostgreSQL 9.6
- maximum value raised to
1d
(commit f2dba881)
- maximum value raised to
- PostgreSQL 7.1
- added (commit b0299c5d)
References
- PostgreSQL documentation: checkpoint_timeout