Postgres Pro
Downloads
Home   >   mailing lists

Re: autovacuum - Mailing list pgsql-admin

From David G. Johnston
Subject Re: autovacuum
Date
Msg-id CAKFQuwaMPSBSfvQ7NCmhOPYrrfMeec9h6DmoMSECnkX63YiT7Q@mail.gmail.com
Whole thread Raw
In response to autovacuum  (Henry Francisco Garcia Cortez <garcortez@gmail.com>)
List pgsql-admin
Tree view
On Friday, October 23, 2020, Henry Francisco Garcia Cortez <garcortez@gmail.com> 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:


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

Note the “each”

David J.

pgsql-admin by date:

Previous
From: Henry Francisco Garcia Cortez
Date:
Subject: autovacuum
Next
From: Lars Aksel Opsahl
Date:
Subject: Re: free(): invalid pointer , when to dumping data to a new server