Question to transaction ID wraparound

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

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.
Sometimes the number grows by 5 in one second.
I'm also astonished about the fact that all databases grow by the same amount.
Do you have any explanations for this behaviour ?
Why are the numbers growing so quickly ?

Thanks in advance.

Bernd

--
Bernd Lentes
Systemadministration
Institut für Entwicklungsgenetik
HelmholtzZentrum münchen
bernd(dot)lentes(at)helmholtz-muenchen(dot)de
089 3187 1241
http://www.helmholtz-muenchen.de/idg

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Tony Liao 2009-02-25 10:59:27 "like" and index
Previous Message Stefano Nichele 2009-02-24 19:05:45 Re: strange autovacuum behaviour