Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 4CDB82E02A0 for ; Thu, 27 Dec 2007 11:42:52 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 58564-10 for ; Thu, 27 Dec 2007 11:42:49 -0400 (AST) Received: from main2.mycybernet.net (main2.mycybernet.net [209.222.63.140]) by postgresql.org (Postfix) with ESMTP id 9C2022E01E0 for ; Thu, 27 Dec 2007 11:42:49 -0400 (AST) Received: from 227-54-222-209.mycybernet.net ([209.222.54.227] helo=crankycanuck.ca) by main2.mycybernet.net with esmtp (Exim 4.62) (envelope-from ) id 1J7usi-0006Ti-8o for pgsql-admin@postgresql.org; Thu, 27 Dec 2007 10:42:48 -0500 Received: by crankycanuck.ca (Postfix, from userid 1000) id 8CA2D50099; Thu, 27 Dec 2007 10:42:43 -0500 (EST) Date: Thu, 27 Dec 2007 10:42:43 -0500 From: Andrew Sullivan To: pgsql-admin@postgresql.org Subject: Re: What's the XID? Message-ID: <20071227154243.GF8160@crankycanuck.ca> Mail-Followup-To: Andrew Sullivan , pgsql-admin@postgresql.org References: <14508639.post@talk.nabble.com> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <14508639.post@talk.nabble.com> User-Agent: Mutt/1.5.13 (2006-08-11) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200712/211 X-Sequence-Number: 27728 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