Re: Question to transaction ID wraparound - Mailing list pgsql-admin

From AmitKumar Jain
Subject Re: Question to transaction ID wraparound
Date
Msg-id 49A6BA6E.2030601@synechron.com
Whole thread Raw
In response to Re: Question to transaction ID wraparound  ("Lentes, Bernd" <bernd.lentes@helmholtz-muenchen.de>)
Responses Re: Question to transaction ID wraparound  ("Lentes, Bernd" <bernd.lentes@helmholtz-muenchen.de>)
List pgsql-admin
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@synechron.com
Synechron:
- A CMMi Level 3 Certified Company
- Top 5 Best Employers (Dataquest Magazine)
- Emerging India Finalist (CNBC India )

pgsql-admin by date:

Previous
From: "Lentes, Bernd"
Date:
Subject: Re: Question to transaction ID wraparound
Next
From: "Lentes, Bernd"
Date:
Subject: Re: Question to transaction ID wraparound