Re: [Postgresql 8.2.3] autovacuum starting up even after disabling ? - Mailing list pgsql-general

Dushyanth <dushyanth@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;

            regards, tom lane