Re: [Postgresql 8.2.3] autovacuum starting up even after

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.

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