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? Regards Takayuki Tsunakawa