so 2. 1. 2021 v 21:02 odesílatel Joel Jacobson <joel@xxxxxxxxxxxx> 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:Hiso 2. 1. 2021 v 20:07 odesílatel Joel Jacobson <joel@xxxxxxxxxxxx> 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 versionsRegardsPavel