Received: from localhost (unknown [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id 1F03F2E0143 for ; Wed, 26 Dec 2007 21:48:24 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.187]) (amavisd-maia, port 10024) with ESMTP id 58213-09 for ; Wed, 26 Dec 2007 21:48:11 -0400 (AST) Received: from kuber.nabble.com (kuber.nabble.com [216.139.236.158]) by postgresql.org (Postfix) with ESMTP id BA1952E0142 for ; Wed, 26 Dec 2007 21:48:16 -0400 (AST) Received: from isper.nabble.com ([192.168.236.156]) by kuber.nabble.com with esmtp (Exim 4.63) (envelope-from ) id 1J7hr4-0001pa-Jw for pgsql-admin@postgresql.org; Wed, 26 Dec 2007 17:48:14 -0800 Message-ID: <14508639.post@talk.nabble.com> Date: Wed, 26 Dec 2007 17:48:14 -0800 (PST) From: "ivan.hou" To: pgsql-admin@postgresql.org Subject: What's the XID? MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Nabble-From: ivan.hou@msa.hinet.net X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=1.422 tagged_above=0 required=5 tests=AWL=-1.022, BAYES_40=-0.185, DNS_FROM_OPENWHOIS=1.13, WHOIS_MYPRIVREG=1.499 X-Spam-Level: * X-Archive-Number: 200712/210 X-Sequence-Number: 27727 http://www.postgresql.org/docs/8.1/interactive/maintenance.html#VACUUM-FOR-WRAPAROUND XID is transcation ID? so, "select * from mydb" is a transcation? if i executed "select * from mydb" twice, the XID wil be increased by 2 or ,just the "update","delete" command can be counted -- View this message in context: http://www.nabble.com/What%27s-the-XID--tp14508639p14508639.html Sent from the PostgreSQL - admin mailing list archive at Nabble.com.