Type: | integer |
Default: | -1 (-1) |
Min: | -1 (-1) |
Max: | 2147483647 (2147483647kB) |
Unit: | KB |
Context: | sighup |
Restart: | false |
Since: | 9.4 |
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.
Recommendations
Set a limit on this which is based on the number of autovac workers you expect to have running.