max_fsm_relations - Mailing list pgsql-general

From Gauthier, Dave
Subject max_fsm_relations
Date
Msg-id 482E80323A35A54498B8B70FF2B8798003ED1B9866@azsmsx504.amr.corp.intel.com
Whole thread Raw
Responses Re: max_fsm_relations
Re: max_fsm_relations
List pgsql-general

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?)

 

Thanks

-dave

 

pgsql-general by date:

Previous
From: Linos
Date:
Subject: Re: strange performance problem
Next
From: "Joshua D. Drake"
Date:
Subject: Re: max_fsm_relations