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
pgbench 2970WX,
"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: 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: 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
"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: 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",
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: 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: 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: 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: 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: 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: 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: 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: 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: 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: 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: 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: 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: 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: 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: 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: 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: 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: 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: 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: 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: 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: 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 Write",
Higher Results Are Better
"1",9551.880958
"2",9085.497622,8748.503214,9133.858357
"3a",9981.329127
"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: 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: 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: 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",