max_fsm_pages increase

From: AI Rumman <rummandba(at)gmail(dot)com>
To: pgsql-general General <pgsql-general(at)postgresql(dot)org>
Subject: max_fsm_pages increase
Date: 2010-10-31 08:43:59
Message-ID: AANLkTingVNCYhNJMwAkTKd-cGBNQBuWdhn8-syh0Bw0_@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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?

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Pavel Stehule 2010-10-31 08:47:29 Re: max_fsm_pages increase
Previous Message Pavel Stehule 2010-10-31 08:34:24 Re: Implementing replace function