Skip site navigation (1) Skip section navigation (2)

Re: Does it make sense to set max_fsm_pages to a valueover 200K?

From: Devrim GÜNDÜZ <devrim(at)gunduz(dot)org>
To: Suny Kim <suny(dot)kim(at)gmx(dot)net>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: Does it make sense to set max_fsm_pages to a valueover 200K?
Date: 2009-01-20 21:59:21
Message-ID: 1232488761.3012.75.camel@laptop.gunduz.org (view raw or flat)
Thread:
Lists: pgsql-novice
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

In response to

pgsql-novice by date

Next:From: Nico CallewaertDate: 2009-01-21 15:40:52
Subject: Newbie question PostgreSQL / Postgres Plus / Tuning
Previous:From: Greg CocksDate: 2009-01-20 19:31:15
Subject: Re: PostgreSQL + PostGIS - "mining" FGDC metadata of GIS datasets

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group