pgbench 2970WX

AMD Ryzen Threadripper 2970WX 24-Core testing with a Gigabyte X399 AORUS Gaming 7 (F12h BIOS) and Sapphire AMD Radeon RX 550 640SP / 560/560X 4GB on Ubuntu 20.04 via the Phoronix Test Suite.

Compare your own system(s) to this result file with the Phoronix Test Suite by running the command: phoronix-test-suite benchmark 2110010-TJ-PGBENCH2977
Jump To Table - Results

View

Do Not Show Noisy Results
Do Not Show Results With Incomplete Data
Do Not Show Results With Little Change/Spread
List Notable Results

Statistics

Show Overall Harmonic Mean(s)
Show Overall Geometric Mean
Show Wins / Losses Counts (Pie Chart)
Normalize Results
Remove Outliers Before Calculating Averages

Graph Settings

Force Line Graphs Where Applicable
Convert To Scalar Where Applicable
Prefer Vertical Bar Graphs

Multi-Way Comparison

Condense Multi-Option Tests Into Single Result Graphs

Table

Show Detailed System Result Table

Run Management

Highlight
Result
Hide
Result
Result
Identifier
View Logs
Performance Per
Dollar
Date
Run
  Test
  Duration
1
September 30 2021
  1 Hour, 35 Minutes
2
September 30 2021
  9 Hours, 57 Minutes
3
October 01 2021
 
3a
October 01 2021
  1 Hour, 34 Minutes
Invert Hiding All Results Option
  3 Hours, 17 Minutes

Only show results where is faster than
Only show results matching title/arguments (delimit multiple options with a comma):
Do not show results matching title/arguments (delimit multiple options with a comma):

