autovacuum

From: Henry Francisco Garcia Cortez <garcortez(at)gmail(dot)com>
To: pgsql-admin(at)lists(dot)postgresql(dot)org
Subject: autovacuum
Date: 2020-10-23 22:02:58
Message-ID: CAJP2v3GrSgSq-yTx+x_gau=F_4FujZRaoB6HsJUJ9sLQW5bmsA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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 ram also I want
to know if I increase the numbers of autovacuum, I have read that CPU
increases around of 10% or 20% this increases is for all the autovacuum or
every autovacuum

--
Ing. Henry G. Cortez

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message David G. Johnston 2020-10-23 22:32:23 Re: autovacuum
Previous Message Alvaro Herrera 2020-10-23 18:51:44 Re: Odd pg dump error: cache lookup failure