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@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general