PgBench Results for PostgreSQL 17#
PostgreSQL Version#
version
-----------------------------------------------------------------------------------------------------------------------------------
PostgreSQL 17.6 (Ubuntu 17.6-2.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 (17.6 (Ubuntu 17.6-2.pgdg24.04+1))
progress: 5.0 s, 2806.8 tps, lat 5.678 ms stddev 5.097, 0 failed
progress: 10.0 s, 2811.4 tps, lat 5.688 ms stddev 5.065, 0 failed
progress: 15.0 s, 2798.0 tps, lat 5.723 ms stddev 5.120, 0 failed
progress: 20.0 s, 2749.0 tps, lat 5.818 ms stddev 5.343, 0 failed
progress: 25.0 s, 2794.8 tps, lat 5.722 ms stddev 4.948, 0 failed
progress: 30.0 s, 2851.6 tps, lat 5.611 ms stddev 5.101, 0 failed
progress: 35.0 s, 2821.2 tps, lat 5.669 ms stddev 4.983, 0 failed
progress: 40.0 s, 2778.6 tps, lat 5.759 ms stddev 4.991, 0 failed
progress: 45.0 s, 2804.4 tps, lat 5.703 ms stddev 5.074, 0 failed
progress: 50.0 s, 2825.0 tps, lat 5.663 ms stddev 4.966, 0 failed
progress: 55.0 s, 2785.0 tps, lat 5.743 ms stddev 5.132, 0 failed
progress: 60.0 s, 2759.6 tps, lat 5.798 ms stddev 5.006, 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: 167942
number of failed transactions: 0 (0.000%)
latency average = 5.715 ms
latency stddev = 5.070 ms
initial connection time = 12.571 ms
tps = 2798.938636 (without initial connection time)