In response to Kynn Jones [EMAIL PROTECTED]:
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/
[EMAIL PROTECTED]
Phone: 412-422-3463x4023
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general