X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 237D6D1B1CA for ; Sun, 6 Jun 2004 07:40:33 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 18105-07 for ; Sun, 6 Jun 2004 10:40:26 +0000 (GMT) Received: from main.gmane.org (main.gmane.org [80.91.224.249]) by svr1.postgresql.org (Postfix) with ESMTP id A7BC9D1B187 for ; Sun, 6 Jun 2004 07:40:22 -0300 (ADT) Received: from root by main.gmane.org with local (Exim 3.35 #1 (Debian)) id 1BWv4i-0000Wu-00 for ; Sun, 06 Jun 2004 12:40:24 +0200 Received: from srv.protecting.net ([212.126.218.242]) by main.gmane.org with esmtp (Gmexim 0.1 (Debian)) id 1AlnuQ-0007hv-00 for ; Sun, 06 Jun 2004 12:40:24 +0200 Received: from hf517 by srv.protecting.net with local (Gmexim 0.1 (Debian)) id 1AlnuQ-0007hv-00 for ; Sun, 06 Jun 2004 12:40:24 +0200 X-Injected-Via-Gmane: http://gmane.org/ To: pgsql-performance@postgresql.org From: Harald Fuchs Subject: Re: Slow in morning hours Date: 05 Jun 2004 22:54:31 +0200 Organization: Linux Private Site Lines: 21 Message-ID: References: <4BAFBB6B9CC46F41B2AD7D9F4BBAF78508C847@vt-pe2550-001.vantage.vantage.com> <40361DBE.3636.10FEBF@localhost> Reply-To: hf517@protecting.net Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Complaints-To: usenet@sea.gmane.org X-Gmane-NNTP-Posting-Host: srv.protecting.net User-Agent: Gnus/5.0808 (Gnus v5.8.8) Emacs/20.7 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=1.3 tagged_above=0.0 required=5.0 tests=DATE_IN_PAST_12_24, FROM_ENDS_IN_NUMS X-Spam-Level: * X-Archive-Number: 200406/48 X-Sequence-Number: 7106 In article <40361DBE.3636.10FEBF@localhost>, writes: > 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 !! I guess you're doing a VACUUM at night which invalidates the buffer cache. If that's what happens, it's easy to fix: run some dummy queries after the VACUUM which cause the buffer cache to get filled.