čt 15. 4. 2021 v 18:02 odesílatel tsunakawa.ta...@fujitsu.com < tsunakawa.ta...@fujitsu.com> napsal:
> From: Pavel Stehule <pavel.steh...@gmail.com> > > -------------------------------------------------- > > do $$ > > declare x int ; > > begin > > for i in 1..1000000 > > loop > > let ooo = i; > > end loop; > > end; > > $$; > > > > variant 1 .. 1500 ms > > variant 2 with PLpgSQL support .. 140 ms > > variant 2 without PLpgSQL support 9000 ms > > -------------------------------------------------- > > > > > > That's impressive! But 1 million times of variable assignment took only > 140 ms? It's that one assignment took only 140 nanosecond, which is near > one DRAM access? Can PL/pgSQL processing be really so fast? > In this case the PLpgSQL can be very fast - and after changes in pg 13, the PLpgSQL is not significantly slower than Lua or than PHP. Every body can repeat these tests - I did it on my Lenovo T520 notebook Pavel > > > > Regards > > Takayuki Tsunakawa > > >
