[pgadmin-support] view the remining # of TX ID's available per db (before TX ID wraparound failure)

[Kevin Kempter]

Hi all;

I want to be sure we know exactly how close we are to a tx id wraparound 
failure.

I ran this:
 
select datname, age(datfrozenxid) from pg_database;

I assume the resulting value is the number of available tx id's left per db, 
is this correct?

Also is there a way in 8.3 to determine which tables need to be vacuum'ed so 
PostgreSQL can reset the tx id values?



Thanks in advance...