After having some production issues, I did some testing and it seems
that any SQL function declared STRICT will never inline. As a result,
it won't work with either indexes (on the underlying predicate) or
This seems like a horrible gotcha for our users. At the very least I'd
like to document it (in CREATE FUNCTION, presumably), but it would be
better to fix it. Thoughts?
PostgreSQL Experts Inc.
pgsql-performance by date
|Next:||From: Andres Freund||Date: 2011-11-09 00:25:36|
|Subject: Re: STRICT SQL functions never inline|
|Previous:||From: Strange, John W||Date: 2011-11-08 22:33:09|
|Subject: Trying to understand Stats/Query planner issue|