Re: STRICT SQL functions never inline

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: STRICT SQL functions never inline
Дата
Msg-id 14182.1320798574@sss.pgh.pa.us
обсуждение исходный текст
Ответ на STRICT SQL functions never inline  (Josh Berkus <josh@agliodbs.com>)
Список pgsql-performance
Josh Berkus <josh@agliodbs.com> writes:
> After having some production issues, I did some testing and it seems
> that any SQL function declared STRICT will never inline.

It won't unless the planner can prove that the resulting expression
behaves the same, ie, is also strict for *all* the parameters.  Which
in most cases isn't true, or at least is very difficult to prove.
This is not a bug.

            regards, tom lane

В списке pgsql-performance по дате отправления:

Предыдущее
От: Andres Freund
Дата:
Сообщение: Re: STRICT SQL functions never inline
Следующее
От: Venkat Balaji
Дата:
Сообщение: : bg_writer overloaded ?