I had merged the following patch
This patch introduce usage of the IMMUTABLE, STABLE and STRICT keywords in order to boost
performance of the Postgres SPs.
Please make sure that your current/and future DB scripts applied that.
* A function should be marked as IMMUTABLE if it doesn't change the database, and if
it doesn't perform any lookups (even for database configuration values) during its
* A function should be marked STABLE if it doesn't change the database, but might
perform lookups (IMMUTABLE is preferable if function meets the requirements).
* A function doesn't need to be marked VOLATILE, because that's the default.
A function should be marked STRICT if it should return NULL when it is passed a NULL
argument, and then the function won't even be called if it is indeed passed a NULL
I am available for any questions.