Wiki / Configuration Parameters

Specifies the maximum amount of memory to be used by each autovacuum worker process. If this value is specified without units, it is taken as kilobytes. It defaults to -1, indicating that the value of maintenance_work_mem should be used instead. The setting has no effect on the behavior of VACUUM when run in other contexts. 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

-1

category

Resource Usage / Memory

context

sighup

documented

true

enumvals

Unknown

extra desc

-1 means use "maintenance_work_mem".

lang

en

max val

2147483647

metadata version

18

min val

-1

name

autovacuum_work_mem

short desc

Sets the maximum memory to be used by each autovacuum worker process.

source

pg-settings-source-snapshot

unit

kB

vartype

integer