PostgreSQL pgbench

This is a simple benchmark of PostgreSQL using pgbench.


PostgreSQL 17

Scaling Factor: 100 - Clients: 1000 - Mode: Read Only - Average Latency

OpenBenchmarking.org metrics for this test profile configuration based on 96 public results since 26 September 2024 with the latest data as of 20 January 2025.

Below is an overview of the generalized performance for components where there is sufficient statistically significant data based upon user-uploaded results. It is important to keep in mind particularly in the Linux/open-source space there can be vastly different OS configurations, with this overview intended to offer just general guidance as to the performance expectations.

Component
Details
Percentile Rank
# Compatible Public Results
ms (Average)
Zen 5 [96 Cores / 192 Threads]
83rd
19
0.21 +/- 0.02
Zen 5 [192 Cores / 384 Threads]
81st
4
0.21
Zen 5 [64 Cores / 128 Threads]
77th
5
0.22 +/- 0.01
Mid-Tier
75th
> 0.22
Zen 5 [128 Cores / 256 Threads]
71st
4
0.23
Zen 5 [256 Cores / 512 Threads]
64th
8
0.24 +/- 0.01
Zen 4 [64 Cores / 128 Threads]
53rd
6
0.27
Median
50th
0.54
48th
6
0.56 +/- 0.01
Zen 2 [64 Cores / 128 Threads]
43rd
3
0.58
Zen 5 [16 Cores / 32 Threads]
39th
4
0.66 +/- 0.01
Zen 2 [32 Cores / 64 Threads]
33rd
4
0.83 +/- 0.01
Granite Rapids [128 Cores / 256 Threads]
29th
4
1.06 +/- 0.13
Low-Tier
25th
> 1.19
Raptor Lake [24 Cores / 32 Threads]
24th
4
1.19 +/- 0.01
Cascade Lake [18 Cores / 36 Threads]
16th
3
1.89 +/- 0.01
Zen 5 [12 Cores / 24 Threads]
11th
4
2.59 +/- 0.12