Received: from localhost (unknown [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id 585B02E0260 for ; Sun, 30 Dec 2007 23:45:34 -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 30127-03 for ; Sun, 30 Dec 2007 23:45:21 -0400 (AST) Received: from lists.commandprompt.com (host-159.commandprompt.net [207.173.203.159]) by postgresql.org (Postfix) with ESMTP id AD62C2E00F9 for ; Sun, 30 Dec 2007 23:45:27 -0400 (AST) Received: from [192.168.1.226] (or-69-34-217-90.sta.embarqhsd.net [69.34.217.90]) (authenticated bits=0) by lists.commandprompt.com (8.13.8/8.13.8) with ESMTP id lBV3jKbo030705 (version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=NO); Sun, 30 Dec 2007 19:45:25 -0800 Message-ID: <477865CE.5000305@commandprompt.com> Date: Sun, 30 Dec 2007 19:45:18 -0800 From: "Joshua D. Drake" Organization: Command Prompt, Inc. User-Agent: Thunderbird 2.0.0.9 (Windows/20071031) MIME-Version: 1.0 To: "ivan.hou" CC: pgsql-admin@postgresql.org Subject: Re: What's the XID? References: <14508639.post@talk.nabble.com> <20071227154243.GF8160@crankycanuck.ca> <11803.1198771221@sss.pgh.pa.us> <17845.1198778124@sss.pgh.pa.us> <24298.1198809970@sss.pgh.pa.us> <14553816.post@talk.nabble.com> In-Reply-To: <14553816.post@talk.nabble.com> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Greylist: Sender succeeded SMTP AUTH, not delayed by milter-greylist-4.0 (lists.commandprompt.com [207.173.203.159]); Sun, 30 Dec 2007 19:45:25 -0800 (PST) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200712/254 X-Sequence-Number: 27771 ivan.hou wrote: >>> the read xacts. >> Why aren't you using the pgstats xact counters for that? >> >> regards, tom lane >> >> ---------------------------(end of broadcast)--------------------------- >> TIP 4: Have you searched our list archives? >> >> http://archives.postgresql.org >> >> > if no begin or commit , then the xid would also be increased ?? Yes. If you don't do a begin or commit, then it is a transaction per statement. Joshua D. Drake