max_fsm_relations
| От | Adam Radłowski |
|---|---|
| Тема | max_fsm_relations |
| Дата | |
| Msg-id | 493225F2.1080307@informatyka.gdansk.pl обсуждение |
| Ответы |
Re: max_fsm_relations
|
| Список | 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
В списке pgsql-admin по дате отправления: