max fsm pages question - Mailing list pgsql-performance

Hi,

when i issued the vaccuum cmd, I recieved this message:

echo "VACUUM --full -d ARSys" | psql -d dbname

WARNING:  relation "public.tradetbl" contains more than
"max_fsm_pages" pages with useful free space
HINT:  Consider compacting this relation or increasing the
configuration parameter "max_fsm_pages".
NOTICE:  number of page slots needed (309616) exceeds max_fsm_pages (153600)
HINT:  Consider increasing the configuration parameter "max_fsm_pages"
to a value over 309616.
VACUUM

What does the warning indicate? How will it adversely affect the system.

Thanks.
-rs


--
It is all a matter of perspective. You choose your view by choosing
where to stand. --Larry Wall