Received: from localhost (unknown [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id DC8D42E02BD for ; Sun, 30 Dec 2007 23:05:19 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 66737-06 for ; Sun, 30 Dec 2007 23:05:06 -0400 (AST) Received: from kuber.nabble.com (kuber.nabble.com [216.139.236.158]) by postgresql.org (Postfix) with ESMTP id 34F622E0285 for ; Sun, 30 Dec 2007 23:05:15 -0400 (AST) Received: from isper.nabble.com ([192.168.236.156]) by kuber.nabble.com with esmtp (Exim 4.63) (envelope-from ) id 1J9Axk-0000vW-MX for pgsql-admin@postgresql.org; Sun, 30 Dec 2007 19:05:13 -0800 Message-ID: <14553816.post@talk.nabble.com> Date: Sun, 30 Dec 2007 19:05:12 -0800 (PST) From: "ivan.hou" To: pgsql-admin@postgresql.org Subject: Re: What's the XID? In-Reply-To: <24298.1198809970@sss.pgh.pa.us> 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> <11803.1198771221@sss.pgh.pa.us> <17845.1198778124@sss.pgh.pa.us> <24298.1198809970@sss.pgh.pa.us> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.296 tagged_above=0 required=5 tests=AWL=0.266, BAYES_00=-2.599, DNS_FROM_OPENWHOIS=1.13, WHOIS_MYPRIVREG=1.499 X-Spam-Level: X-Archive-Number: 200712/253 X-Sequence-Number: 27770 Tom Lane-2 wrote: > > Jeff Frost writes: >> On Thu, 27 Dec 2007, Tom Lane wrote: >>> There's no global counter. There's a backend-local "virtual transaction >>> id" counter. > >> That's a drag as I have quite a few clients who graph the xacts/sec with >> MRTG. >> Most of these clients have read heavy workloads and it would be great to >> be >> able to graph read vs write xacts, but a drag if you have no visibility >> into >> 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 ?? -- View this message in context: http://www.nabble.com/What%27s-the-XID--tp14508639p14553816.html Sent from the PostgreSQL - admin mailing list archive at Nabble.com.