Re: Question to transaction ID wraparound

From: "Lentes, Bernd" <bernd(dot)lentes(at)helmholtz-muenchen(dot)de>
To: <pgsql-admin(at)postgresql(dot)org>
Subject: Re: Question to transaction ID wraparound
Date: 2009-02-27 10:30:48
Message-ID: 93739F94E0F3BA43AD72423E2482341AE064BF@sw-rz010.gsf.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

> -----Ursprüngliche Nachricht-----
> Von: Scott Marlowe [mailto:scott(dot)marlowe(at)gmail(dot)com]
> Gesendet: Freitag, 27. Februar 2009 11:04
> An: Lentes, Bernd
> Cc: pgsql-admin(at)postgresql(dot)org
> Betreff: Re: [ADMIN] Question to transaction ID wraparound
>
> On Wed, Feb 25, 2009 at 3:05 AM, Lentes, Bernd
> <bernd(dot)lentes(at)helmholtz-muenchen(dot)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.
>
Scott Marlowe wrote:
> 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.
>
Thanks, Scott
Things become to come clear for me.
I was _very_astonished_ that this number was growing so rapidly.
The number grows by 1 every second.
Is that normal ?

Bernd

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Lentes, Bernd 2009-02-27 11:42:13 Re: Question to transaction ID wraparound
Previous Message Scott Marlowe 2009-02-27 10:03:49 Re: Question to transaction ID wraparound