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

Reply via email to