documention wrong or just not clear?

From: Robert Treat <xzilla(at)users(dot)sourceforge(dot)net>
To: pgsql-docs(at)postgresql(dot)org
Subject: documention wrong or just not clear?
Date: 2007-03-22 21:15:20
Message-ID: 200703221715.20418.xzilla@users.sourceforge.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-docs

In http://www.postgresql.org/docs/8.2/static/routine-vacuuming.html it says:

"The age column measures the number of transactions from the cutoff XID to the
current transaction's XID. Immediately after a VACUUM, age(relfrozenxid)
should be a little more than the vacuum_freeze_min_age setting that was used
(more by the number of transactions started since the VACUUM started). "

However my results don't seem to bear that out:

postgres=# show vacuum_freeze_min_age;
vacuum_freeze_min_age
-----------------------
100000000
(1 row)
postgres=# VACUUM ;
VACUUM
postgres=# select min (age(relfrozenxid)) from pg_class where relkind = 'r';
min
--------
253045
(1 row)

--
Robert Treat
Build A Brighter LAMP :: Linux Apache {middleware} PostgreSQL

Responses

Browse pgsql-docs by date

  From Date Subject
Next Message Tom Lane 2007-03-22 21:29:08 Re: documention wrong or just not clear?
Previous Message Dave Page 2007-03-22 20:47:38 Re: Re: [DOCS] suggestion for improving TMPDIR and "--format" docs for pg_dump