Received: from maia.hub.org (maia-5.hub.org [200.46.204.29]) by mail.postgresql.org (Postfix) with ESMTP id 8BC86632C16 for ; Thu, 29 Jul 2010 11:10:17 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.29]) (amavisd-maia, port 10024) with ESMTP id 73538-02 for ; Thu, 29 Jul 2010 14:10:07 +0000 (UTC) X-Greylist: delayed 00:10:02.980393 by SQLgrey-1.7.6 Received: from EXHUB017-1.exch017.msoutlookonline.net (exhub017-1.exch017.msoutlookonline.net [64.78.22.16]) by mail.postgresql.org (Postfix) with ESMTP id 40318632836 for ; Thu, 29 Jul 2010 11:10:07 -0300 (ADT) Received: from [172.25.38.146] (38.121.35.129) by smtpx17.msoutlookonline.net (64.78.22.36) with Microsoft SMTP Server (TLS) id 8.2.234.1; Thu, 29 Jul 2010 07:00:00 -0700 Message-ID: <4C518960.3040004@speedfc.com> Date: Thu, 29 Jul 2010 09:00:00 -0500 From: Bryan Payne User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.9.1.10) Gecko/20100527 Thunderbird/3.0.5 MIME-Version: 1.0 To: pgsql-admin@postgresql.org Subject: Autovacuum missing tables Content-Type: text/plain; charset="ISO-8859-1"; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.9 tagged_above=-10 required=5 tests=BAYES_00=-1.9 X-Spam-Level: X-Archive-Number: 201008/12 X-Sequence-Number: 35261 Autovacuum is sometimes skipping certain tables. The tables in question are pretty busy. A vacuum analyze works fine when run manually. The tables in question were successfully autovacuumed this morning, but that is the first time since the 23rd where it worked. I'm not finding any logging info regarding the autovacuum. I'm not sure if autovacuum is seeing table locks or what, but is there a way to run a more aggressive autovacuum?