Re: Question to transaction ID wraparound

[AmitKumar Jain <amitjain@xxxxxxxxxxxxx>]

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

  

--
Amit Jain
Synechron Technology Pvt. Ltd. 4th Floor, B Wing, Block 1.2, Embassy Techzone,
Plot No. PL-3, Rajiv Gandhi Infotech Park Hinjewadi Phase II, Pune 411 057.
Phone : +91.20.40262000 Ext 2162 | Mobile:+91.9373415075 | Fax: +91.20.30513500
http://www.synechron.com | MailTo: amitjain@xxxxxxxxxxxxx
Synechron:
- A CMMi Level 3 Certified Company
- Top 5 Best Employers (Dataquest Magazine)
- Emerging India Finalist (CNBC India )