Home > mailing lists

transaction ID query - Mailing list pgsql-admin

From	Kevin Kempter
Subject	transaction ID query
Date	August 30, 2007 12:50:09
Msg-id	200708300647.36023.kevin@kevinkempterllc.com Whole thread Raw
Responses	Re: transaction ID query (Alvaro Herrera <alvherre@commandprompt.com>)
List	pgsql-admin

Tree view

Hi List;

can I run queries to see the following for postgres v 8.1.4:

a) where the db is per used transaction ID's (want to avoid a transaction ID
wrap-around scenario)

b) a list of tables in the db and the last time they were vacuumed


Thanks in advance

/Kevin

pgsql-admin by date:

From: Tom Lane
Date: 29 August 2007, 23:06:52
Subject: Re: reindexdb hangs

From: Alvaro Herrera
Date: 30 August 2007, 13:12:59
Subject: Re: transaction ID query

transaction ID query - Mailing list pgsql-admin

Previous

Next