Received: from localhost (maia-1.hub.org [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id 212609F9654 for ; Tue, 28 Aug 2007 17:37:01 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.191]) (amavisd-maia, port 10024) with ESMTP id 30417-02 for ; Tue, 28 Aug 2007 17:36:57 -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 549E59F9248 for ; Tue, 28 Aug 2007 17:36:57 -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 1IQ7o0-00073h-AX for pgsql-admin@postgresql.org; Tue, 28 Aug 2007 16:36:56 -0400 Received: by phlogiston.dydns.org (Postfix, from userid 1000) id EE5AE4050; Tue, 28 Aug 2007 16:36:50 -0400 (EDT) Date: Tue, 28 Aug 2007 16:36:50 -0400 From: Andrew Sullivan To: pgsql-admin@postgresql.org Subject: Re: How to monitor resources on Linux. Message-ID: <20070828203650.GC1983@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> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: User-Agent: Mutt/1.5.9i X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200708/365 X-Sequence-Number: 26696 On Tue, Aug 28, 2007 at 03:24:43PM -0500, Scott Marlowe wrote: > Also, by 7.4 autovacuum existed, even if it isn't perfect yet. It's > still better than weekly analyze. I wouldn't use it -- it had serious issues. But this is another point: 7.4 has a big whack of performance issues compared to later releases. So if upgrading is at all an option, it's worth considering. (This is all unrelated to memory use, though.) A -- Andrew Sullivan | ajs@crankycanuck.ca However important originality may be in some fields, restraint and adherence to procedure emerge as the more significant virtues in a great many others. --Alain de Botton