Horton

Re: Avoid excessive inlining?

Pavel Stehule <pavel.stehule@gmail.com>

View thread View on postgr.es
From: Pavel Stehule <pavel.stehule@gmail.com>
To: Joel Jacobson <joel@compiler.org>
Cc: Tom Lane <tgl@sss.pgh.pa.us>, Laurenz Albe <laurenz.albe@cybertec.at>, Philip Semanchuk <philip@americanefficient.com>, pgsql-general <pgsql-general@postgresql.org>
Date: 2021-01-03T05:57:50Z
Lists: pgsql-general 
so 2. 1. 2021 v 21:02 odesílatel Joel Jacobson <joel@compiler.org> napsal:

> 13.1
>

ok there is plpgsql most fast

you can check if there are not some hidden implicit casting in your code.

Regards

Pavel


> On Sat, Jan 2, 2021, at 20:37, Pavel Stehule wrote:
>
> Hi
>
> so 2. 1. 2021 v 20:07 odesílatel Joel Jacobson <joel@compiler.org> napsal:
>
>
> I found yet another trick, which actually seems to be slightly faster than
> the plpgsql version.
>
>
> What version of Postgres do you use?
>
> plpgsql in Postgres 13 is significantly faster than on older versions
>
> Regards
>
> Pavel
>
>
>