PgBench Results for PostgreSQL 16#
PostgreSQL Version#
version
-----------------------------------------------------------------------------------------------------------------------------------
PostgreSQL 16.9 (Ubuntu 16.9-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)
CPU(s): 4
Model name: AMD EPYC 7763 64-Core Processor
Thread(s) per core: 2
Memory: 15Gi
Benchmark Results#
pgbench (16.9 (Ubuntu 16.9-1.pgdg24.04+1))
starting vacuum...end.
progress: 5.0 s, 2640.8 tps, lat 6.040 ms stddev 5.460, 0 failed
progress: 10.0 s, 2542.8 tps, lat 6.290 ms stddev 6.330, 0 failed
progress: 15.0 s, 2598.8 tps, lat 6.110 ms stddev 5.559, 0 failed
progress: 20.0 s, 2588.6 tps, lat 6.226 ms stddev 5.787, 0 failed
progress: 25.0 s, 2542.6 tps, lat 6.292 ms stddev 5.690, 0 failed
progress: 30.0 s, 2619.0 tps, lat 6.108 ms stddev 5.643, 0 failed
progress: 35.0 s, 2614.8 tps, lat 6.116 ms stddev 5.608, 0 failed
progress: 40.0 s, 2569.6 tps, lat 6.226 ms stddev 5.537, 0 failed
progress: 45.0 s, 2539.8 tps, lat 6.297 ms stddev 5.672, 0 failed
progress: 50.0 s, 2561.8 tps, lat 6.248 ms stddev 5.333, 0 failed
progress: 55.0 s, 2581.4 tps, lat 6.197 ms stddev 5.554, 0 failed
progress: 60.0 s, 2559.8 tps, lat 6.246 ms stddev 5.701, 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: 154815
number of failed transactions: 0 (0.000%)
latency average = 6.200 ms
latency stddev = 5.662 ms
initial connection time = 11.275 ms
tps = 2580.088615 (without initial connection time)