Received: from localhost (wm.hub.org [200.46.204.128]) by postgresql.org (Postfix) with ESMTP id 6CB1E9FB381 for ; Thu, 28 Sep 2006 21:40:59 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.128]) (amavisd-new, port 10024) with ESMTP id 15905-09-2 for ; Fri, 29 Sep 2006 00:40:44 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey- Received: from noel.decibel.org (noel.decibel.org [67.100.216.10]) by postgresql.org (Postfix) with ESMTP id 2222E9FB386 for ; Thu, 28 Sep 2006 21:40:44 -0300 (ADT) Received: by noel.decibel.org (Postfix, from userid 1001) id D9CEB56431; Thu, 28 Sep 2006 19:40:42 -0500 (CDT) Received: (hashcash-sendmail, from uid 1001); Thu, 28 Sep 2006 19:40:42 -0500 Date: Thu, 28 Sep 2006 19:40:42 -0500 From: "Jim C. Nasby" To: Talha Khan Cc: Sriram Dandapani , pgsql-admin@postgresql.org Subject: Re: transaction id wraparound Message-ID: <20060929004041.GL34238@nasby.net> References: <6992E470F12A444BB787B5C937B9D4DF060E5A57@ca-mail1.cis.local> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: X-Operating-System: FreeBSD 6.0-RELEASE-p4 amd64 X-Distributed: Join the Effort! http://www.distributed.net User-Agent: Mutt/1.5.11 X-Hashcash: 1:20:060929:talha.amjad@gmail.com::jQSWoEs0wNt+QIDG:0000000000000000 0000000000000000000000002srY X-Hashcash: 1:20:060929:sdandapani@counterpane.com::rbxzwfxd0cIujcj2:00000000000 0000000000000000000000001UNk X-Hashcash: 1:20:060929:pgsql-admin@postgresql.org::cI/gVptW8xey+ZdJ:00000000000 0000000000000000000000003/cA X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests= X-Spam-Level: X-Archive-Number: 200609/352 X-Sequence-Number: 23266 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@nasby.net EnterpriseDB http://enterprisedb.com 512.569.9461 (cell)