po 13. 2. 2023 v 22:22 odesílatel Andres Freund napsal:
> Hi,
>
> On 2023-02-10 20:45:39 +0100, Pavel Stehule wrote:
> > But for significant improvements it needs some form of JIT (Postgres has
> JIT
> > for SQL expressions, but it is not used for PLpgSQL expressions). On
> second
> > hand,
Hi,
On 2023-02-10 20:45:39 +0100, Pavel Stehule wrote:
> But for significant improvements it needs some form of JIT (Postgres has JIT
> for SQL expressions, but it is not used for PLpgSQL expressions). On second
> hand, PL/pgSQL is not designed (and usually) not used for extensive numeric
>
Hi
> Please, don't send screenshots - we believe you :-)
>
> Your code can be little bit faster if you use flag IMMUTABLE
>
> There were more patches that reduced the overhead of expression's
> evaluation in PL/pgSQL.
>
> History
>
>
Hi
pá 10. 2. 2023 v 19:53 odesílatel Adithya Kumaranchath <
akumaranch...@live.com> napsal:
> Hi all,
>
> I am running a simple test and am curious to know why a difference in
> execution times between PostgreSQL 12 vs PostgreSQL 15.
>
> *I have this function:*
> CREATE function test() returns