Autovacuum Transaction Wraparound - Mailing list pgsql-general

From Perumal Raj
Subject Autovacuum Transaction Wraparound
Date
Msg-id CALvqh4pfm2yOuOJPO3hJ+42MyEMX2kEBYNk17uF4s=dVj=KB1A@mail.gmail.com
Whole thread Raw
Responses Re: Autovacuum Transaction Wraparound  (Adrian Klaver <adrian.klaver@aklaver.com>)
List pgsql-general
Hi Experts

I have noticed in my Database that, there is no regular Vacuum maintenance happening
So i started Weekly Job across cluster. But still i am seeing gradual growth on transacation ID. 

DB is still using default autovacuum_freeze_min_age & autovacuum_freeze_table_age.

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 

pgsql-general by date:

Previous
From: Sameer Kumar
Date:
Subject: Re: POSTGRES/MYSQL
Next
From: Adrian Klaver
Date:
Subject: Re: Autovacuum Transaction Wraparound