Alvaro Herrera wrote:
Devrim GÜNDÜZ escribió:
FWIW, PostgreSQL 8.3+ will start autovacuum (even if it is turned off)
if a database is approaching XID wraparound, and get rid of the
problem-- so you don't actually need to check it.
8.1 does it too. The main difference is that 8.1 will run a
database-wide vacuum, whereas in 8.2 and up it only vacuum tables that
have not been vacuumed recently.
Alvaro, we had an 8.1 server that did not start autovacuum when XID
wraparound was approaching. Rather, it just stopped performing
transactions, and returned the usual XID wraparound warning.
- Rob
--
Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
