Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: transaction ID query
- From: Guillaume Lelarge <guillaume(at)lelarge(dot)info>
- To: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
- Cc: Kevin Kempter <kevin(at)kevinkempterllc(dot)com>, pgsql-admin(at)postgresql(dot)org
- Subject: Re: transaction ID query
- Date: Thu, 30 Aug 2007 15:22:59 +0200
- Message-id: <46D6C4B3.1040502@lelarge.info> <text/plain>
Alvaro Herrera a écrit : > Kevin Kempter wrote: > [...] >> b) a list of tables in the db and the last time they were vacuumed > > Examine the pg_stat views, though I am not sure if the vacuum columns > were already in 8.1. In any case, in 8.1 Xid wraparound is tracked > per-database, so you need database-wide vacuums. In 8.2 it is per table > so it is easier to keep up to date. > last vacuum information is available on 8.2, not 8.1. See http://www.postgresql.org/docs/8.2/interactive/monitoring-stats.html Regards. -- Guillaume. <!-- http://abs.traduc.org/ http://lfs.traduc.org/ http://docs.postgresqlfr.org/ -->
- References:
- transaction ID query
- From: Kevin Kempter
- Re: transaction ID query
- From: Alvaro Herrera
- transaction ID query
- Prev by Date: Re: transaction ID query
- Next by Date: Postgres can be started only when one postgres user is logged in
- Previous by thread: Re: transaction ID query
- Next by thread: Postgres can be started only when one postgres user is logged in
- Indexes: