Hey, > Tom Lane <tgl <at> sss.pgh.pa.us> writes: > > Dushyanth <dushyanth <at> gmail.com> writes: > >> Does "show autovacuum" confirm that it's off? > > > Yes. > > > # show autovacuum; > > autovacuum > > ------------ > > off > > (1 row) > > Then the only other possibility is that autovacuum is being launched to > prevent XID wraparound. Are there any tables in that database with > particularly old relfrozenxid? Try something like > > select relname, age(relfrozenxid) from pg_class > where relkind in ( 'r', 't') order by 2 desc; Below are the unique age(relfrozenxid) values that i see from the above query # psql -U postgres -d dbname -c "select relname, age(relfrozenxid) from pg_class where relkind in ( 'r', 't') order by 2 desc;" | awk '{print $3}' | sort | uniq 140835139 150945753 185741480 They are all under 200 million - Also please refer to http://archives.postgresql.org/pgsql-general/2008-07/msg00195.php. I have provided more details in here. Thanks Dushyanth