Toggle navigation

autovacuum_work_mem

Type: integer
Default: -1
Min: -1
Max: 2147483647
Unit: KB
Context: sighup
Restart: false
Since: 9.4

Specifies the maximum amount of memory to be used by each autovacuum worker process. 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.

Recommendations

Set a limit on this which is based on the number of autovac workers you expect to have running.

Comments