PgBench Results for PostgreSQL 16#
PostgreSQL Version#
version
-------------------------------------------------------------------------------------------------------------------------------------
PostgreSQL 16.10 (Ubuntu 16.10-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.10 (Ubuntu 16.10-1.pgdg24.04+1))
progress: 5.0 s, 2898.0 tps, lat 5.501 ms stddev 4.740, 0 failed
progress: 10.0 s, 2929.2 tps, lat 5.464 ms stddev 4.828, 0 failed
progress: 15.0 s, 2925.8 tps, lat 5.466 ms stddev 4.856, 0 failed
progress: 20.0 s, 2961.2 tps, lat 5.401 ms stddev 4.554, 0 failed
progress: 25.0 s, 2942.0 tps, lat 5.439 ms stddev 4.796, 0 failed
progress: 30.0 s, 2941.2 tps, lat 5.439 ms stddev 4.640, 0 failed
progress: 35.0 s, 2941.6 tps, lat 5.438 ms stddev 4.771, 0 failed
progress: 40.0 s, 2935.2 tps, lat 5.450 ms stddev 4.608, 0 failed
progress: 45.0 s, 2902.4 tps, lat 5.511 ms stddev 4.963, 0 failed
progress: 50.0 s, 2912.4 tps, lat 5.493 ms stddev 4.777, 0 failed
progress: 55.0 s, 2882.8 tps, lat 5.547 ms stddev 4.832, 0 failed
progress: 60.0 s, 2911.2 tps, lat 5.497 ms stddev 4.671, 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: 175430
number of failed transactions: 0 (0.000%)
latency average = 5.471 ms
latency stddev = 4.754 ms
initial connection time = 11.827 ms
tps = 2923.671995 (without initial connection time)