Postgres Pro
Downloads
Home   >   mailing lists

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

From Greg Stark
Subject Re: [PATCHES] A way to let Vacuum warn if FSM settings are low. [final?]
Date
Msg-id 87y8cr6uog.fsf@stark.xeocode.com
Whole thread Raw
In response to Re: [PATCHES] A way to let Vacuum warn if FSM settings are low. [final?]  (Bruce Momjian <pgman@candle.pha.pa.us>)
Responses Re: [PATCHES] A way to let Vacuum warn if FSM settings are
List pgsql-general
Tree view 
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...

--
greg

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: where is the locale set for each server instance?
Next
From: Palle Girgensohn
Date:
Subject: Re: where is the locale set for each server instance?