Wiki / Configuration Parameters

As long as WAL disk usage stays below this setting, old WAL files are always recycled for future use at a checkpoint, rather than removed. This can be used to ensure that enough WAL space is reserved to handle spikes in WAL usage, for example when running large batch jobs. If this value is specified without units, it is taken as megabytes. The default is 80 MB. 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

80

category

Write-Ahead Log / Checkpoints

context

sighup

documented

true

enumvals

Unknown

extra desc

Unknown

lang

en

max val

2147483647

metadata version

18

min val

2

name

min_wal_size

short desc

Sets the minimum size to shrink the WAL to.

source

pg-settings-source-snapshot

unit

MB

vartype

integer