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
As of PostgreSQL 13. even when log_checkpoints is set to on, there is no indication in the log output that a checkpoint occurred due to the time limit set by checkpoint_timeout being exceeded.
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
Categories
See also
max_wal_size, min_wal_size, checkpoint_warning, checkpoint_flush_after