max_fsm_relations question

From: "Kynn Jones" <kynnjo(at)gmail(dot)com>
To: "pgsql-general General" <pgsql-general(at)postgresql(dot)org>
Subject: max_fsm_relations question
Date: 2008-08-05 17:16:12
Message-ID: c2350ba40808051016o63d70d78l112f7b42015f871@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

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?

Thanks!

Kynn

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Bill Moran 2008-08-05 17:36:23 Re: max_fsm_relations question
Previous Message Tom Lane 2008-08-05 17:15:35 Re: Vacuum Vs Vacuum Full