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