Re: number of page slots needed (1576544) exceeds max_fsm_pages (204800)]

Поиск
Список
Период
Сортировка
От Scott Marlowe
Тема Re: number of page slots needed (1576544) exceeds max_fsm_pages (204800)]
Дата
Msg-id dcc563d11001181729g63c78bacv906d98e91f953b6a@mail.gmail.com
обсуждение исходный текст
Ответ на Re: number of page slots needed (1576544) exceeds max_fsm_pages (204800)]  (Vick Khera <vivek@khera.org>)
Список pgsql-general
On Mon, Jan 18, 2010 at 12:43 PM, Vick Khera <vivek@khera.org> wrote:
> On Mon, Jan 18, 2010 at 1:47 PM, Reid Thompson <reid.thompson@ateb.com> wrote:
>> Does this max_fsm_pages value seem OK for a 46GB database?
>> I've clustered all the tables that seemed to be exhibiting large amounts
>> of bloat.
>
> My big DB is about 70 on disk.  I have fsm pages set to 3.4 million,
> and occasionally that gets overrun.  It is nearly catastrophic to us

We have about 2.8Million used and have it set to 10Million for the
same reason as you do.

В списке pgsql-general по дате отправления:

Предыдущее
От: Terry
Дата:
Сообщение: Re: data dump help
Следующее
От: Scott Marlowe
Дата:
Сообщение: Re: vacuum issues under load?