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 8548DD1E15F for ; Fri, 20 Feb 2004 14:51:03 +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 97909-07 for ; Fri, 20 Feb 2004 10:51:02 -0400 (AST) Received: from server.pyrenet.fr (server.pyrenet.fr [194.250.190.1]) by svr1.postgresql.org (Postfix) with ESMTP id ED556D1E150 for ; Fri, 20 Feb 2004 10:50:57 -0400 (AST) Received: from localhost (localhost [127.0.0.1]) by localhost.pyrenet.fr (Postfix) with ESMTP id C20012A981; Fri, 20 Feb 2004 15:51:01 +0100 (MET) Received: from server.pyrenet.fr ([127.0.0.1]) by localhost (server [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 29932-06; Fri, 20 Feb 2004 15:51:00 +0100 (MET) Received: from server.pyrenet.fr (server.pyrenet.fr [194.250.190.1]) by server.pyrenet.fr (Postfix) with ESMTP id 3BF4E2A980; Fri, 20 Feb 2004 15:51:00 +0100 (MET) Date: Fri, 20 Feb 2004 15:51:00 +0100 (MET) From: ohp@pyrenet.fr Reply-To: ohp@pyrenet.fr To: vathakar@banas.guj.nic.in Cc: pgsql-performance@postgresql.org Subject: Re: Slow in morning hours In-Reply-To: <40361DBE.3636.10FEBF@localhost> Message-ID: References: <4BAFBB6B9CC46F41B2AD7D9F4BBAF78508C847@vt-pe2550-001.vantage.vantage.com> <40361DBE.3636.10FEBF@localhost> MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII X-Virus-Scanned: by amavisd-new at pyrenet.fr X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200402/235 X-Sequence-Number: 5759 Have you tried VACUUM ANALYZE at least one a day? Regards On Fri, 20 Feb 2004 vathakar@banas.guj.nic.in wrote: > Date: Fri, 20 Feb 2004 14:46:15 +0530 > From: vathakar@banas.guj.nic.in > To: pgsql-performance@postgresql.org > Cc: vathakar@banas.guj.nic.in > Subject: [PERFORM] Slow in morning hours > > Hi All, > > I am using Linux 7.2 and postgresql 7.2. > > Our Office hours are over at 6pm but we use to keep our server > running 24 hours a day. On the second day morning, Our PGSQL > Server becomes very slow. > > 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? > > Please any any idea to get relief daily morning problem !! > > Thanxs, > Vishal > > ---------------------------(end of broadcast)--------------------------- > TIP 2: you can get off all lists at once with the unregister command > (send "unregister YourEmailAddressHere" to majordomo@postgresql.org) > -- Olivier PRENANT Tel: +33-5-61-50-97-00 (Work) 6, Chemin d'Harraud Turrou +33-5-61-50-97-01 (Fax) 31190 AUTERIVE +33-6-07-63-80-64 (GSM) FRANCE Email: ohp@pyrenet.fr ------------------------------------------------------------------------------ Make your life a dream, make your dream a reality. (St Exupery)