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. ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
