Received: from localhost (unknown [200.46.204.182]) by postgresql.org (Postfix) with ESMTP id ABCAD2E2385 for ; Wed, 2 Jan 2008 22:28:34 -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 79687-01 for ; Wed, 2 Jan 2008 22:28:23 -0400 (AST) Received: from kuber.nabble.com (kuber.nabble.com [216.139.236.158]) by postgresql.org (Postfix) with ESMTP id 7F3F92E1C02 for ; Wed, 2 Jan 2008 22:28:29 -0400 (AST) Received: from isper.nabble.com ([192.168.236.156]) by kuber.nabble.com with esmtp (Exim 4.63) (envelope-from ) id 1JAFop-0001Ni-Cs for pgsql-admin@postgresql.org; Wed, 02 Jan 2008 18:28:27 -0800 Message-ID: <14590661.post@talk.nabble.com> Date: Wed, 2 Jan 2008 18:28:27 -0800 (PST) From: "ivan.hou" To: pgsql-admin@postgresql.org Subject: Re: What's the XID? In-Reply-To: <477B4D37.4090105@lelarge.info> 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> <14573789.post@talk.nabble.com> <9801.1199251949@sss.pgh.pa.us> <477B4D37.4090105@lelarge.info> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.243 tagged_above=0 required=5 tests=AWL=0.213, BAYES_00=-2.599, DNS_FROM_OPENWHOIS=1.13, WHOIS_MYPRIVREG=1.499 X-Spam-Level: X-Archive-Number: 200801/31 X-Sequence-Number: 27805 how do u know this theory ? 1 + (2 * number of columns in the SELECT) just try & test? or have any document? Guillaume Lelarge-3 wrote: > > Tom Lane wrote: >> "ivan.hou" writes: >>> step 1. SELECT datname, age(datfrozenxid) FROM pg_database; >>> --> mydb age:33183 >>> step 2. SELECT datname, age(datfrozenxid) FROM pg_database; >>> --> mydb age:33188 >> >>> why always increased by 5? >> >> If you do it directly in psql, it increases by 1. >> >>> Postgresql Ver:8.1.3 >>> using pgAdminIII Query window >> >> Perhaps you should ask the pgAdmin people what they're doing behind your >> back ... > > We first send the query to the database. For each returned column, we > send two queries. The first one gives us the type's name of the column > and the second one gives us the OID of the base type. So, each query > executed with pgAdmin's query tool should increase age(datfrozenxid) by : > 1 + (2 * number of columns in the SELECT) > > Regards. > > > -- > Guillaume. > http://www.postgresqlfr.org > http://dalibo.com > > ---------------------------(end of broadcast)--------------------------- > TIP 2: Don't 'kill -9' the postmaster > > -- View this message in context: http://www.nabble.com/What%27s-the-XID--tp14508639p14590661.html Sent from the PostgreSQL - admin mailing list archive at Nabble.com.