Received: from localhost (wm.hub.org [200.46.204.128]) by postgresql.org (Postfix) with ESMTP id B08489FB64B for ; Mon, 9 Oct 2006 11:11:50 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.128]) (amavisd-new, port 10024) with ESMTP id 59536-07-2 for ; Mon, 9 Oct 2006 14:11:31 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey- Received: from mx00.pub.collaborativefusion.com (mx00.pub.collaborativefusion.com [206.210.89.199]) by postgresql.org (Postfix) with ESMTP id 1BE659FB64A for ; Mon, 9 Oct 2006 11:11:30 -0300 (ADT) Received: from collaborativefusion.com (mx01.pub.collaborativefusion.com [206.210.89.201]) (TLS: TLSv1/SSLv3,256bits,AES256-SHA) by wingspan with esmtp; Mon, 09 Oct 2006 10:11:29 -0400 id 00056420.452A5891.0000EE37 Received: from Internal Mail-Server (206.210.89.202) by mx01 (envelope-from wmoran@collaborativefusion.com) with AES256-SHA encrypted SMTP; 9 Oct 2006 10:07:45 -0400 Date: Mon, 9 Oct 2006 10:11:28 -0400 From: Bill Moran To: "Medora Schauer" Cc: pgsql-performance@postgresql.org Subject: Re: autovacuum not working? Message-Id: <20061009101128.7664a933.wmoran@collaborativefusion.com> In-Reply-To: <1CA058827877644DAB54FB930FFA3B05D89F15@lincoln.FAIRIND.FAIRFIELD.COM> References: <1CA058827877644DAB54FB930FFA3B05D89F15@lincoln.FAIRIND.FAIRFIELD.COM> Organization: Collaborative Fusion X-Mailer: Sylpheed version 2.2.7 (GTK+ 2.8.20; i386-portbld-freebsd6.1) Mime-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.001 tagged_above=0 required=5 tests=UNPARSEABLE_RELAY X-Spam-Level: X-Archive-Number: 200610/157 X-Sequence-Number: 21286 In response to "Medora Schauer" : > I've recently moved to 8.1 and find that autovacuum doesn't seem to be > working, at least not the way I expected it to. I need the tuple count > for a table to be updated so indexes will be used when appropriate. I > was expecting the tuples count for a table to be updated after > autovacuum ran. This doesn't seem to be the case. I added 511 records > to a previously empty table and waited over an hour. Tuples for the > table (as per pgaccess) was 0. After I did a manual vacuum analyze it > went to 511.