X-Original-To: pgsql-patches-postgresql.org@postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 2A5C09FB284 for ; Thu, 7 Sep 2006 07:31:39 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 39108-10 for ; Thu, 7 Sep 2006 07:31:35 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from wx-out-0506.google.com (wx-out-0506.google.com [66.249.82.229]) by postgresql.org (Postfix) with ESMTP id C33DE9FB262 for ; Thu, 7 Sep 2006 07:31:35 -0300 (ADT) Received: by wx-out-0506.google.com with SMTP id t13so194592wxc for ; Thu, 07 Sep 2006 03:31:34 -0700 (PDT) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:mime-version:content-type; b=jhOedV3BzefctszUjXwJKfqTK2whVTREyaQh8gyWZdkMgo6oZaHZIWnHDI1MXC51z2Xs+g0BKWX1LiVB7FOL+tQYO71TmsAIY4kAHljEt4Rk3e8piepVfwRUX1afaTounXosZwT8Op+x8aFWZa/N3wqUH2bgZx+OQj3SC8SbIeo= Received: by 10.90.25.3 with SMTP id 3mr80299agy; Thu, 07 Sep 2006 03:31:34 -0700 (PDT) Received: by 10.90.93.18 with HTTP; Thu, 7 Sep 2006 03:31:34 -0700 (PDT) Message-ID: <965aa3ed0609070331y5749226eg91de0b376e343c75@mail.gmail.com> Date: Thu, 7 Sep 2006 16:01:34 +0530 From: "Nimesh Satam" To: pgsql-hackers@postgresql.org, pgsql-bugs@postgresql.org, pgsql-patches@postgresql.org, pgsql-performance@postgresql.org Subject: Template0 age is increasing speedily. MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_144483_16459863.1157625094405" X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.2 tagged_above=0 required=5 tests=DNS_FROM_RFC_ABUSE, HTML_MESSAGE, SPF_PASS X-Spam-Level: X-Archive-Number: 200609/139 X-Sequence-Number: 21152 ------=_Part_144483_16459863.1157625094405 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline Hi!.. I noticed that the age of template0 is increasing very rapidly..Can you please let me know how we can control this ....and what causes such problems. We also noticed that the database slow downs heavily at a particular time..Can you suggest any tools which will help in diagnosing the root cause behiond the data load. Regards, Nimesh. ------=_Part_144483_16459863.1157625094405 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline
Hi!..
 
I noticed that the age of  template0 is increasing very rapidly..Can you please let me know how we can control this ....and what causes such problems.
 
We also noticed that the database slow downs heavily at a particular time..Can you suggest any tools which will help in diagnosing the root cause behiond the data load.
 
 
 
Regards,
Nimesh.
------=_Part_144483_16459863.1157625094405--