Hello 2010/10/31 AI Rumman <rumman...@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 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
