X-Original-To: pgsql-performance-postgresql.org@postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id ECB039FB29B for ; Thu, 7 Sep 2006 07:40:36 -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 42948-07 for ; Thu, 7 Sep 2006 07:40:28 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from my.endian.it (unknown [62.146.87.34]) by postgresql.org (Postfix) with ESMTP id 25C0D9FB299 for ; Thu, 7 Sep 2006 07:40:27 -0300 (ADT) Received: from ultra.home.lan (host170-230.pool875.interbusiness.it [87.5.230.170]) (authenticated (0 bits)) by my.endian.it (8.11.6/8.11.6) with ESMTP id k87AnbT08287; Thu, 7 Sep 2006 12:49:37 +0200 Subject: Re: [PATCHES] Template0 age is increasing speedily. From: Chris Mair To: Nimesh Satam Cc: pgsql-performance@postgresql.org In-Reply-To: <965aa3ed0609070331y5749226eg91de0b376e343c75@mail.gmail.com> References: <965aa3ed0609070331y5749226eg91de0b376e343c75@mail.gmail.com> Content-Type: text/plain Date: Thu, 07 Sep 2006 12:40:25 +0200 Message-Id: <1157625625.28654.4.camel@ultra.home.lan> Mime-Version: 1.0 X-Mailer: Evolution 2.6.3 (2.6.3-1.fc5.5) Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.168 tagged_above=0 required=5 tests=AWL, FORGED_RCVD_HELO X-Spam-Level: X-Archive-Number: 200609/33 X-Sequence-Number: 20719 On Thu, 2006-09-07 at 16:01 +0530, Nimesh Satam wrote: > 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. Hi, first of all: there is no need to cross post on 4 lists. If you have a performance problem, post on pgsql-performance. Second, please tell us which version of PostgreSQL on which operating system you're using. Diagnosing your problem might depend on which OS you use... Finally, explain what you mean by "the age of template0 is increasing very rapidly", you mean "the size is increasing"? Bye, Chris. -- Chris Mair http://www.1006.org