Postgres Pro
Downloads
Home   >   mailing lists

Re: What's the XID? - Mailing list pgsql-admin

From Tom Lane
Subject Re: What's the XID?
Date
Msg-id 9801.1199251949@sss.pgh.pa.us
Whole thread Raw
In response to Re: What's the XID?  ("ivan.hou" <ivan.hou@msa.hinet.net>)
Responses Re: What's the XID?  (Guillaume Lelarge <guillaume@lelarge.info>)
List pgsql-admin
Tree view 
"ivan.hou" <ivan.hou@msa.hinet.net> 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

pgsql-admin by date:

Previous
From: "ivan.hou"
Date:
Subject: Re: What's the XID?
Next
From: Guillaume Lelarge
Date:
Subject: Re: What's the XID?