PgBench Results for PostgreSQL 12#

PostgreSQL Version#

                                                               version                                                               
-------------------------------------------------------------------------------------------------------------------------------------
 PostgreSQL 12.22 (Ubuntu 12.22-3.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#

progress: 5.0 s, 2963.0 tps, lat 5.383 ms stddev 4.474
progress: 10.0 s, 2965.4 tps, lat 5.394 ms stddev 4.573
progress: 15.0 s, 2987.6 tps, lat 5.356 ms stddev 4.539
progress: 20.0 s, 2990.0 tps, lat 5.350 ms stddev 4.410
progress: 25.0 s, 2953.8 tps, lat 5.416 ms stddev 4.652
progress: 30.0 s, 2967.2 tps, lat 5.391 ms stddev 4.524
progress: 35.0 s, 2966.0 tps, lat 5.391 ms stddev 4.597
progress: 40.0 s, 2989.0 tps, lat 5.354 ms stddev 4.529
progress: 45.0 s, 2970.2 tps, lat 5.385 ms stddev 4.481
progress: 50.0 s, 2987.0 tps, lat 5.355 ms stddev 4.467
progress: 55.0 s, 2962.8 tps, lat 5.399 ms stddev 4.643
progress: 60.0 s, 2980.8 tps, lat 5.365 ms stddev 4.547
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: 178430
latency average = 5.379 ms
latency stddev = 4.537 ms
tps = 2973.119642 (including connections establishing)
tps = 2973.242385 (excluding connections establishing)