Received: from localhost (unknown [200.46.204.183])
	by mail.postgresql.org (Postfix) with ESMTP id 0F2CC632C27
	for <pgsql-admin-postgresql.org@mail.postgresql.org>;
	Thu, 26 Feb 2009 11:51:34 -0400 (AST)
Received: from mail.postgresql.org ([200.46.204.86])
	by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024)
	with ESMTP id 06776-09 for
	<pgsql-admin-postgresql.org@mail.postgresql.org>;
	Thu, 26 Feb 2009 11:51:29 -0400 (AST)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.6
Received: from mail.synechron.com (mail.synechron.com [74.205.14.240])
	by mail.postgresql.org (Postfix) with ESMTP id 497696326D9
	for <pgsql-admin@postgresql.org>; Thu, 26 Feb 2009 11:51:27 -0400 (AST)
Received: from [10.31.9.119] [220.225.40.2] by mail.synechron.com with ESMTP
	(SMTPD-10.02) id AA7A0F48; Thu, 26 Feb 2009 10:51:22 -0500
Message-ID: <49A6BA6E.2030601@synechron.com>
Date: Thu, 26 Feb 2009 21:21:10 +0530
From: AmitKumar Jain <amitjain@synechron.com>
User-Agent: Thunderbird 2.0.0.19 (Windows/20081209)
MIME-Version: 1.0
To: "Lentes, Bernd" <bernd.lentes@helmholtz-muenchen.de>
CC: pgsql-admin@postgresql.org
Subject: Re: Question to transaction ID wraparound
References: <AcmXMKWfyPnyVS9VS9eO7pbRKbfVIw==>
	<93739F94E0F3BA43AD72423E2482341AE064B7@sw-rz010.gsf.de>
	<16b031c0902260715k3dad5765te222578a0cdab169@mail.gmail.com>
	<93739F94E0F3BA43AD72423E2482341AE064B9@sw-rz010.gsf.de>
In-Reply-To: <93739F94E0F3BA43AD72423E2482341AE064B9@sw-rz010.gsf.de>
Content-Type: multipart/alternative;
	boundary="------------060604000002020905040605"
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=2.433 tagged_above=0 required=5
	tests=DNS_FROM_OPENWHOIS=2.431, HTML_MESSAGE=0.001, WHOIS_NETSOLPR=0.001
X-Spam-Level: **
X-Archive-Number: 200902/239
X-Sequence-Number: 31460

This is a multi-part message in MIME format.
--------------060604000002020905040605
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

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 )
*****

--------------060604000002020905040605
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit

<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
  <meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
Its a log analyzer tool through which you can trap the running queries
and have reports about update/delete/insterts which are executing at&nbsp;
database system.<br>
<a class="moz-txt-link-freetext" href="http://pgfouine.projects.postgresql.org/">http://pgfouine.projects.postgresql.org/</a><br>
<br>
<br>
Lentes, Bernd wrote:
<blockquote
 cite="mid:93739F94E0F3BA43AD72423E2482341AE064B9@sw-rz010.gsf.de"
 type="cite">
  <pre wrap="">
Lee Azzarello wrote:
  </pre>
  <blockquote type="cite">
    <blockquote type="cite">
      <pre wrap="">Sometimes the number grows by 5 in one second.
I'm also astonished about the fact that all databases grow 
      </pre>
    </blockquote>
    <pre wrap="">by the same amount.
    </pre>
    <blockquote type="cite">
      <pre wrap="">Do you have any explanations for this behaviour ?
Why are the numbers growing so quickly ?
      </pre>
    </blockquote>
    <pre wrap="">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

    </pre>
  </blockquote>
  <pre wrap=""><!---->I don't have the exact answers to that question.
I think it should be a very tiny work load.
What is pgfouine ?

Bernd

  </pre>
</blockquote>
<br>
<div class="moz-signature">-- <br>
<b><font color="blue">Amit Jain </font><b><br>
<b>Synechron Technology Pvt. Ltd. 4th Floor, B Wing, Block 1.2, Embassy
Techzone,<b><br>
Plot No. PL-3, Rajiv Gandhi Infotech Park Hinjewadi Phase II, Pune 411
057.<br>
Phone : +91.20.40262000 Ext 2162 | Mobile:+91.9373415075 | Fax:
+91.20.30513500 <br>
<a class="moz-txt-link-freetext" href="http://www.synechron.com">http://www.synechron.com</a> | MailTo: <a class="moz-txt-link-abbreviated" href="mailto:amitjain@synechron.com">amitjain@synechron.com</a><br>
<b><font color="red">Synechron:<br>
</font> - A CMMi Level 3 Certified Company<br>
- Top 5 Best Employers (Dataquest Magazine)<br>
- Emerging India Finalist (CNBC India )<br>
</b></b></b></b></b></div>
</body>
</html>

--------------060604000002020905040605--