Re: Interesting case of IMMUTABLE significantly hurting performance

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

 



On 08/14/2013 11:52 AM, Pavel Stehule wrote:
> 
> If I understand, a used IMMUTABLE flag disables inlining. What you see,
> is SQL eval overflow.
> 
> My rule is - don't use flags in SQL functions, when it is possible.

Interesting. I knew that was the case for STRICT, but am surprised to
hear it's the case for IMMUTABLE as well. That seems ...
counter-intuitive. Not to mention undocumented as far as I can see.

-- 
 Craig Ringer                   http://www.2ndQuadrant.com/
 PostgreSQL Development, 24x7 Support, Training & Services


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