offtopic, historic, in 8.1, how to find relfrozenxid by table?

Started by Matthew Grossoover 18 years ago2 messageshackers
Jump to latest
#1Matthew Grosso
mgrosso@acm.org

in 8.1, how do I find the relfrozenxid of a table?

we're running 8.1.9, and have turned off autovacuum for a wee bit too
long...

thanks to the verbose warnings, we still have a few million transactions
left before it locks up, although thats not much time for us.

I'd like to focus vacuum on the tables that need it, but 8.1 does not
have a relfrozenxid column in pg_class, although it does have
datfrozenxid in pg_database.

sorry for skipping the general list, but I'm not subscribed to that, and
unsure of the latency there.

thanks,
Matt

--
Matt Grosso
matt.grosso@connexuscorp.com
cell (201)780-9592
http://www.connexuscorp.com/

#2Tom Lane
tgl@sss.pgh.pa.us
In reply to: Matthew Grosso (#1)
Re: offtopic, historic, in 8.1, how to find relfrozenxid by table?

Matthew Grosso <mgrosso@acm.org> writes:

in 8.1, how do I find the relfrozenxid of a table?

You don't ... 8.1 doesn't track that.

regards, tom lane