"ivan.hou" <ivan(dot)hou(at)msa(dot)hinet(dot)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