Received: from localhost (unknown [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 3D11B2E106F for ; Wed, 5 Dec 2007 12:02:33 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 13716-10 for ; Wed, 5 Dec 2007 12:02:30 -0400 (AST) Received: from lists.commandprompt.com (host-159.commandprompt.net [207.173.203.159]) by postgresql.org (Postfix) with ESMTP id 6377B2E3542 for ; Wed, 5 Dec 2007 12:02:30 -0400 (AST) Received: from [192.168.1.226] (or-69-34-217-90.sta.embarqhsd.net [69.34.217.90]) (authenticated bits=0) by lists.commandprompt.com (8.13.8/8.13.8) with ESMTP id lB5G2S1I006331 (version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=NO); Wed, 5 Dec 2007 08:02:29 -0800 Message-ID: <4756CB9B.3050301@commandprompt.com> Date: Wed, 05 Dec 2007 08:02:35 -0800 From: "Joshua D. Drake" Organization: Command Prompt, Inc. User-Agent: Thunderbird 1.5.0.13 (Windows/20070809) MIME-Version: 1.0 To: Greg Sabino Mullane CC: pgsql-admin@postgresql.org Subject: Re: Enhancement request References: <09fbbcab762fc5279e45349ce1cbad93@biglumber.com> In-Reply-To: <09fbbcab762fc5279e45349ce1cbad93@biglumber.com> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Greylist: Sender succeeded SMTP AUTH, not delayed by milter-greylist-4.0 (lists.commandprompt.com [207.173.203.159]); Wed, 05 Dec 2007 08:02:29 -0800 (PST) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200712/22 X-Sequence-Number: 27539 Greg Sabino Mullane wrote: > -----BEGIN PGP SIGNED MESSAGE----- > Hash: RIPEMD160 > > I am curious however, as to what the future vision of autovacuum is. > Will it be so efficient that it won't impact all but the busiest tables? > Will it be able to figure out the best time to vacuum on its own? I believe maintenance windows are on the horizon. Of course it seems that instead of focusing on that, we should just put in a generic job manager. > Will it stop itself mid-run if the need arises? Man I would love this one... coupled with a just enough vacuum. E.g; it calculates a percentage it needs to vacuum, and only vacuums that much. Leaving dead tuples behind. Joshua D. Drake