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

From: Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>
To: Vick Khera <vivek(at)khera(dot)org>
Cc: PostgreSQL General <pgsql-general(at)postgresql(dot)org>
Subject: Re: number of page slots needed (1576544) exceeds max_fsm_pages (204800)]
Date: 2010-01-19 01:29:33
Message-ID: dcc563d11001181729g63c78bacv906d98e91f953b6a@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Mon, Jan 18, 2010 at 12:43 PM, Vick Khera <vivek(at)khera(dot)org> wrote:
> On Mon, Jan 18, 2010 at 1:47 PM, Reid Thompson <reid(dot)thompson(at)ateb(dot)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.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Scott Marlowe 2010-01-19 01:35:11 Re: vacuum issues under load?
Previous Message Terry 2010-01-18 23:49:32 Re: data dump help