[pgpool-general: 266] Performance difference between versions

[drAX]

Hi! Why performance between pgpool versions differs so much?
I've tested pgpool2 3.0.5 and 3.1.2 (works in streaming replication mode
without load balancing) and have such results (3.0.5 is better on insert
and updates):
3.0.5:

Pgbench
pgbench -p5432 -T 30 -n -c 12 -S pgbench
transaction type: SELECT only
scaling factor: 1
query mode: simple
number of clients: 12
number of threads: 1
duration: 30 s
number of transactions actually processed: 23912
tps = 796.951295 (including connections establishing)
tps = 1168.853991 (excluding connections establishing)

pgbench -p5432 -T 30 -n -c 12 pgbench
transaction type: TPC-B (sort of)
scaling factor: 1
query mode: simple
number of clients: 12
number of threads: 1
duration: 30 s
number of transactions actually processed: 3790
tps = 126.011119 (including connections establishing)
tps = 129.066176 (excluding connections establishing)




3.1.2:
pgbench -p5432 -T 30 -n -c 12 -S pgbench
transaction type: SELECT only
scaling factor: 1
query mode: simple
number of clients: 12
number of threads: 1
duration: 30 s
number of transactions actually processed: 33071
tps = 1100.493297 (including connections establishing)
tps = 1100.626356 (excluding connections establishing)

pgbench -p5432 -T 30 -n -c 12 pgbench
transaction type: TPC-B (sort of)
scaling factor: 1
query mode: simple
number of clients: 12
number of threads: 1
duration: 30 s
number of transactions actually processed: 298
tps = 9.629868 (including connections establishing)
tps = 9.630998 (excluding connections establishing)

(pgpool works on 5432 port)