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-26 15:47:18
Message-ID: 93739F94E0F3BA43AD72423E2482341AE064B9@sw-rz010.gsf.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Lee Azzarello wrote:
> > 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 ?
>
> What kind of work load is on the database?
> How frequent are UPDATE/INSERT/DELETE statements called by
> that workload?
>
> If you don't already have the answer to these questions, I
> would recommend a reporting tool like pgfouine to get them easily.
>
> -lee
>
I don't have the exact answers to that question.
I think it should be a very tiny work load.
What is pgfouine ?

Bernd

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message AmitKumar Jain 2009-02-26 15:51:10 Re: Question to transaction ID wraparound
Previous Message Lee Azzarello 2009-02-26 15:15:00 Re: Question to transaction ID wraparound