Skip site navigation (1) Skip section navigation (2)

max_fsm_relations

From: Adam Radłowski <adamr(at)informatyka(dot)gdansk(dot)pl>
To: pgsql-admin(at)postgresql(dot)org
Subject: max_fsm_relations
Date: 2008-11-30 05:34:42
Message-ID: 493225F2.1080307@informatyka.gdansk.pl (view raw or flat)
Thread:
Lists: pgsql-admin
PostgreSQL 8.1.3 (windows), 8.1.9 - 8.1.10 (linux).
I have databases, what are vacuumed using cron very regularry (vacuumdb 
-a -f ...) and I know when should do this. Automatic vacuuming is off. 
There are thousands of tables in one cluster (for ex. 10000). If I do 
vacuuming manually, I can see 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".
But all is working properly. Do I need really to increase 
max_fsm_relations (and corresponding start values) for postgresql server 
? If I should "to consider" only it looks, that it is  not needed in my 
situation. I'm right ?
Brgds
Adam

Responses

pgsql-admin by date

Next:From: Igniris Valdivia BaezDate: 2008-11-30 15:10:22
Subject: I want to unsubscribe me from this list
Previous:From: Robert TreatDate: 2008-11-29 18:38:47
Subject: Re: ident authentication

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group