On Sun, Oct 31, 2010 at 2:43 AM, AI Rumman <rummandba@xxxxxxxxx> wrote: > 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? No, you should set it to something higher most times. My production dbs, which are in the 100G range of size, and have a lot of updates, and very aggressive autovac setup, floats at around 2.5Million, and has max fsm set to 10M. It'll use a bit of shared mem (6 bytes per I think) so for me that's 60Meg of shared memory. Considering this machine has shared_buffers set to 8 Gig, that's not a whole lot of extra memory being used for me. Note two things: If your database is not getting vacuumed aggressively enough to keep up then you need to adjust autovacuum to keep up (more threads, less sleep, higher cost limits). Also, moving to 8.4 will get you out of this hole, as the free space map was moved from shared_memory to files on the hard drive. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
