Re: Warning about max_fsm_pages: what's that? - Mailing list pgsql-general

From Karsten Hilbert
Subject Re: Warning about max_fsm_pages: what's that?
Date
Msg-id 20071109125350.GD4326@merkur.hilbert.loc
Whole thread Raw
In response to Warning about max_fsm_pages: what's that?  (Reg Me Please <regmeplease@gmail.com>)
List pgsql-general
On Fri, Nov 09, 2007 at 11:26:21AM +0100, Reg Me Please wrote:

> WARNING:  relation "public.t_dati" contains more than "max_fsm_pages" pages
> with useful free space
> HINT:  Consider compacting this relation or increasing the configuration
> parameter "max_fsm_pages".
>
> Would it be possible to get some reference or suggestion in order to
> understand better the provided hint?

It's right there in the fine manual:

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

Google has it, too:

http://www.google.de/search?hl=de&ie=ISO-8859-1&q=postgresql+max_fsm_pages&btnG=Google-Suche&meta=
--
GPG key ID E4071346 @ wwwkeys.pgp.net
E167 67FD A291 2BEA 73BD  4537 78B9 A9F9 E407 1346

pgsql-general by date:

Previous
From: "Márcio Geovani Jasinski"
Date:
Subject: Re: INSERT performance deteriorates quickly during a large import
Next
From: Alvaro Herrera
Date:
Subject: Re: Warning about max_fsm_pages: what's that?