autovacuum ignore tables - Mailing list pgsql-admin

From Sriram Dandapani
Subject autovacuum ignore tables
Date
Msg-id 6992E470F12A444BB787B5C937B9D4DF060E5AE1@ca-mail1.cis.local
Whole thread Raw
Responses Re: autovacuum ignore tables
List pgsql-admin

If I were to specify in the pg_autovacuum catalog that certain high volume partitioned tables(that get dropped daily) be ignored, then when autovacuum finishes, will it update the transaction id wraparound counter (this way, I can get autovacuum to finish quickly )

OR

 

Will I still need to periodically do vacuumdb –a to take care of the wraparound problem.

pgsql-admin by date:

Previous
From: "Sriram Dandapani"
Date:
Subject: number of transactions doubling
Next
From: "Paul B. Anderson"
Date:
Subject: Stored procedure array limits