Hello
2010/10/31 AI Rumman <rummandba@gmail.com>:
> I using Postgresql 8.1 and during vacuum at night time, I am getting the
> following log:
> number of page slots needed (2520048) exceeds max_fsm_pages (356656)
> Do I need to increase max_fsm_pages to 2520048? Does it have any bad affect?
I takes a little more memory,
but if you can run VACUUM FULL, then do it. It reduce a free space
inside data files and it reduce a requests on max_fsm_pages.
Regards
Pavel Stehule