Thread: max_fsm_relations question

In response to "Kynn Jones" <kynnjo@gmail.com>:

> Hi.  I have a database that is created and populated by a Perl script.
>  (FWIW, the size of this database is about 12GB, according to
> pg_database_size()).
>
> If, right after the database is built, I connect to it and manually run
> VACUUM ANALYZE, I get the warning
>
> 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 find this puzzling because the database has only 120 relations.

How many other databases do you have on that server?  fsm_relations has
to track all relations in all databases.

> Is there a way I can structure the populating of the database to get rid of
> this message?  E.g. would it help to have the script run VACUUM after it
> populates each new table?

No.  If that parameter is too low you need to raise it, period.

--
Bill Moran
Collaborative Fusion Inc.
http://people.collaborativefusion.com/~wmoran/

wmoran@collaborativefusion.com
Phone: 412-422-3463x4023