STRICT SQL functions never inline

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Folks,

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
partitioning.

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?

-- 
Josh Berkus
PostgreSQL Experts Inc.
http://pgexperts.com

-- 
Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance


[Postgresql General]     [Postgresql PHP]     [PHP Users]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Yosemite]

  Powered by Linux