X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id AD2A2D1D14B for ; Fri, 20 Feb 2004 12:20:02 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 49929-04 for ; Fri, 20 Feb 2004 08:19:47 -0400 (AST) Received: from fep01-mail.bloor.is.net.cable.rogers.com (fep01-mail.bloor.is.net.cable.rogers.com [66.185.86.71]) by svr1.postgresql.org (Postfix) with ESMTP id 27D40D1B4DE for ; Fri, 20 Feb 2004 08:19:43 -0400 (AST) Received: from phlogiston.dydns.org ([65.49.121.67]) by fep01-mail.bloor.is.net.cable.rogers.com (InterMail vM.5.01.05.12 201-253-122-126-112-20020820) with ESMTP id <20040220121928.BPVN83660.fep01-mail.bloor.is.net.cable.rogers.com@phlogiston.dydns.org> for ; Fri, 20 Feb 2004 07:19:28 -0500 Received: by phlogiston.dydns.org (Postfix, from userid 1000) id 70F733F40; Fri, 20 Feb 2004 07:19:45 -0500 (EST) Date: Fri, 20 Feb 2004 07:19:45 -0500 From: Andrew Sullivan To: pgsql-performance@postgresql.org Subject: Re: Slow in morning hours Message-ID: <20040220121945.GB15383@phlogiston.dyndns.org> Mail-Followup-To: pgsql-performance@postgresql.org References: <4BAFBB6B9CC46F41B2AD7D9F4BBAF78508C847@vt-pe2550-001.vantage.vantage.com> <40361DBE.3636.10FEBF@localhost> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <40361DBE.3636.10FEBF@localhost> User-Agent: Mutt/1.5.4i X-Authentication-Info: Submitted using SMTP AUTH LOGIN at fep01-mail.bloor.is.net.cable.rogers.com from [65.49.121.67] using ID at Fri, 20 Feb 2004 07:19:28 -0500 X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200402/232 X-Sequence-Number: 5756 On Fri, Feb 20, 2004 at 02:46:15PM +0530, vathakar@banas.guj.nic.in wrote: > > After continuous usage of one hour, It gradually starts responding > faster ! This has become every day routine ! > > do u have any idea related to this !!!! Is there any other reason that I > need to check up? What's running on the machine during those hours? Maybe VACUUM is sucking up all your bandwidth. Or your backups. Or some other cron job. Note that 7.2 is pretty old. There are several performance improvements in subsequent versions. A -- Andrew Sullivan