| 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 value over 200K? |
| Date: | 2009-01-20 21:59:21 |
| Message-ID: | 1232488761.3012.75.camel@laptop.gunduz.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Nico Callewaert | 2009-01-21 15:40:52 | Newbie question PostgreSQL / Postgres Plus / Tuning |
| Previous Message | Greg Cocks | 2009-01-20 19:31:15 | Re: PostgreSQL + PostGIS - "mining" FGDC metadata of GIS datasets |