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
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 |