Received: from localhost (maia-5.hub.org [200.46.204.182]) by postgresql.org (Postfix) with ESMTP id F158E9FB995 for ; Fri, 25 May 2007 05:46:01 -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 32310-03 for ; Fri, 25 May 2007 05:45:55 -0300 (ADT) X-Greylist: delayed 00:15:05.164019 by SQLgrey-1.7.4 Received: from srvftpmail.saga.it (ip-78-25.sn2.eutelia.it [83.211.78.25]) by postgresql.org (Postfix) with ESMTP id 8BF989FB94A for ; Fri, 25 May 2007 05:45:58 -0300 (ADT) Received: from [10.77.1.25] ([10.77.1.25]) by srvmailbs.bs.local (Lotus Domino Release 6.5.2) with ESMTP id 2007052510314565-8489 ; Fri, 25 May 2007 10:31:45 +0200 Message-ID: <46569EF1.1080106@saga.it> Date: Fri, 25 May 2007 10:31:45 +0200 From: Nicola Mauri User-Agent: Thunderbird 2.0.0.0 (Windows/20070326) MIME-Version: 1.0 To: pgsql-admin@postgresql.org Subject: Re: Abnormal storage consumption with autovacuum enabled X-MIMETrack: Itemize by SMTP Server on saga_bs1/saga(Release 6.5.2|June 01, 2004) at 25/05/2007 10.31.45, Serialize by Router on Front_Bs/saga at 05/25/2007 10:47:48 AM, Serialize complete at 05/25/2007 10:47:48 AM X-NAI-Spam-Flag: NO X-NAI-Spam-Score: 0.000 X-NAI-Spam-Threshold: 5.000 X-NAI-Checker-Version: NAI SpamAssassin 1.2 (2.70 20070524 2767) Content-Transfer-Encoding: 7bit Content-Type: text/plain; charset=ISO-8859-15; format=flowed X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200705/281 X-Sequence-Number: 25601 > What do you have max_fsm_pages set to? Currently, max_fsm_pages=20000 Running VACUUM VERBOSE reports: NOTICE: number of page slots needed (237312) exceeds max_fsm_pages (20000) HINT: Consider increasing the configuration parameter "max_fsm_pages" to a value over 237312. Is this measurement reliable? We are considering to set: max_fsm_pages=400000 Could this have some sort of impact? thanks