Re: number of page slots needed (1576544) exceeds max_fsm_pages (204800)] - Mailing list pgsql-general

From Scott Marlowe
Subject Re: number of page slots needed (1576544) exceeds max_fsm_pages (204800)]
Date
Msg-id dcc563d11001181729g63c78bacv906d98e91f953b6a@mail.gmail.com
Whole thread Raw
In response to Re: number of page slots needed (1576544) exceeds max_fsm_pages (204800)]  (Vick Khera <vivek@khera.org>)
List 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 by date:

Previous
From: Terry
Date:
Subject: Re: data dump help
Next
From: Scott Marlowe
Date:
Subject: Re: vacuum issues under load?