From: AmitKumar Jain <amitjain@synechron.com>
To: Lentes, Bernd <bernd.lentes@helmholtz-muenchen.de>
Cc: pgsql-admin@postgresql.org
Subject: Re: Question to transaction ID wraparound
Date: Thu, 26 Feb 2009 21:21:10 +0530
Message-ID: <49A6BA6E.2030601@synechron.com> (raw)
In-Reply-To: <93739F94E0F3BA43AD72423E2482341AE064B9@sw-rz010.gsf.de>
References: <AcmXMKWfyPnyVS9VS9eO7pbRKbfVIw==>
<93739F94E0F3BA43AD72423E2482341AE064B7@sw-rz010.gsf.de>
<16b031c0902260715k3dad5765te222578a0cdab169@mail.gmail.com>
<93739F94E0F3BA43AD72423E2482341AE064B9@sw-rz010.gsf.de>
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 )
*****
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: amitjain@synechron.com, bernd.lentes@helmholtz-muenchen.de
Subject: Re: Question to transaction ID wraparound
In-Reply-To: <49A6BA6E.2030601@synechron.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox