Received: from localhost (maia-5.hub.org [200.46.204.182]) by postgresql.org (Postfix) with ESMTP id 98ADA9FA306 for ; Tue, 28 Aug 2007 17:29:04 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.182]) (amavisd-maia, port 10024) with ESMTP id 94616-04 for ; Tue, 28 Aug 2007 17:28:58 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from main2.mycybernet.net (main2.mycybernet.net [209.222.63.140]) by postgresql.org (Postfix) with ESMTP id 4C2779FA262 for ; Tue, 28 Aug 2007 17:29:01 -0300 (ADT) Received: from 227-54-222-209.mycybernet.net ([209.222.54.227] helo=phlogiston.dydns.org) by main2.mycybernet.net with esmtp (Exim 4.62) (envelope-from ) id 1IQ7gK-0005s1-5M for pgsql-admin@postgresql.org; Tue, 28 Aug 2007 16:29:00 -0400 Received: by phlogiston.dydns.org (Postfix, from userid 1000) id B829D4050; Tue, 28 Aug 2007 16:28:54 -0400 (EDT) Date: Tue, 28 Aug 2007 16:28:54 -0400 From: Andrew Sullivan To: pgsql-admin@postgresql.org Subject: Re: How to monitor resources on Linux. Message-ID: <20070828202854.GB1983@phlogiston.dyndns.org> References: <46D4353F.2040209@the-allgoods.net> <815.1188324416@sss.pgh.pa.us> <46D470D8.2030605@the-allgoods.net> <20070828191143.GE13868@alvh.no-ip.org> <46D47A13.3060907@the-allgoods.net> <20070828195554.GB1683@phlogiston.dyndns.org> <46D48211.8010806@the-allgoods.net> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <46D48211.8010806@the-allgoods.net> User-Agent: Mutt/1.5.9i X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200708/363 X-Sequence-Number: 26694 On Tue, Aug 28, 2007 at 04:14:09PM -0400, John R Allgood wrote: > We were running vacuum and vacuum full daily without the vaccum analyze > on weekends. After about 2 weeks the master database would slow down. That doesn't surprise me. If you have enough writes, the regular vacuum isn't running often enough. The goal is to vacuum "just enough". The vacuum delay stuff in more recent releases is valuable here. > How often do you run VACUUM or are you using the autovacumm daemon. We have a complicated set of scripts that vacuum some tables very often, some other tables less often, yet other tables rarely, and some tables only once a week. Autovacuum is currently in final testing, though, I believe (though it's not my department any more, so liberal salting of my words is needed). -- Andrew Sullivan | ajs@crankycanuck.ca Everything that happens in the world happens at some place. --Jane Jacobs