Re: [GENERAL] max_fsm_pages increase

2010-11-01 Thread Vick Khera
On Sun, Oct 31, 2010 at 4:43 AM, AI Rumman 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? You d

Re: [GENERAL] max_fsm_pages increase

2010-10-31 Thread Scott Marlowe
On Sun, Oct 31, 2010 at 2:43 AM, AI Rumman 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, y

Re: [GENERAL] max_fsm_pages increase

2010-10-31 Thread Pavel Stehule
Hello 2010/10/31 AI Rumman : > 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 memo