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:[EMAIL PROTECTED] Sent: Monday, September 18, 2006 1:32 PM To: Sriram Dandapani Cc: pgsql-admin@postgresql.org Subject: Re: [ADMIN] autovacuum ignore tables "Sriram Dandapani" <[EMAIL PROTECTED]> 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 ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
