Received: from localhost (maia-5.hub.org [200.46.204.182]) by postgresql.org (Postfix) with ESMTP id A24AA9FB43D for ; Mon, 16 Apr 2007 18:59:47 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.182]) (amavisd-maia, port 10024) with ESMTP id 14155-07 for ; Mon, 16 Apr 2007 18:59:41 -0300 (ADT) X-Greylist: delayed 00:06:39.851413 by SQLgrey-1.7.4 Received: from vesuvio.facultas.co.uk (lvps212-241-196-224.vps.webfusion.co.uk [212.241.196.224]) by postgresql.org (Postfix) with ESMTP id 735C79FB418 for ; Mon, 16 Apr 2007 18:59:44 -0300 (ADT) Received: (qmail 5578 invoked from network); 16 Apr 2007 21:53:02 +0000 Received: from cpc1-cmbg4-0-0-cust18.cmbg.cable.ntl.com (HELO KieranX15) (81.98.244.19) by lvps212-241-196-224.vps.webfusion.co.uk with SMTP; 16 Apr 2007 21:53:02 +0000 Message-ID: <001901c78071$9a9a1f00$0b02a8c0@KieranX15> From: "Kieran Cooper, Lyris UK" To: Subject: Vacuum stops with misleading max_fsm_pages error Date: Mon, 16 Apr 2007 22:51:41 +0100 MIME-Version: 1.0 Content-Type: text/plain; format=flowed; charset="iso-8859-1"; reply-type=original Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2900.3028 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3028 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.136 tagged_above=0 required=5 tests=BAYES_50=0.001, FORGED_RCVD_HELO=0.135 X-Spam-Level: X-Archive-Number: 200704/142 X-Sequence-Number: 25206 Hi there, 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 INFO: free space map contains 20914 pages in 61 relations DETAIL: A total of 14992 page slots are in use (including overhead). 14992 page slots are required to track all free space. Current limits are: 900000 page slots, 6000 relations, using 5659 kB. This happens (at more or less the same point but with slightly different figures) each time I try to run this command. It also happens even if I only do vacuum verbose. I can vacuum individual tables quite happily but I'm not sure I can manage to do all of them individually. As you see, I've upped the page slots and relations (there are 131 tables in the database in total) and it seems to me like there is more than enough. Any ideas would be gratefully received! Thanks Kieran Cooper Lyris UK