max_fsm_relations(1000) equals the number of relations checked

From: Lonni J Friedman <netllama(at)gmail(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: max_fsm_relations(1000) equals the number of relations checked
Date: 2009-08-04 16:01:28
Message-ID: 7c1574a90908040901k3f888b99kfda6764b0f59c6af@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Greetings,
I have a postgresql 8.1.10 instance running on Linux. When vacuumdb
runs, I see the following in the server log:

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".
LOG: max_fsm_relations(1000) equals the number of relations checked

What is puzzling, is where its getting that 1000 from, as in
postgresql.conf, I have:
max_fsm_relations = 2000

I've restarted the server (several times, in fact) since setting
max_fsm_relations=2000, so I can't figure out why its still using
1000. Is there some alternate location that it might be getting set?

thanks

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Tom Lane 2009-08-04 16:05:33 Re: max_fsm_relations(1000) equals the number of relations checked
Previous Message Tyler Mitchell 2009-08-04 10:48:56 Trigger function volatility