On 3/11/19 11:51 AM, Perumal Raj wrote:
Hi Experts
I have noticed in my Database that, there is no regular Vacuum
maintenance happening
What Postgres version?
So i started Weekly Job across cluster. But still i am seeing gradual
growth on transacation ID.
What query are you using?
DB is still using default autovacuum_freeze_min_age &
autovacuum_freeze_table_age.
What are the actual settings for?:
https://www.postgresql.org/docs/10/runtime-config-autovacuum.html
Question : Since i am running regularly vacuum job ( weekly) and the
Transaction age is gradually growing , What is next once i hit 200M
limit ( default ).
Should i increase my default value ? If so any calculation for increase
the value based on my DB transaction growth.
Thanks,
Raj
--
Adrian Klaver
adrian.klaver@xxxxxxxxxxx
