Autovacuum Transaction Wraparound

Поиск
Список
Период
Сортировка
От Perumal Raj
Тема Autovacuum Transaction Wraparound
Дата
Msg-id CALvqh4pfm2yOuOJPO3hJ+42MyEMX2kEBYNk17uF4s=dVj=KB1A@mail.gmail.com
обсуждение исходный текст
Ответы Re: Autovacuum Transaction Wraparound  (Adrian Klaver <adrian.klaver@aklaver.com>)
Список 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 по дате отправления:

Предыдущее
От: Sameer Kumar
Дата:
Сообщение: Re: POSTGRES/MYSQL
Следующее
От: Adrian Klaver
Дата:
Сообщение: Re: Autovacuum Transaction Wraparound