Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: transaction id wraparound
- From: "Jim C. Nasby" <jim(at)nasby(dot)net>
- To: Talha Khan <talha(dot)amjad(at)gmail(dot)com>
- Cc: Sriram Dandapani <sdandapani(at)counterpane(dot)com>, pgsql-admin(at)postgresql(dot)org
- Subject: Re: transaction id wraparound
- Date: Thu, 28 Sep 2006 19:40:42 -0500
On Thu, Sep 28, 2006 at 11:58:12AM -0700, Talha Khan wrote: > datfrozenxid column of pg_database row is updated at the completion of any > database wide vacuum operation. The value store here is the cuttoff xid used > by the vacuum operation all xid's older then this cutoffxid are replaced by > theis xid so i think the behaviour being shown by your database is quite > normal. True, but if age(xid) is showing how many transactions have occured since xid then his conclusion that he did 500k transactions between those two snapshots is correct. -- Jim Nasby jim(at)nasby(dot)net EnterpriseDB http://enterprisedb.com 512.569.9461 (cell)
- References:
- transaction id wraparound
- From: Sriram Dandapani
- Re: transaction id wraparound
- From: Talha Khan
- transaction id wraparound
- Prev by Date: Re: [JDBC] number of transactions doubling
- Next by Date: Re: number of transactions doubling
- Previous by thread: Re: transaction id wraparound
- Next by thread: Re: transaction id wraparound
- Indexes: