So..we dont have to check the last XID value per table ? we have a very high volume data warehouse for which autovacuum is not suitable due to performance reasons. Can we track the last XID on a per-table basis ? 2009/8/11 Alvaro Herrera <alvherre@xxxxxxxxxxxxxxxxx>: > 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 Herrera http://www.CommandPrompt.com/ > The PostgreSQL Company - Command Prompt, Inc. > -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
