If I tell autovacuum to ignore the high traffic daily partition tables that get dropped regularly, will it reset the transaction id wraparound counter when it is done? -----Original Message----- From: Tom Lane [mailto:tgl@xxxxxxxxxxxxx] Sent: Monday, September 18, 2006 1:32 PM To: Sriram Dandapani Cc: pgsql-admin@xxxxxxxxxxxxxx Subject: Re: [ADMIN] autovacuum ignore tables "Sriram Dandapani" <sdandapani@xxxxxxxxxxxxxxx> writes: > I am trying to get autovacuum to complete quicker and prevent Xactn > wraparound (currently, it takes very long and due to the fact that I > have to restart the database for maintenance purposes), autovacuum never > finishes.) Why are you restarting the database? There is no "maintenance purpose" I'm aware of that requires routine postmaster restarts. As for suppressing autovac on specific tables, see the pg_autovacuum system catalog. regards, tom lane
