Re: [PATCHES] A way to let Vacuum warn if FSM settings are

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: Greg Stark <gsstark(at)mit(dot)edu>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: [PATCHES] A way to let Vacuum warn if FSM settings are
Date: 2005-03-14 02:52:47
Message-ID: 200503140252.j2E2qlD19756@candle.pha.pa.us
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-patches

Greg Stark wrote:
>
> Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> writes:
>
> > These new messages:
> >
> > NOTICE: max_fsm_relations(1000) equals the number of relations checked
> > HINT: You have >= 44 relations.
> > Consider increasing the configuration parameter "max_fsm_relations".
> > NOTICE: the number of page slots needed (704) exceeds max_fsm_pages (20000)
> > HINT: Consider increasing the configuration parameter "max_fsm_relations"
> > to a value over 704.
> > VACUUM
>
> Those statements seem a tad strange with those numbers...

I forced those to print for testing.

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Bruno Wolff III 2005-03-14 04:44:44 Re: Oracle's Virtual Private Database functionality
Previous Message Bruce Momjian 2005-03-14 02:52:19 Re: [PATCHES] A way to let Vacuum warn if FSM settings are low. [final?]

Browse pgsql-patches by date

  From Date Subject
Next Message Tom Lane 2005-03-14 04:43:18 Re: Cache last known per-tuple offsets to speed long tuple
Previous Message Bruce Momjian 2005-03-14 02:52:19 Re: [PATCHES] A way to let Vacuum warn if FSM settings are low. [final?]