Wiki / Configuration Parameters

Write a message to the server log if checkpoints caused by the filling of WAL segment files happen closer together than this amount of time (which suggests that max_wal_size ought to be raised). If this value is specified without units, it is taken as seconds. The default is 30 seconds (30s). Zero disables the warning. No warnings will be generated if checkpoint_timeout is less than checkpoint_warning. 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.

boot val

30

category

Write-Ahead Log / Checkpoints

context

sighup

documented

true

enumvals

Unknown

extra desc

Write a message to the server log if checkpoints caused by the filling of WAL segment files happen more frequently than this amount of time. 0 disables the warning.

lang

en

max val

2147483647

metadata version

18

min val

0

name

checkpoint_warning

short desc

Sets the maximum time before warning if checkpoints triggered by WAL volume happen too frequently.

source

pg-settings-source-snapshot

unit

s

vartype

integer