PgBench Results for PostgreSQL 14#

PostgreSQL Version#

                                                               version                                                               
-------------------------------------------------------------------------------------------------------------------------------------
 PostgreSQL 14.19 (Ubuntu 14.19-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 (14.19 (Ubuntu 14.19-1.pgdg24.04+1))
progress: 5.0 s, 2909.2 tps, lat 5.482 ms stddev 4.759
progress: 10.0 s, 2919.4 tps, lat 5.479 ms stddev 4.811
progress: 15.0 s, 2921.4 tps, lat 5.477 ms stddev 4.649
progress: 20.0 s, 2935.6 tps, lat 5.449 ms stddev 4.715
progress: 25.0 s, 2914.4 tps, lat 5.489 ms stddev 4.674
progress: 30.0 s, 2936.8 tps, lat 5.447 ms stddev 4.736
progress: 35.0 s, 2924.4 tps, lat 5.471 ms stddev 4.908
progress: 40.0 s, 2953.8 tps, lat 5.415 ms stddev 4.681
progress: 45.0 s, 2870.6 tps, lat 5.572 ms stddev 4.833
progress: 50.0 s, 2882.0 tps, lat 5.552 ms stddev 4.701
progress: 55.0 s, 2856.0 tps, lat 5.598 ms stddev 5.055
progress: 60.0 s, 2914.2 tps, lat 5.492 ms stddev 4.558
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: 174704
latency average = 5.494 ms
latency stddev = 4.758 ms
initial connection time = 11.766 ms
tps = 2911.603621 (without initial connection time)