Re: Avoid excessive inlining? - Mailing list pgsql-general

From Pavel Stehule
Subject Re: Avoid excessive inlining?
Date
Msg-id CAFj8pRBZEXVYyhLDsmXpB9ywvdO3Bo3aEYq=cz1BB14tX+DfEw@mail.gmail.com
Whole thread Raw
In response to Re: Avoid excessive inlining?  ("Joel Jacobson" <joel@compiler.org>)
List 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


pgsql-general by date:

Previous
From: "Joel Jacobson"
Date:
Subject: Re: Avoid excessive inlining?
Next
From: Meng Qingzhong
Date:
Subject: Why not report ERROR when "concurrent insert in progress within table"?