Re: performance of sql and plpgsql functions

Поиск
Список
Период
Сортировка
Искать
От
Philip Semanchuk
Тема
Re: performance of sql and plpgsql functions
Дата
Msg-id
460C0856-62C7-44B5-BEFE-2E9FD4E4F0DE@americanefficient.com
Ответ на
performance of sql and plpgsql functions (Julius Tuskenis)
Список
Дерево обсуждения
performance of sql and plpgsql functions Julius Tuskenis <julius.tuskenis@gmail.com>
Re: performance of sql and plpgsql functions Tom Lane <tgl@sss.pgh.pa.us>
Re: performance of sql and plpgsql functions Julius Tuskenis <julius.tuskenis@gmail.com>
Re: performance of sql and plpgsql functions Philip Semanchuk <philip@americanefficient.com>
Re: performance of sql and plpgsql functions Julius Tuskenis <julius.tuskenis@gmail.com>
Re: performance of sql and plpgsql functions Pavel Stehule <pavel.stehule@gmail.com>
Re: performance of sql and plpgsql functions Pavel Stehule <pavel.stehule@gmail.com>
Re: performance of sql and plpgsql functions Julius Tuskenis <julius.tuskenis@gmail.com> 


> On Jun 17, 2024, at 5:35 AM, Julius Tuskenis  wrote:
> 
> 
> Isn't PosgreSQL supposed to inline simple SQL functions that are stable or immutable?

Postgres inlines SQL functions under certain conditions:
https://wiki.postgresql.org/wiki/Inlining_of_SQL_functions

One of those conditions is "the function is not SECURITY DEFINER”. It looks like yours is defined that way, so that might be why it’s not being inlined. 

Hope this helps
Philip
В списке pgsql-performance по дате отправления
Предыдущее
От: Julius Tuskenis
Дата:
Следующее
От: Julius Tuskenis
Дата:
FAQ