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

Categories

Checkpoints, GUC configuration item, Performance, WAL

See also

max_wal_size, min_wal_size, checkpoint_warning, checkpoint_flush_after, checkpoint_completion_target