Re: [Postgresql 8.2.3] autovacuum starting up even after disabling ?

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