Postgres Pro
Downloads
Home   >   mailing lists

offtopic, historic, in 8.1, how to find relfrozenxid by table? - Mailing list pgsql-hackers

From Matthew Grosso
Subject offtopic, historic, in 8.1, how to find relfrozenxid by table?
Date
Msg-id 20071117200533.GA7498@connexuscorp.com
Whole thread Raw
Responses Re: offtopic, historic, in 8.1, how to find relfrozenxid by table?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
Tree view 
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/

pgsql-hackers by date:

Previous
From: Euler Taveira de Oliveira
Date:
Subject: wrong behavior using to_char() again
Next
From: Tom Lane
Date:
Subject: Re: offtopic, historic, in 8.1, how to find relfrozenxid by table?