Re: [PATCHES] A way to let Vacuum warn if FSM settings are low. [final?]

From: Greg Stark <gsstark(at)mit(dot)edu>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: [PATCHES] A way to let Vacuum warn if FSM settings are low. [final?]
Date: 2005-03-13 22:35:27
Message-ID: 87y8cr6uog.fsf@stark.xeocode.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-patches


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...

--
greg

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Palle Girgensohn 2005-03-13 23:18:55 Re: where is the locale set for each server instance?
Previous Message Tom Lane 2005-03-13 22:01:31 Re: where is the locale set for each server instance?

Browse pgsql-patches by date

  From Date Subject
Next Message Andrew Dunstan 2005-03-13 23:32:20 COPY CSV header line feature
Previous Message Greg Sabino Mullane 2005-03-13 13:38:38 Re: Continue transactions after errors in psql