Re: Question to transaction ID wraparound

On Wed, Feb 25, 2009 at 3:05 AM, Lentes, Bernd
<bernd.lentes@helmholtz-muenchen.de> wrote:
> Hello ML,
>
> I'm very new to Postgres.
> In the log, i got messages concerning transaction ID wraparound.
> I red the documentation and made a vaccum on that database.
> In the documentation i also found the hint to look in the database with
> "SELECT datname, age(datfrozenxid) FROM pg_database;", which i did.
> I did the command several times in a few seconds, and this number is growing very quickly,
> although i'm not expecting transactions in the database.

Please note that nearly EVERYTHING that happens in postgres is a
transaction.  if you type a single command, boom, it's a transaction.
You actually get fewer transaction events if you enclose a bunch of
stuff in begin; commit; pairs than if you run single commands.