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@[EMAIL PROTECTED]
)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance
