Re: Warning about max_fsm_pages: what's that?

From: Karsten Hilbert <Karsten(dot)Hilbert(at)gmx(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Warning about max_fsm_pages: what's that?
Date: 2007-11-09 12:53:51
Message-ID: 20071109125350.GD4326@merkur.hilbert.loc
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Alvaro Herrera 2007-11-09 14:00:42 Re: Warning about max_fsm_pages: what's that?
Previous Message Márcio Geovani Jasinski 2007-11-09 11:52:14 Re: INSERT performance deteriorates quickly during a large import