Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id AA20C2E0050 for ; Fri, 21 Mar 2008 01:51:43 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 96701-04 for ; Fri, 21 Mar 2008 01:51:38 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from bunspace.com (mail.oss4u.com [64.142.76.151]) by postgresql.org (Postfix) with SMTP id 6A8782E0045 for ; Fri, 21 Mar 2008 01:51:38 -0300 (ADT) Received: (qmail 5287 invoked by uid 453); 21 Mar 2008 04:51:35 -0000 X-Virus-Checked: Checked by ClamAV on bunspace.com Received: from tiburon.bunspace.com (HELO tiburon) (192.168.1.4) by bunspace.com (qpsmtpd/0.40) with ESMTP; Thu, 20 Mar 2008 21:51:35 -0700 From: "Uwe C. Schroeder" To: pgsql-admin@postgresql.org Subject: Re: exceeds max_fsm_pages Date: Thu, 20 Mar 2008 20:51:35 -0800 User-Agent: KMail/1.9.6 Cc: "Marc Fromm" References: <81FEAB8CDDC62B42B6E8AA258228BC8804E92652@EVS2.univ.dir.wwu.edu> In-Reply-To: <81FEAB8CDDC62B42B6E8AA258228BC8804E92652@EVS2.univ.dir.wwu.edu> MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit Content-Disposition: inline Message-Id: <200803202151.35336.uwe@oss4u.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200803/183 X-Sequence-Number: 28666 You increase max_fsm_pages and restart the server. On Thursday 20 March 2008, Marc Fromm wrote: > I received this message after running vacuum on a database. > > NOTICE: number of page slots needed (27296) exceeds max_fsm_pages > (20000) > HINT: Consider increasing the configuration parameter "max_fsm_pages" > to a value over 27296. > > The documentation for 8.1 sates: > This setting must be more than 16 * max_fsm_relations. The default is > 20000. This option can only be set at server start. > > Do I increase max_fsm_pages or max_fsm_relations, or both. > Does "only be set at server start" mean to alter the settings in > postgresql.conf and then restart the postmaster? > > > > Marc