Received: from localhost (unknown [200.46.204.182]) by postgresql.org (Postfix) with ESMTP id DAA492E024E for ; Wed, 2 Jan 2008 01:32:47 -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 36283-06 for ; Wed, 2 Jan 2008 01:32:43 -0400 (AST) Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by postgresql.org (Postfix) with ESMTP id 575652E0193 for ; Wed, 2 Jan 2008 01:32:44 -0400 (AST) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.14.1/8.14.1) with ESMTP id m025WTUA009802; Wed, 2 Jan 2008 00:32:29 -0500 (EST) To: "ivan.hou" cc: pgsql-admin@postgresql.org Subject: Re: What's the XID? In-reply-to: <14573789.post@talk.nabble.com> References: <14508639.post@talk.nabble.com> <20071227154243.GF8160@crankycanuck.ca> <14573789.post@talk.nabble.com> Comments: In-reply-to "ivan.hou" message dated "Tue, 01 Jan 2008 20:52:02 -0800" Date: Wed, 02 Jan 2008 00:32:29 -0500 Message-ID: <9801.1199251949@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200801/5 X-Sequence-Number: 27779 "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 ... regards, tom lane