"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