DB grow overtime with autovacuum (postgres 9.6.9)

From: Avihai Shoham <avihai(dot)shoham(at)gmail(dot)com>
To: pgsql-admin(at)lists(dot)postgresql(dot)org
Subject: DB grow overtime with autovacuum (postgres 9.6.9)
Date: 2022-03-01 12:20:40
Message-ID: CA+=0ERcG7nz7N-sEPDsKzNn+aMC+Rt2oy=sXe94ieoG61x-W2Q@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi All,

We use postgres 9.6.9
we set the following autovacuum setting , but still the DB grow overtime

autovacuum = on
work_mem= 50MB
wal_buffers= -1
synchronous_commit=off
log_autovacuum_min_duration = 0
autovacuum_vacuum_scale_factor = 0.1
autovacuum_analyze_scale_factor = 0.05
autovacuum_vacuum_threshold = 25
autovacuum_max_workers= 6
autovacuum_naptime = 10s
autovacuum_vacuum_cost_delay = 10ms
autovacuum_vacuum_cost_limit = -1
autovacuum_freeze_max_age = 1000000000
autovacuum_multixact_freeze_max_age = 400000000
autovacuum_work_mem = -1
autovacuum_analyze_threshold = 10

we have
[image: image.png]

any idea ?
DB size grew from 11G to 25G in 2wks.
I read that we may need to increase the max_fsm_pages setting. not sure if
it is needed if we have autovacuum or how to do it if needed?

Thank you all
Avihai

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Tony Farrell 2022-03-01 12:28:44 Re: pgadmin4 install help
Previous Message Yogesh Mahajan 2022-03-01 05:25:22 Re: pgadmin4 install help