Postgres Pro
Downloads
Home   >   mailing lists

Re: performance of sql and plpgsql functions - Mailing list pgsql-performance

From Philip Semanchuk
Subject Re: performance of sql and plpgsql functions
Date
Msg-id 460C0856-62C7-44B5-BEFE-2E9FD4E4F0DE@americanefficient.com
Whole thread Raw
In response to performance of sql and plpgsql functions  (Julius Tuskenis <julius.tuskenis@gmail.com>)
Responses Re: performance of sql and plpgsql functions  (Julius Tuskenis <julius.tuskenis@gmail.com>)
List pgsql-performance
Tree view 

> On Jun 17, 2024, at 5:35 AM, Julius Tuskenis <julius.tuskenis@gmail.com> 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
mightbe why it’s not being inlined.  

Hope this helps
Philip

pgsql-performance by date:

Previous
From: Julius Tuskenis
Date:
Subject: Re: performance of sql and plpgsql functions
Next
From: Julius Tuskenis
Date:
Subject: Re: performance of sql and plpgsql functions