Re: max_fsm_relations

["Joshua D. Drake" <jd(at)commandprompt(dot)com>]

On Fri, 2009-02-27 at 12:37 -0700, Gauthier, Dave wrote:
> I just did a Vacuum Analyze on a DB.  It worked OK, but I got...
> 
>  
> 
>  
> 
> NOTICE: max_fsm_relations(1000) equals the number of relations checked
> 
> HINT:  You have at least 1000 relations.  Consider increasing the
> configuration parameter “max_fsm_relations”
> 
>  
> 
> I browsed around and learned that this has to do with keeping track of
> free disk space.
> 
> Q: Is there a problem with leaving this alone?  How serious is this if
> it is a problem?
> 
> Q: Is there a way I can shrink this number (reload the data to consume
> the free space perhaps?)

This is "relations" which means tables, indexes etc... So unless you
start dropping things, no you can't reduce it.

Just increase it a bit (say 20%) it won't hurt you.

Note it does use a little shared_memory,.

Joshua D. Drake


> 
>  
> 
> Thanks
> 
> -dave
> 
>  
> 
> 
-- 
PostgreSQL - XMPP: jdrake(at)jabber(dot)postgresql(dot)org
   Consulting, Development, Support, Training
   503-667-4564 - http://www.commandprompt.com/
   The PostgreSQL Company, serving since 1997