Re: Why is my function inlined only when STABLE?

Поиск
Список
Период
Сортировка
От Philip Semanchuk
Тема Re: Why is my function inlined only when STABLE?
Дата
Msg-id F391D389-A6C7-41B7-9A53-260632CBDC7B@americanefficient.com
обсуждение исходный текст
Ответ на Re: Why is my function inlined only when STABLE?  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general

> On Mar 29, 2022, at 2:24 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
>
> Philip Semanchuk <philip@americanefficient.com> writes:
>> I have a function that isn't being inlined, and I would appreciate help to understand why that's the case.
>
> I think the test methodology you used is faulty, because it does not
> distinguish between "inline-able" and "foldable to a constant".
> Given an immutable function applied to constant(s), the planner prefers
> to fold to a constant by just executing the function.  The inline-ing
> transformation is considered only when that case doesn't apply.

Excellent point, thank you. Now I understand. I was trying to write an inlining demo for my colleagues, and I
simplifiedmy example one step too far by using a constant. 

I really appreciate the help!

Cheers
Philip


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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Why is my function inlined only when STABLE?
Следующее
От: Paul Jungwirth
Дата:
Сообщение: psql -f and PAGER