| From: | Alvaro Herrera <alvherre(at)commandprompt(dot)com> |
|---|---|
| To: | Reg Me Please <regmeplease(at)gmail(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Warning about max_fsm_pages: what's that? |
| Date: | 2007-11-09 14:00:42 |
| Message-ID: | 20071109140042.GF2768@alvh.no-ip.org |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | 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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Cesar Alvarez | 2007-11-09 15:06:34 | PIPELINED Functions |
| Previous Message | Karsten Hilbert | 2007-11-09 12:53:51 | Re: Warning about max_fsm_pages: what's that? |