PgBench Results for PostgreSQL 17#

PostgreSQL Version#

                                                              version                                                              
-----------------------------------------------------------------------------------------------------------------------------------
 PostgreSQL 17.5 (Ubuntu 17.5-1.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#

pgbench (17.5 (Ubuntu 17.5-1.pgdg24.04+1))
starting vacuum...end.
progress: 5.0 s, 2517.2 tps, lat 6.334 ms stddev 5.639, 0 failed
progress: 10.0 s, 2520.0 tps, lat 6.346 ms stddev 5.799, 0 failed
progress: 15.0 s, 2456.6 tps, lat 6.515 ms stddev 6.288, 0 failed
progress: 20.0 s, 2439.8 tps, lat 6.557 ms stddev 6.027, 0 failed
progress: 25.0 s, 2569.6 tps, lat 6.227 ms stddev 5.680, 0 failed
progress: 30.0 s, 2499.4 tps, lat 6.400 ms stddev 6.020, 0 failed
progress: 35.0 s, 2454.6 tps, lat 6.516 ms stddev 5.796, 0 failed
progress: 40.0 s, 2507.0 tps, lat 6.382 ms stddev 5.808, 0 failed
progress: 45.0 s, 2475.8 tps, lat 6.461 ms stddev 5.865, 0 failed
progress: 50.0 s, 2506.0 tps, lat 6.384 ms stddev 5.745, 0 failed
progress: 55.0 s, 2449.8 tps, lat 6.527 ms stddev 6.092, 0 failed
progress: 60.0 s, 2514.4 tps, lat 6.364 ms stddev 5.781, 0 failed
transaction type: <builtin: TPC-B (sort of)>
scaling factor: 1
query mode: simple
number of clients: 16
number of threads: 4
maximum number of tries: 1
duration: 60 s
number of transactions actually processed: 149566
number of failed transactions: 0 (0.000%)
latency average = 6.417 ms
latency stddev = 5.880 ms
initial connection time = 11.843 ms
tps = 2492.591271 (without initial connection time)