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

Reg Me Please wrote:
> Hi all.
> During a routine "VACUUM ANALYZE" I've got this message in the logs:
>
> 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".
>
>
> The table in question contains some 14M+ rows.
>
> Would it be possible to get some reference or suggestion in order to
> understand better the provided hint?

See
http://www.postgresql.org/docs/8.2/static/runtime-config-resource.html

In order to answer these kind of questions yourself, consider
http://search.postgresql.org/?q=max_fsm_pages

--
Alvaro Herrera                                http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.