Обсуждение: Warning about max_fsm_pages: what's that?
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? This is the very first time I see this message. Many thanks. -- Reg me Please
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
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.