↑↓ select↵ open⌫ change scopeOpen full search

PG.CENTER connects PostgreSQL documentation, reference, and ecosystem knowledge. Maintained by Pigsty.

Wiki / Configuration Parameters

checkpoint_timeout

Maximum time between automatic WAL checkpoints. If this value is specified without units, it is taken as seconds. The valid range is between 30 seconds and one day. The default is five minutes (5min). Increasing this parameter can increase the amount of time needed for crash recovery. This parameter can only be set in the postgresql.conf file or on the server command line.

English manual coverage begins with PostgreSQL 7.4. Source history and runtime observations have their own recorded version boundaries.

Reading PG 18·Select a recorded version

boot val
300
category
Write-Ahead Log / Checkpoints
context
sighup
documented
true
enumvals
Unknown
extra desc
Unknown
lang
en
max val
86400
metadata version
18
min val
30
name
checkpoint_timeout
short desc
Sets the maximum time between automatic WAL checkpoints.
source
pg-settings-source-snapshot
unit
s
vartype
integer

Definition PG 18

Maximum time between automatic WAL checkpoints. If this value is specified without units, it is taken as seconds. The valid range is between 30 seconds and one day. The default is five minutes (5min). Increasing this parameter can increase the amount of time needed for crash recovery. This parameter can only be set in the postgresql.conf file or on the server command line.

Compare versions

Source references

Full definition and evidence JSON

Definition sources

center · PostgreSQL 18 · wiki-repair-20261023:38ea3524b9eb1cb2a17fe50f4245c71505bfa12c5488214f253f64a9a8be1347

Text language: en · wiki-repair-20261023:38ea3524b9eb1cb2a17fe50f4245c71505bfa12c5488214f253f64a9a8be1347