Received: from localhost (maia-1.hub.org [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id 228909FB1CE for ; Mon, 16 Apr 2007 19:43:01 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.191]) (amavisd-maia, port 10024) with ESMTP id 50433-08 for ; Mon, 16 Apr 2007 19:42:58 -0300 (ADT) X-Greylist: delayed 00:28:22.399533 by SQLgrey-1.7.4 Received: from svr4.postgresql.org (svr4.postgresql.org [66.98.251.159]) by postgresql.org (Postfix) with ESMTP id A695D9FA6B8 for ; Mon, 16 Apr 2007 19:42:58 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.3 Received: from outbound.mailhop.org (outbound.mailhop.org [63.208.196.171]) by svr4.postgresql.org (Postfix) with ESMTP id 8A8C25AF03A for ; Mon, 16 Apr 2007 22:14:35 +0000 (GMT) Received: from ool-45745d15.dyn.optonline.net ([69.116.93.21] helo=[192.168.3.71]) by outbound.mailhop.org with esmtpsa (TLSv1:AES256-SHA:256) (Exim 4.63) (envelope-from ) id 1HdZT0-0005iV-0Q; Mon, 16 Apr 2007 18:14:34 -0400 X-MHO-User: U2FsdGVkX19kNPKPv7qu6s1papo3b53I X-Mail-Handler: MailHop Outbound by DynDNS X-Originating-IP: 69.116.93.21 X-Report-Abuse-To: abuse@dyndns.com (see http://www.mailhop.org/outbound/abuse.html for abuse reporting information) X-MHO-User: U2FsdGVkX19VpO3zvG4QnB7SBmDNdM+I Message-ID: <4623F54E.3030900@zeut.net> Date: Mon, 16 Apr 2007 18:14:38 -0400 From: "Matthew T. O'Connor" User-Agent: Thunderbird 2.0.0.0 (Windows/20070326) MIME-Version: 1.0 To: "Kieran Cooper, Lyris UK" Cc: pgsql-admin@postgresql.org Subject: Re: Vacuum stops with misleading max_fsm_pages error References: <001901c78071$9a9a1f00$0b02a8c0@KieranX15> In-Reply-To: <001901c78071$9a9a1f00$0b02a8c0@KieranX15> 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=0.001 tagged_above=0 required=5 tests=BAYES_50=0.001 X-Spam-Level: X-Archive-Number: 200704/145 X-Sequence-Number: 25209 Kieran Cooper, Lyris UK wrote: > We're managing a database on version 8.2.3 (running Lyris ListManager > email software). I ran a 'vacuum analyze full verbose' (we haven't been > able to get autovacuum to work properly on Lyris installs so we need to > run a full vacuum every week or so, and we'd been doing some work on > this machine so it needed it). It ran happily for quite a while - about > 2 thirds of the way through the database - but then ended with the lines What is it about autovacuum that isn't working for you?