Re: Question to transaction ID wraparound

From: "Lentes, Bernd" <bernd(dot)lentes(at)helmholtz-muenchen(dot)de>
To: "AmitKumar Jain" <amitjain(at)synechron(dot)com>
Cc: <pgsql-admin(at)postgresql(dot)org>
Subject: Re: Question to transaction ID wraparound
Date: 2009-02-26 16:19:04
Message-ID: 93739F94E0F3BA43AD72423E2482341AE064BA@sw-rz010.gsf.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin




Amit Jain wrote :
Its a log analyzer tool through which you can trap the running
queries and have reports about update/delete/insterts which are
executing at database system.
http://pgfouine.projects.postgresql.org/


Lentes, Bernd wrote:

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

I don't know this tool. I will install it and give
information, when i'm ready.
Bernd

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Lee Azzarello 2009-02-26 16:36:36 Re: index for inet(ip address or ip range)
Previous Message AmitKumar Jain 2009-02-26 15:51:10 Re: Question to transaction ID wraparound