Postgres Pro
Downloads
Home   >   mailing lists

Re: Does it make sense to set max_fsm_pages to a value over 200K? - Mailing list pgsql-novice

From Devrim GÜNDÜZ
Subject Re: Does it make sense to set max_fsm_pages to a value over 200K?
Date
Msg-id 1232488761.3012.75.camel@laptop.gunduz.org
Whole thread Raw
In response to Does it make sense to set max_fsm_pages to a value over 200K?  ("Suny Kim" <suny.kim@gmx.net>)
List pgsql-novice
Tree view 
On Tue, 2009-01-20 at 10:03 +0100, Suny Kim wrote:
> My vacuum tells me:
> "NOTICE:  number of page slots needed (508096) exceeds max_fsm_pages
> (350000)
> HINT:  Consider increasing the configuration parameter "max_fsm_pages"
> to a value over 508096."
> But my reference manual says: "max_fsm_pages can range fro 20k to 200k
> pages."

Please read the whole sentence in the manual. It is talking about the
default value chosen by initdb.

http://www.postgresql.org/docs/8.3/static/runtime-config-resource.html#RUNTIME-CONFIG-RESOURCE-FSM

Regards,
--
Devrim GÜNDÜZ, RHCE
devrim~gunduz.org, devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr
                   http://www.gunduz.org
Attachment

pgsql-novice by date:

Previous
From: "Greg Cocks"
Date:
Subject: Re: PostgreSQL + PostGIS - "mining" FGDC metadata of GIS datasets
Next
From: "Nico Callewaert"
Date:
Subject: Newbie question PostgreSQL / Postgres Plus / Tuning