Wiki / Configuration Parameters

Specifies the size of the Buffer Access Strategy used by the VACUUM and ANALYZE commands. A setting of 0 will allow the operation to use any number of shared_buffers. Otherwise valid sizes range from 128 kB to 16 GB. If the specified size would exceed 1/8 the size of shared_buffers, the size is silently capped to that value. The default value is 2MB. If this value is specified without units, it is taken as kilobytes. This parameter can be set at any time. It can be overridden for VACUUM and ANALYZE when passing the BUFFER_USAGE_LIMIT option. Higher settings can allow VACUUM and ANALYZE to run more quickly, but having too large a setting may cause too many other useful pages to be evicted from shared buffers.

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

boot val

2048

category

Resource Usage / Memory

context

user

documented

true

enumvals

Unknown

extra desc

Unknown

lang

en

max val

16777216

metadata version

18

min val

0

name

vacuum_buffer_usage_limit

short desc

Sets the buffer pool size for VACUUM, ANALYZE, and autovacuum.

source

pg-settings-source-snapshot

unit

kB

vartype

integer