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

Поиск
Список
Период
Сортировка
От Matthew Grosso
Тема offtopic, historic, in 8.1, how to find relfrozenxid by table?
Дата
Msg-id 20071117200533.GA7498@connexuscorp.com
обсуждение исходный текст
Ответы Re: offtopic, historic, in 8.1, how to find relfrozenxid by table?  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
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 по дате отправления:

Предыдущее
От: Euler Taveira de Oliveira
Дата:
Сообщение: wrong behavior using to_char() again
Следующее
От: Tom Lane
Дата:
Сообщение: Re: offtopic, historic, in 8.1, how to find relfrozenxid by table?