DB grow overtime with autovacuum (postgres 9.6.9) - Mailing list pgsql-admin

From Avihai Shoham
Subject DB grow overtime with autovacuum (postgres 9.6.9)
Date
Msg-id CA+=0ERcG7nz7N-sEPDsKzNn+aMC+Rt2oy=sXe94ieoG61x-W2Q@mail.gmail.com
Whole thread Raw
Responses RE: DB grow overtime with autovacuum (postgres 9.6.9)  (Graham Myers <gmyers@retailexpress.com>)
Autovacuum script  (Avihai Shoham <avihai.shoham@gmail.com>)
List 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.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
Attachment

pgsql-admin by date:

Previous
From: Yogesh Mahajan
Date:
Subject: Re: pgadmin4 install help
Next
From: Tony Farrell
Date:
Subject: Re: pgadmin4 install help