pgdog 0.1.56 performance test

[earl86]

pgdog
version: 0.1.56
workers = 16
default_pool_size = 256
min_pool_size = 16

sysbench oltp_point_select.lua
TABLES=16
TABLE_SIZE=1000000
THREADS=768

cpu:
INTEL(R) XEON(R) PLATINUM 8568Y+
Ethernet controller:
Intel Corporation Ethernet Controller E810-XXV for SFP (rev 02)
os:
AlmaLinux release 9.8 (Olive Jaguar)

[ 291s ] thds: 768 tps: 606573.63 qps: 606573.63 (r/w/o: 606573.63/0.00/0.00) lat (ms,95%): 1.73 err/s: 0.00 reconn/s: 0.00
[ 292s ] thds: 768 tps: 606162.73 qps: 606159.73 (r/w/o: 606159.73/0.00/0.00) lat (ms,95%): 1.70 err/s: 0.00 reconn/s: 0.00
[ 293s ] thds: 768 tps: 606134.95 qps: 606136.95 (r/w/o: 606136.95/0.00/0.00) lat (ms,95%): 1.73 err/s: 0.00 reconn/s: 0.00
[ 294s ] thds: 768 tps: 607641.47 qps: 607635.47 (r/w/o: 607635.47/0.00/0.00) lat (ms,95%): 1.70 err/s: 0.00 reconn/s: 0.00
[ 295s ] thds: 768 tps: 605712.16 qps: 605719.16 (r/w/o: 605719.16/0.00/0.00) lat (ms,95%): 1.73 err/s: 0.00 reconn/s: 0.00
[ 296s ] thds: 768 tps: 606493.45 qps: 606492.45 (r/w/o: 606492.45/0.00/0.00) lat (ms,95%): 1.73 err/s: 0.00 reconn/s: 0.00
[ 297s ] thds: 768 tps: 603894.75 qps: 603892.75 (r/w/o: 603892.75/0.00/0.00) lat (ms,95%): 1.73 err/s: 0.00 reconn/s: 0.00
[ 298s ] thds: 768 tps: 607114.46 qps: 607117.46 (r/w/o: 607117.46/0.00/0.00) lat (ms,95%): 1.73 err/s: 0.00 reconn/s: 0.00
[ 299s ] thds: 768 tps: 608195.34 qps: 608196.34 (r/w/o: 608196.34/0.00/0.00) lat (ms,95%): 1.70 err/s: 0.00 reconn/s: 0.00
[ 300s ] thds: 768 tps: 605223.01 qps: 605223.01 (r/w/o: 605223.01/0.00/0.00) lat (ms,95%): 1.73 err/s: 0.00 reconn/s: 0.00
SQL statistics:
queries performed:
read: 180630053
write: 0
other: 0
total: 180630053
transactions: 180630053 (601992.29 per sec.)
queries: 180630053 (601992.29 per sec.)
ignored errors: 0 (0.00 per sec.)
reconnects: 0 (0.00 per sec.)

General statistics:
total time: 300.0526s
total number of events: 180630053

Latency (ms):
min: 0.11
avg: 1.28
max: 624.01
95th percentile: 1.73
sum: 230364312.32

Threads fairness:
events (avg/stddev): 235195.3815/1093.76
execution time (avg/stddev): 299.9535/0.01