Postgres Pro
Downloads
Home   >   mailing lists

Re: [PATCHES] A way to let Vacuum warn if FSM settings are - Mailing list pgsql-general

From Bruce Momjian
Subject Re: [PATCHES] A way to let Vacuum warn if FSM settings are
Date
Msg-id 200503140252.j2E2qlD19756@candle.pha.pa.us
Whole thread Raw
In response to Re: [PATCHES] A way to let Vacuum warn if FSM settings are low. [final?]  (Greg Stark <gsstark@mit.edu>)
List pgsql-general
Tree view 
Greg Stark wrote:
>
> Bruce Momjian <pgman@candle.pha.pa.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@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073

pgsql-general by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: [PATCHES] A way to let Vacuum warn if FSM settings are low. [final?]
Next
From: Bruno Wolff III
Date:
Subject: Re: Oracle's Virtual Private Database functionality