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

Dushyanth <dushyanth@[EMAIL PROTECTED]
> 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

-- 
Sent via pgsql-general mailing list (pgsql-general@[EMAIL PROTECTED]
)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general