Re: autovacuum

["David G. Johnston" <david.g.johnston@xxxxxxxxx>]

On Friday, October 23, 2020, Henry Francisco Garcia Cortez <garcortez@xxxxxxxxx> wrote:

Hi community I have a question about autovacuum I want to know if every autovacuum executed to consume everything the memory of autovacuum_work_mem for instance If I have in auto_vacuum_work_mem 1GB and I have three autovacuum these consume 1gb of memory RAM or 3GB of memory

From the documentation:

https://www.postgresql.org/docs/current/runtime-config-resource.html

 Specifies the maximum amount of memory to be used by each autovacuum worker process.

Note the “each”

David J.