Received: from localhost (unknown [200.46.204.182]) by postgresql.org (Postfix) with ESMTP id DE7552E2DE1 for ; Wed, 2 Jan 2008 00:52:07 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.182]) (amavisd-maia, port 10024) with ESMTP id 17970-02 for ; Wed, 2 Jan 2008 00:52:03 -0400 (AST) Received: from kuber.nabble.com (kuber.nabble.com [216.139.236.158]) by postgresql.org (Postfix) with ESMTP id 1DBB62E031B for ; Wed, 2 Jan 2008 00:52:04 -0400 (AST) Received: from isper.nabble.com ([192.168.236.156]) by kuber.nabble.com with esmtp (Exim 4.63) (envelope-from ) id 1J9vaE-0006KE-LV for pgsql-admin@postgresql.org; Tue, 01 Jan 2008 20:52:02 -0800 Message-ID: <14573789.post@talk.nabble.com> Date: Tue, 1 Jan 2008 20:52:02 -0800 (PST) From: "ivan.hou" To: pgsql-admin@postgresql.org Subject: Re: What's the XID? In-Reply-To: <20071227154243.GF8160@crankycanuck.ca> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Nabble-From: ivan.hou@msa.hinet.net References: <14508639.post@talk.nabble.com> <20071227154243.GF8160@crankycanuck.ca> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.267 tagged_above=0 required=5 tests=AWL=0.237, BAYES_00=-2.599, DNS_FROM_OPENWHOIS=1.13, WHOIS_MYPRIVREG=1.499 X-Spam-Level: X-Archive-Number: 200801/4 X-Sequence-Number: 27778 how can i prove that the xid had been increased by 1? i do a test, step 1. SELECT datname, age(datfrozenxid) FROM pg_database; --> mydb age:33183 step 2. SELECT datname, age(datfrozenxid) FROM pg_database; --> mydb age:33188 step 3. SELECT datname, age(datfrozenxid) FROM pg_database; --> mydb age:33193 why always increased by 5? Postgresql Ver:8.1.3 using pgAdminIII Query window Andrew Sullivan wrote: > > On Wed, Dec 26, 2007 at 05:48:14PM -0800, ivan.hou wrote: >> >> XID is transcation ID? > > Yes. > >> so, "select * from mydb" is a transcation? > > Yes. > >> if i executed "select * from mydb" twice, the XID wil be increased by 2 > > Yep. Whereas if you did > > BEGIN; > SELECT 1; > SELECT 1; > COMMIT; > > the xid would be increased by 1. > > A > > ---------------------------(end of broadcast)--------------------------- > TIP 7: You can help support the PostgreSQL project by donating at > > http://www.postgresql.org/about/donate > > -- View this message in context: http://www.nabble.com/What%27s-the-XID--tp14508639p14573789.html Sent from the PostgreSQL - admin mailing list archive at Nabble.com.