Hi all,
I am running a simple test and am curious to know why a difference in execution times between PostgreSQL 12 vs PostgreSQL 15.
I have this function:
CREATE function test() returns int language plpgsql as $$
declare v_number bigint; v_multiplier float = 3.14159; loop_cnt bigint; begin for loop_cnt in 1..1000000000 loop v_number := 1000; v_number := v_number * v_multiplier; end loop; return 0; end;$$; I execute this in PostgreSQL 12:
PostgreSQL 15:
It is much faster in 15 than in 12, and while I love the performance improvement. I am curious to know the rationale behind this improvement on PostgreSQL 15.
The test result is from PostgreSQL on Windows but I observed the same behavior on Linux OS too.
Server Spec:
Intel i7-8650U CPU @1.90GHz 2.11GHz
RAM 16 GB
Windows 11 Enterprise
Thanks,
Adi |