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

Dushyanth escribió:

> 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

Weird :-(

Could you fetch from pg_stat_activity the table it's processing, and its
pg_class row and that of its toast table (if any)?

--
Alvaro Herrera                                http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.