Supplement definition of each procedure by execution specific params
Hivemind database has configured some planner parameters to make its query execution efficient:
- from_collapse_limit=16
- join_collapse_limit=16
That's fine until database is restored from dump, when given settings are lost. This problem is somehow covered by db upgrade script, but this step can be easily missed by DB Admin, what next can lead to hard to analyze performance problems.
As alternative solution, we can supplement definition of each procedure defined at Hivemind (hopefully all complex queries are wrapped by them) by specifying such settings at procedure declaration and eliminate risk of missed steps during database setup.
Edited by Bartek Wrona