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 -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance