A configuration parameter defining the maximum time between checkpoints
checkpoint_timeout was added in PostgreSQL 7.1.
The default value for
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