Postgres Pro
Downloads
Home   >   mailing lists

autovacuum - Mailing list pgsql-admin

From Henry Francisco Garcia Cortez
Subject autovacuum
Date
Msg-id CAJP2v3GrSgSq-yTx+x_gau=F_4FujZRaoB6HsJUJ9sLQW5bmsA@mail.gmail.com
Whole thread Raw
Responses Re: autovacuum
List pgsql-admin
Tree view
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



pgsql-admin by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: Odd pg dump error: cache lookup failure
Next
From: "David G. Johnston"
Date:
Subject: Re: autovacuum