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@aklaver.com