Thread: Does it make sense to set max_fsm_pages to a value over 200K?

Hi to all those patient postgres-novice-question-answering-people.
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."
Do I miss out on something, maybe the unit? Or is the hint misleading?
Thanks, Sunyx.

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