PgBench Results for PostgreSQL 12#

PostgreSQL Version#

                                                               version                                                               
-------------------------------------------------------------------------------------------------------------------------------------
 PostgreSQL 12.22 (Ubuntu 12.22-2.pgdg24.04+1) on x86_64-pc-linux-gnu, compiled by gcc (Ubuntu 13.3.0-6ubuntu2~24.04) 13.3.0, 64-bit
(1 row)

System Information#

CPU(s):                               4
Model name:                           AMD EPYC 7763 64-Core Processor
Thread(s) per core:                   2
Memory: 15Gi

Benchmark Results#

starting vacuum...end.
progress: 5.0 s, 2564.0 tps, lat 6.220 ms stddev 5.525
progress: 10.0 s, 2539.0 tps, lat 6.298 ms stddev 5.803
progress: 15.0 s, 2569.0 tps, lat 6.229 ms stddev 5.348
progress: 20.0 s, 2515.0 tps, lat 6.361 ms stddev 5.480
progress: 25.0 s, 2579.2 tps, lat 6.201 ms stddev 5.769
progress: 30.0 s, 2669.0 tps, lat 5.996 ms stddev 5.177
progress: 35.0 s, 2541.4 tps, lat 6.291 ms stddev 5.517
progress: 40.0 s, 2493.6 tps, lat 6.418 ms stddev 5.667
progress: 45.0 s, 2563.0 tps, lat 6.241 ms stddev 5.610
progress: 50.0 s, 2560.4 tps, lat 6.248 ms stddev 5.371
progress: 55.0 s, 2560.4 tps, lat 6.246 ms stddev 5.568
progress: 60.0 s, 2577.0 tps, lat 6.209 ms stddev 5.280
transaction type: <builtin: TPC-B (sort of)>
scaling factor: 1
query mode: simple
number of clients: 16
number of threads: 4
duration: 60 s
number of transactions actually processed: 153671
latency average = 6.246 ms
latency stddev = 5.512 ms
tps = 2560.542248 (including connections establishing)
tps = 2560.652634 (excluding connections establishing)