pgbench 2970WX, "PostgreSQL pgbench 14.0 - Scaling Factor: 100 - Clients: 100 - Mode: Read Write - Average Latency", Lower Results Are Better "1", "2",11.007,11.431,10.948 "3a", "PostgreSQL pgbench 14.0 - Scaling Factor: 100 - Clients: 100 - Mode: Read Write", Higher Results Are Better "1",9551.880958 "2",9085.497622,8748.503214,9133.858357 "3a",9981.329127 "PostgreSQL pgbench 14.0 - Scaling Factor: 1 - Clients: 50 - Mode: Read Write", Higher Results Are Better "1",1300.1779 "2",1103.268889,1274.868823,1240.515434,1124.16207,1275.903125,1260.287043,1118.329108,1269.577333,1264.121539,1139.786039,1266.390212,1255.492441 "3a",1309.041662 "PostgreSQL pgbench 14.0 - Scaling Factor: 100 - Clients: 50 - Mode: Read Only - Average Latency", Lower Results Are Better "1", "2",0.095,0.094,0.098 "3a", "PostgreSQL pgbench 14.0 - Scaling Factor: 100 - Clients: 50 - Mode: Read Only", Higher Results Are Better "1",550406.585371 "2",524266.300939,533760.775358,508972.943164 "3a",532124.522523 "PostgreSQL pgbench 14.0 - Scaling Factor: 1 - Clients: 50 - Mode: Read Only", Higher Results Are Better "1",568851.654467 "2",579637.862589,548155.741385,540903.463813,536643.445319,542025.933508,535349.045583,543784.368702 "3a",575567.946923 "PostgreSQL pgbench 14.0 - Scaling Factor: 1 - Clients: 50 - Mode: Read Only - Average Latency", Lower Results Are Better "1", "2",0.086,0.091,0.092,0.093,0.092,0.093,0.092 "3a", "PostgreSQL pgbench 14.0 - Scaling Factor: 1 - Clients: 100 - Mode: Read Only - Average Latency", Lower Results Are Better "1", "2",0.195,0.198,0.197 "3a", "PostgreSQL pgbench 14.0 - Scaling Factor: 100 - Clients: 1 - Mode: Read Only - Average Latency", Lower Results Are Better "1", "2",0.049,0.049,0.049 "3a", "PostgreSQL pgbench 14.0 - Scaling Factor: 100 - Clients: 500 - Mode: Read Write", Higher Results Are Better "1",10174.850886 "2",10549.171085,10614.092715,10596.773567 "3a",10498.777318 "PostgreSQL pgbench 14.0 - Scaling Factor: 100 - Clients: 500 - Mode: Read Write - Average Latency", Lower Results Are Better "1", "2",47.397,47.107,47.184 "3a", "PostgreSQL pgbench 14.0 - Scaling Factor: 1 - Clients: 100 - Mode: Read Only", Higher Results Are Better "1",529966.090985 "2",513354.138418,506084.455615,508823.478221 "3a",522195.217315 "PostgreSQL pgbench 14.0 - Scaling Factor: 1 - Clients: 250 - Mode: Read Only", Higher Results Are Better "1",549969.979883 "2",534065.555586,529667.739957,534842.01573 "3a",540464.151621 "PostgreSQL pgbench 14.0 - Scaling Factor: 1 - Clients: 500 - Mode: Read Only - Average Latency", Lower Results Are Better "1", "2",0.937,0.982,0.994,1,0.993 "3a", "PostgreSQL pgbench 14.0 - Scaling Factor: 1 - Clients: 250 - Mode: Read Only - Average Latency", Lower Results Are Better "1", "2",0.468,0.472,0.467 "3a", "PostgreSQL pgbench 14.0 - Scaling Factor: 1 - Clients: 500 - Mode: Read Only", Higher Results Are Better "1",525518.26073 "2",533859.007155,509304.415196,502800.209361,500030.253861,503393.199413 "3a",523756.410894 "PostgreSQL pgbench 14.0 - Scaling Factor: 100 - Clients: 1 - Mode: Read Only", Higher Results Are Better "1",19768.563316 "2",20358.729488,20295.892313,20380.22589 "3a",20189.126527 "PostgreSQL pgbench 14.0 - Scaling Factor: 100 - Clients: 500 - Mode: Read Only", Higher Results Are Better "1",491233.767546 "2",492345.922164,476450.913876,473347.709232 "3a",488275.29724 "PostgreSQL pgbench 14.0 - Scaling Factor: 1 - Clients: 1 - Mode: Read Only - Average Latency", Lower Results Are Better "1", "2",0.047,0.047,0.046 "3a", "PostgreSQL pgbench 14.0 - Scaling Factor: 100 - Clients: 500 - Mode: Read Only - Average Latency", Lower Results Are Better "1", "2",1.016,1.049,1.056 "3a", "PostgreSQL pgbench 14.0 - Scaling Factor: 100 - Clients: 100 - Mode: Read Only", Higher Results Are Better "1",495040.006483 "2",490159.542685,483440.699099,480963.697538 "3a",493042.258323 "PostgreSQL pgbench 14.0 - Scaling Factor: 100 - Clients: 100 - Mode: Read Only - Average Latency", Lower Results Are Better "1", "2",0.204,0.207,0.208 "3a", "PostgreSQL pgbench 14.0 - Scaling Factor: 100 - Clients: 250 - Mode: Read Only", Higher Results Are Better "1",518103.207778 "2",514140.806683,509113.671236,511130.254343 "3a",514725.028465 "PostgreSQL pgbench 14.0 - Scaling Factor: 100 - Clients: 250 - Mode: Read Only - Average Latency", Lower Results Are Better "1", "2",0.486,0.491,0.489 "3a", "PostgreSQL pgbench 14.0 - Scaling Factor: 100 - Clients: 50 - Mode: Read Write", Higher Results Are Better "1",8116.341679 "2",8343.889034,7924.581452,8497.684212,7968.977712,8109.225686,8219.798439 "3a",8104.467329 "PostgreSQL pgbench 14.0 - Scaling Factor: 100 - Clients: 50 - Mode: Read Write - Average Latency", Lower Results Are Better "1", "2",5.992,6.309,5.884,6.274,6.166,6.083 "3a", "PostgreSQL pgbench 14.0 - Scaling Factor: 1 - Clients: 1 - Mode: Read Only", Higher Results Are Better "1",21584.826485 "2",21241.838304,21404.530237,21618.714091 "3a",21590.610212 "PostgreSQL pgbench 14.0 - Scaling Factor: 100 - Clients: 250 - Mode: Read Write - Average Latency", Lower Results Are Better "1", "2",22.391,27.382,24.866,25.03,25.055,26.958,24.724,27.238,25.789,27.703,27.803,27.225 "3a", "PostgreSQL pgbench 14.0 - Scaling Factor: 100 - Clients: 250 - Mode: Read Write", Higher Results Are Better "1",10243.96341 "2",11165.038164,9129.970544,10053.872334,9987.858719,9977.985679,9273.817303,10111.640781,9178.263429,9694.096988,9024.448841,8991.825874,9182.728671 "3a",10922.265841 "PostgreSQL pgbench 14.0 - Scaling Factor: 100 - Clients: 1 - Mode: Read Write - Average Latency", Lower Results Are Better "1", "2",1.305,1.221,1.402,1.301,1.27,1.236,1.2,1.196,1.391,1.4,1.439,1.288 "3a", "PostgreSQL pgbench 14.0 - Scaling Factor: 100 - Clients: 1 - Mode: Read Write", Higher Results Are Better "1",811.684747 "2",766.26203,819.315144,713.494494,768.389094,787.127313,809.034796,833.639735,836.048508,719.083727,714.2825,694.720928,776.483502 "3a",713.060232 "PostgreSQL pgbench 14.0 - Scaling Factor: 1 - Clients: 500 - Mode: Read Write - Average Latency", Lower Results Are Better "1", "2",1246.575,1298.988,922.583,1241.376,1062.923,1022.836,1054.859,855.41,893.538,1132.819,1047.898,872.581 "3a", "PostgreSQL pgbench 14.0 - Scaling Factor: 1 - Clients: 500 - Mode: Read Write", Higher Results Are Better "1",390.431766 "2",401.099072,384.915037,541.956583,402.778938,470.40109,488.837145,473.997044,584.514801,559.573427,441.376791,477.145454,573.013005 "3a",420.689356 "PostgreSQL pgbench 14.0 - Scaling Factor: 1 - Clients: 250 - Mode: Read Write - Average Latency", Lower Results Are Better "1", "2",302.468,311.781,325.444,282.917,333.301,335.126,288.236,377.017,295.264 "3a", "PostgreSQL pgbench 14.0 - Scaling Factor: 1 - Clients: 250 - Mode: Read Write", Higher Results Are Better "1",793.348593 "2",826.534493,801.845813,768.181099,883.65098,750.071937,745.98906,867.344212,663.099956,846.698695 "3a",751.023638 "PostgreSQL pgbench 14.0 - Scaling Factor: 1 - Clients: 100 - Mode: Read Write - Average Latency", Lower Results Are Better "1", "2",91.459,89.362,106.192,111.613,92.034,89.297,93.565,88.092,88.458,87.557,95.378,83.452 "3a", "PostgreSQL pgbench 14.0 - Scaling Factor: 1 - Clients: 100 - Mode: Read Write", Higher Results Are Better "1",1054.91648 "2",1093.389229,1119.043232,941.694919,895.950025,1086.552652,1119.860408,1068.770064,1135.172816,1130.481562,1142.110057,1048.456742,1198.294384 "3a",1129.744404 "PostgreSQL pgbench 14.0 - Scaling Factor: 1 - Clients: 50 - Mode: Read Write - Average Latency", Lower Results Are Better "1", "2",45.32,39.22,40.306,44.478,39.188,39.674,44.71,39.383,39.553,43.868,39.482,39.825 "3a", "PostgreSQL pgbench 14.0 - Scaling Factor: 1 - Clients: 1 - Mode: Read Write - Average Latency", Lower Results Are Better "1", "2",0.87,0.934,1.068,0.899,0.937,1.018,0.863,0.877,0.88,0.951,0.893,0.93 "3a", "PostgreSQL pgbench 14.0 - Scaling Factor: 1 - Clients: 1 - Mode: Read Write", Higher Results Are Better "1",1160.621845 "2",1149.2038,1070.52888,936.737646,1112.06037,1067.375251,982.061654,1158.489443,1139.930498,1136.830934,1051.209791,1120.22396,1075.568527 "3a",1100.610102