Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id B77172E003F for ; Mon, 3 Dec 2007 03:26:26 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 15464-04 for ; Mon, 3 Dec 2007 03:26:23 -0400 (AST) Received: from main2.mycybernet.net (main2.mycybernet.net [209.222.63.140]) by postgresql.org (Postfix) with ESMTP id 2D3BA2E0037 for ; Mon, 3 Dec 2007 03:26:23 -0400 (AST) Received: from 227-54-222-209.mycybernet.net ([209.222.54.227] helo=crankycanuck.ca) by main2.mycybernet.net with esmtp (Exim 4.62) (envelope-from ) id 1Iz5h8-00043Y-FW for pgsql-admin@postgresql.org; Mon, 03 Dec 2007 02:26:22 -0500 Received: by crankycanuck.ca (Postfix, from userid 1000) id 2A80850473; Mon, 3 Dec 2007 02:26:17 -0500 (EST) Date: Mon, 3 Dec 2007 02:26:17 -0500 From: Andrew Sullivan To: pgsql-admin@postgresql.org Subject: Re: Enhancement request Message-ID: <20071203072617.GF18421@crankycanuck.ca> Mail-Followup-To: Andrew Sullivan , pgsql-admin@postgresql.org References: <36e682920711301218m703b3c67s6f547fd7b9b60e7c@mail.gmail.com> <7099.1196458205@sss.pgh.pa.us> <36e682920711301332q1cce5db9qe44fb068fcd5608d@mail.gmail.com> <7341.1196459304@sss.pgh.pa.us> <20071130140005.18521c54@jd-laptop> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <20071130140005.18521c54@jd-laptop> User-Agent: Mutt/1.5.13 (2006-08-11) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200712/4 X-Sequence-Number: 27521 On Fri, Nov 30, 2007 at 02:00:05PM -0800, Joshua D. Drake wrote: > Yes autovacuum is great for general low use scenarios. Throw it at a > database doing hundreds of thousands (or even millions) of transactions > an hour that has relations that in the multiple hundred gig range and > autovacuum is useless for a good portion of that database. This isn't a good argument for adding new knobs, though. It's an argument for using the limited resources to make autovacuum better. Compare with the never-ending arguments for index hints. A