Received: from localhost (maia-4.hub.org [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id EDDCE9F9E46 for ; Tue, 28 Aug 2007 16:56:04 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 17525-03 for ; Tue, 28 Aug 2007 16:56:00 -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 D894B9F9CA8 for ; Tue, 28 Aug 2007 16:56:00 -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 1IQ7AN-0004HM-N1 for pgsql-admin@postgresql.org; Tue, 28 Aug 2007 15:55:59 -0400 Received: by phlogiston.dydns.org (Postfix, from userid 1000) id 3F31F4050; Tue, 28 Aug 2007 15:55:54 -0400 (EDT) Date: Tue, 28 Aug 2007 15:55:54 -0400 From: Andrew Sullivan To: pgsql-admin@postgresql.org Subject: Re: How to monitor resources on Linux. Message-ID: <20070828195554.GB1683@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> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <46D47A13.3060907@the-allgoods.net> User-Agent: Mutt/1.5.9i X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200708/360 X-Sequence-Number: 26691 On Tue, Aug 28, 2007 at 03:40:03PM -0400, John R Allgood wrote: > lot of activity as compared to the other databases. We run VACUUM at > midday VACUUM FULL at night, VACUUM ANALYZE on weekends. If you are running VACUUM often enough, then you should _never_ need VACUUM FULL. And weekly VACUUM ANALYSE is probably too infrequent. A -- Andrew Sullivan | ajs@crankycanuck.ca "The year's penultimate month" is not in truth a good way of saying November. --H.W. Fowler