Re: Autovacuum Transaction Wraparound

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