Received: from maia.hub.org (maia-2.hub.org [200.46.204.251])
	by mail.postgresql.org (Postfix) with ESMTP id 4D87D6324F0
	for <pgsql-admin-postgresql.org@mail.postgresql.org>;
	Fri, 30 Jul 2010 11:39:51 -0300 (ADT)
Received: from mail.postgresql.org ([200.46.204.86])
	by maia.hub.org (mx1.hub.org [200.46.204.251]) (amavisd-maia,
	port 10024) with ESMTP id 32045-05 for
	<pgsql-admin-postgresql.org@mail.postgresql.org>;
	Fri, 30 Jul 2010 14:39:42 +0000 (UTC)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.6
Received: from EXHUB017-4.exch017.msoutlookonline.net
	(exhub017-4.exch017.msoutlookonline.net [64.78.22.19])
	by mail.postgresql.org (Postfix) with ESMTP id 191346322B9
	for <pgsql-admin@postgresql.org>; Fri, 30 Jul 2010 11:39:44 -0300 (ADT)
Received: from [172.25.38.146] (38.121.35.129) by smtpx17.msoutlookonline.net
	(64.78.22.39) with Microsoft SMTP Server (TLS) id 8.2.234.1;
	Fri, 30 Jul 2010 07:39:41 -0700
Message-ID: <4C52E42C.8070701@speedfc.com>
Date: Fri, 30 Jul 2010 09:39:40 -0500
From: Bryan Payne <bpayne@speedfc.com>
User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US;
	rv:1.9.1.11) Gecko/20100713 Thunderbird/3.0.6
MIME-Version: 1.0
To: pgsql-admin@postgresql.org
Subject: Autovacuum missing tables
References: <4C518960.3040004@speedfc.com>
In-Reply-To: <4C518960.3040004@speedfc.com>
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: 201007/213
X-Sequence-Number: 35232

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?