Hi Semab
ALTER TABLE table SET (
autovacuum_freeze_max_age = 6000,(6 crores)
autovacuum_multixact_freeze_max_age = 6000,(6 crores)
autovacuum_freeze_min_age = 0
);
I set this but autovacuum to prevent wraparound runs for every 10 minutes
on the table being modified in this case
Ho
Hi Durga
*autovacuum_freeze_max_age* specifies the maximum age (in transactions)
that a table's tuples can reach before a vacuum is forced to prevent
transaction ID wraparound. when the age of the oldest tuple in the table
exceeds this value, an autovacuum is triggered to freeze the tuples.
*Recom
