PostgreSQL version:

autovacuum_work_mem

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