Postgres Pro
Downloads
Home   >   mailing lists

Question to transaction ID wraparound - Mailing list pgsql-admin

From Lentes, Bernd
Subject Question to transaction ID wraparound
Date
Msg-id 93739F94E0F3BA43AD72423E2482341AE064B7@sw-rz010.gsf.de
Whole thread Raw
Responses Re: Question to transaction ID wraparound  (Lee Azzarello <lee@dropio.com>)
Re: Question to transaction ID wraparound  (Scott Marlowe <scott.marlowe@gmail.com>)
Re: Question to transaction ID wraparound  (Scott Marlowe <scott.marlowe@gmail.com>)
List pgsql-admin
Tree view 
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.lentes@helmholtz-muenchen.de
089 3187 1241
http://www.helmholtz-muenchen.de/idg

pgsql-admin by date:

Previous
From: Stefano Nichele
Date:
Subject: Re: strange autovacuum behaviour
Next
From: Tony Liao
Date:
Subject: "like" and index