Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id F1AB1650140 for ; Wed, 16 Jul 2008 03:36:05 -0300 (ADT) Received: from postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 39052-03 for ; Wed, 16 Jul 2008 03:35:43 -0300 (ADT) X-Greylist: delayed 00:31:19.732442 by SQLgrey-1.7.6 Received: from smtp112.sat.emailsrvr.com (smtp112.sat.emailsrvr.com [66.216.121.112]) by postgresql.org (Postfix) with ESMTP id 8B40C650278 for ; Wed, 16 Jul 2008 02:58:54 -0300 (ADT) Received: from relay1.relay.sat.mlsrvr.com (localhost [127.0.0.1]) by relay1.relay.sat.mlsrvr.com (SMTP Server) with ESMTP id 287AF225D64; Wed, 16 Jul 2008 01:27:25 -0400 (EDT) Received: by relay1.relay.sat.mlsrvr.com (Authenticated sender: matthew-AT-zeut.net) with ESMTP id B2223225D2F; Wed, 16 Jul 2008 01:27:23 -0400 (EDT) Message-ID: <487D86BC.4020607@zeut.net> Date: Wed, 16 Jul 2008 01:27:24 -0400 From: "Matthew T. O'Connor" User-Agent: Thunderbird 2.0.0.14 (Windows/20080421) MIME-Version: 1.0 To: Alvaro Herrera CC: Chris Hoover , "pgsql-admin@postgresql.org Admin" Subject: Re: More Autovacuum questions References: <1d219a6f0807150619o567709ebu7d28429d2907bf82@mail.gmail.com> <487CBE5E.6030903@zeut.net> <20080715223635.GC9945@alvh.no-ip.org> In-Reply-To: <20080715223635.GC9945@alvh.no-ip.org> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 8bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200807/146 X-Sequence-Number: 29756 Alvaro Herrera wrote: > Matthew T. O'Connor escribió: > >> As Alvaro already said this is a case where autovacuum still isn't >> great. >> > > While I have your attention ;-) do you have any ideas on how to improve > this? I don't see anything that looks like a solution for this case. No good ideas, but a few random thoughts. 1) Can we make vacuum not block analyze? That way we can continue to analyze a table while it's being vacuumed. 1b) If not, can we make auto-analyze bump auto-vacuum? 2) Maintenance windows. They wouldn't solve this problem, but they might mitigate it some.