max fsm pages question

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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


[Postgresql General]     [Postgresql PHP]     [PHP Users]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Yosemite]

  Powered by Linux