Scott Marlowe wrote:
> -----Ursprüngliche Nachricht-----
> Von: Scott Marlowe [mailto:scott.marlowe@gmail.com]
> Gesendet: Freitag, 27. Februar 2009 11:04
> An: Lentes, Bernd
> Cc: pgsql-admin@postgresql.org
> Betreff: Re: [ADMIN] 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.
>
Scott, why does the number increase ?
If it says how many transactions are still possible, the number should decrease, not increase.
Bernd