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. 1: Processor: AMD Ryzen Threadripper 2970WX 24-Core @ 3.00GHz (24 Cores / 48 Threads), Motherboard: Gigabyte X399 AORUS Gaming 7 (F12h BIOS), Chipset: AMD 17h, Memory: 16GB, Disk: 120GB Corsair Force MP500, Graphics: Sapphire AMD Radeon RX 550 640SP / 560/560X 4GB (1300/1750MHz), Audio: Realtek ALC1220, Monitor: VA2431, Network: Qualcomm Atheros Killer E2500 + 2 x QLogic cLOM8214 1/10GbE + Intel 8265 / 8275 OS: Ubuntu 20.04, Kernel: 5.9.0-050900rc6daily20200926-generic (x86_64) 20200925, Desktop: GNOME Shell 3.36.4, Display Server: X Server 1.20.9, OpenGL: 4.6 Mesa 20.2.6 (LLVM 11.0.0), Compiler: GCC 9.3.0, File-System: ext4, Screen Resolution: 1920x1080 2: Processor: AMD Ryzen Threadripper 2970WX 24-Core @ 3.00GHz (24 Cores / 48 Threads), Motherboard: Gigabyte X399 AORUS Gaming 7 (F12h BIOS), Chipset: AMD 17h, Memory: 16GB, Disk: 120GB Corsair Force MP500, Graphics: Sapphire AMD Radeon RX 550 640SP / 560/560X 4GB (1300/1750MHz), Audio: Realtek ALC1220, Monitor: VA2431, Network: Qualcomm Atheros Killer E2500 + 2 x QLogic cLOM8214 1/10GbE + Intel 8265 / 8275 OS: Ubuntu 20.04, Kernel: 5.9.0-050900rc6daily20200926-generic (x86_64) 20200925, Desktop: GNOME Shell 3.36.4, Display Server: X Server 1.20.9, OpenGL: 4.6 Mesa 20.2.6 (LLVM 11.0.0), Compiler: GCC 9.3.0, File-System: ext4, Screen Resolution: 1920x1080 3: Processor: AMD Ryzen Threadripper 2970WX 24-Core @ 3.00GHz (24 Cores / 48 Threads), Motherboard: Gigabyte X399 AORUS Gaming 7 (F12h BIOS), Chipset: AMD 17h, Memory: 16GB, Disk: 120GB Corsair Force MP500, Graphics: Sapphire AMD Radeon RX 550 640SP / 560/560X 4GB (1300/1750MHz), Audio: Realtek ALC1220, Monitor: VA2431, Network: Qualcomm Atheros Killer E2500 + 2 x QLogic cLOM8214 1/10GbE + Intel 8265 / 8275 OS: Ubuntu 20.04, Kernel: 5.9.0-050900rc6daily20200926-generic (x86_64) 20200925, Desktop: GNOME Shell 3.36.4, Display Server: X Server 1.20.9, OpenGL: 4.6 Mesa 20.2.6 (LLVM 11.0.0), Compiler: GCC 9.3.0, File-System: ext4, Screen Resolution: 1920x1080 3a: Processor: AMD Ryzen Threadripper 2970WX 24-Core @ 3.00GHz (24 Cores / 48 Threads), Motherboard: Gigabyte X399 AORUS Gaming 7 (F12h BIOS), Chipset: AMD 17h, Memory: 16GB, Disk: 120GB Corsair Force MP500, Graphics: Sapphire AMD Radeon RX 550 640SP / 560/560X 4GB (1300/1750MHz), Audio: Realtek ALC1220, Monitor: VA2431, Network: Qualcomm Atheros Killer E2500 + 2 x QLogic cLOM8214 1/10GbE + Intel 8265 / 8275 OS: Ubuntu 20.04, Kernel: 5.9.0-050900rc6daily20200926-generic (x86_64) 20200925, Desktop: GNOME Shell 3.36.4, Display Server: X Server 1.20.9, OpenGL: 4.6 Mesa 20.2.6 (LLVM 11.0.0), Compiler: GCC 9.3.0, File-System: ext4, Screen Resolution: 1920x1080 PostgreSQL pgbench 14.0 Scaling Factor: 1 - Clients: 1 - Mode: Read Only TPS > Higher Is Better 1 .. 21585 |=================================================================== 2 .. 21422 |================================================================== 3a . 21591 |=================================================================== PostgreSQL pgbench 14.0 Scaling Factor: 1 - Clients: 1 - Mode: Read Only - Average Latency ms < Lower Is Better 1 .. 0.046 |================================================================== 2 .. 0.047 |=================================================================== 3a . 0.046 |================================================================== PostgreSQL pgbench 14.0 Scaling Factor: 1 - Clients: 1 - Mode: Read Write TPS > Higher Is Better 1 .. 1161 |==================================================================== 2 .. 1083 |=============================================================== 3a . 1101 |================================================================ PostgreSQL pgbench 14.0 Scaling Factor: 1 - Clients: 1 - Mode: Read Write - Average Latency ms < Lower Is Better 1 .. 0.862 |============================================================== 2 .. 0.927 |=================================================================== 3a . 0.909 |================================================================== PostgreSQL pgbench 14.0 Scaling Factor: 1 - Clients: 50 - Mode: Read Only TPS > Higher Is Better 1 .. 568852 |================================================================= 2 .. 546643 |=============================================================== 3a . 575568 |================================================================== PostgreSQL pgbench 14.0 Scaling Factor: 1 - Clients: 50 - Mode: Read Only - Average Latency ms < Lower Is Better 1 .. 0.088 |================================================================= 2 .. 0.091 |=================================================================== 3a . 0.087 |================================================================ PostgreSQL pgbench 14.0 Scaling Factor: 1 - Clients: 100 - Mode: Read Only TPS > Higher Is Better 1 .. 529966 |================================================================== 2 .. 509421 |=============================================================== 3a . 522195 |================================================================= PostgreSQL pgbench 14.0 Scaling Factor: 1 - Clients: 100 - Mode: Read Only - Average Latency ms < Lower Is Better 1 .. 0.189 |================================================================ 2 .. 0.197 |=================================================================== 3a . 0.191 |================================================================= PostgreSQL pgbench 14.0 Scaling Factor: 1 - Clients: 250 - Mode: Read Only TPS > Higher Is Better 1 .. 549970 |================================================================== 2 .. 532858 |================================================================ 3a . 540464 |================================================================= PostgreSQL pgbench 14.0 Scaling Factor: 1 - Clients: 250 - Mode: Read Only - Average Latency ms < Lower Is Better 1 .. 0.455 |================================================================= 2 .. 0.469 |=================================================================== 3a . 0.463 |================================================================== PostgreSQL pgbench 14.0 Scaling Factor: 1 - Clients: 50 - Mode: Read Write TPS > Higher Is Better 1 .. 1300 |==================================================================== 2 .. 1216 |=============================================================== 3a . 1309 |==================================================================== PostgreSQL pgbench 14.0 Scaling Factor: 1 - Clients: 50 - Mode: Read Write - Average Latency ms < Lower Is Better 1 .. 38.46 |============================================================== 2 .. 41.25 |=================================================================== 3a . 38.20 |============================================================== PostgreSQL pgbench 14.0 Scaling Factor: 1 - Clients: 500 - Mode: Read Only TPS > Higher Is Better 1 .. 525518 |================================================================== 2 .. 509877 |================================================================ 3a . 523756 |================================================================== PostgreSQL pgbench 14.0 Scaling Factor: 1 - Clients: 500 - Mode: Read Only - Average Latency ms < Lower Is Better 1 .. 0.951 |================================================================= 2 .. 0.981 |=================================================================== 3a . 0.955 |================================================================= PostgreSQL pgbench 14.0 Scaling Factor: 100 - Clients: 1 - Mode: Read Only TPS > Higher Is Better 1 .. 19769 |================================================================= 2 .. 20345 |=================================================================== 3a . 20189 |================================================================== PostgreSQL pgbench 14.0 Scaling Factor: 100 - Clients: 1 - Mode: Read Only - Average Latency ms < Lower Is Better 1 .. 0.051 |=================================================================== 2 .. 0.049 |================================================================ 3a . 0.050 |================================================================== PostgreSQL pgbench 14.0 Scaling Factor: 1 - Clients: 100 - Mode: Read Write TPS > Higher Is Better 1 .. 1055 |=============================================================== 2 .. 1082 |================================================================= 3a . 1130 |==================================================================== PostgreSQL pgbench 14.0 Scaling Factor: 1 - Clients: 100 - Mode: Read Write - Average Latency ms < Lower Is Better 1 .. 94.79 |=================================================================== 2 .. 93.04 |================================================================== 3a . 88.52 |=============================================================== PostgreSQL pgbench 14.0 Scaling Factor: 1 - Clients: 250 - Mode: Read Write TPS > Higher Is Better 1 .. 793 |===================================================================== 2 .. 795 |===================================================================== 3a . 751 |================================================================= PostgreSQL pgbench 14.0 Scaling Factor: 1 - Clients: 250 - Mode: Read Write - Average Latency ms < Lower Is Better 1 .. 315.12 |============================================================== 2 .. 316.84 |=============================================================== 3a . 332.88 |================================================================== PostgreSQL pgbench 14.0 Scaling Factor: 1 - Clients: 500 - Mode: Read Write TPS > Higher Is Better 1 .. 390 |======================================================== 2 .. 483 |===================================================================== 3a . 421 |============================================================ PostgreSQL pgbench 14.0 Scaling Factor: 1 - Clients: 500 - Mode: Read Write - Average Latency ms < Lower Is Better 1 .. 1280.63 |================================================================= 2 .. 1054.37 |====================================================== 3a . 1188.53 |============================================================ PostgreSQL pgbench 14.0 Scaling Factor: 100 - Clients: 1 - Mode: Read Write TPS > Higher Is Better 1 .. 812 |===================================================================== 2 .. 770 |================================================================= 3a . 713 |============================================================= PostgreSQL pgbench 14.0 Scaling Factor: 100 - Clients: 1 - Mode: Read Write - Average Latency ms < Lower Is Better 1 .. 1.232 |=========================================================== 2 .. 1.304 |============================================================== 3a . 1.402 |=================================================================== PostgreSQL pgbench 14.0 Scaling Factor: 100 - Clients: 50 - Mode: Read Only TPS > Higher Is Better 1 .. 550407 |================================================================== 2 .. 522333 |=============================================================== 3a . 532125 |================================================================ PostgreSQL pgbench 14.0 Scaling Factor: 100 - Clients: 50 - Mode: Read Only - Average Latency ms < Lower Is Better 1 .. 0.091 |================================================================ 2 .. 0.096 |=================================================================== 3a . 0.094 |================================================================== PostgreSQL pgbench 14.0 Scaling Factor: 100 - Clients: 100 - Mode: Read Only TPS > Higher Is Better 1 .. 495040 |================================================================== 2 .. 484855 |================================================================= 3a . 493042 |================================================================== PostgreSQL pgbench 14.0 Scaling Factor: 100 - Clients: 100 - Mode: Read Only - Average Latency ms < Lower Is Better 1 .. 0.202 |================================================================== 2 .. 0.206 |=================================================================== 3a . 0.203 |================================================================== PostgreSQL pgbench 14.0 Scaling Factor: 100 - Clients: 250 - Mode: Read Only TPS > Higher Is Better 1 .. 518103 |================================================================== 2 .. 511462 |================================================================= 3a . 514725 |================================================================== PostgreSQL pgbench 14.0 Scaling Factor: 100 - Clients: 250 - Mode: Read Only - Average Latency ms < Lower Is Better 1 .. 0.483 |================================================================== 2 .. 0.489 |=================================================================== 3a . 0.486 |=================================================================== PostgreSQL pgbench 14.0 Scaling Factor: 100 - Clients: 50 - Mode: Read Write TPS > Higher Is Better 1 .. 8116 |=================================================================== 2 .. 8177 |==================================================================== 3a . 8104 |=================================================================== PostgreSQL pgbench 14.0 Scaling Factor: 100 - Clients: 50 - Mode: Read Write - Average Latency ms < Lower Is Better 1 .. 6.160 |=================================================================== 2 .. 6.118 |================================================================== 3a . 6.169 |=================================================================== PostgreSQL pgbench 14.0 Scaling Factor: 100 - Clients: 500 - Mode: Read Only TPS > Higher Is Better 1 .. 491234 |================================================================== 2 .. 480715 |================================================================= 3a . 488275 |================================================================== PostgreSQL pgbench 14.0 Scaling Factor: 100 - Clients: 500 - Mode: Read Only - Average Latency ms < Lower Is Better 1 .. 1.018 |================================================================== 2 .. 1.040 |=================================================================== 3a . 1.024 |================================================================== PostgreSQL pgbench 14.0 Scaling Factor: 100 - Clients: 100 - Mode: Read Write TPS > Higher Is Better 1 .. 9552 |================================================================= 2 .. 8989 |============================================================= 3a . 9981 |==================================================================== PostgreSQL pgbench 14.0 Scaling Factor: 100 - Clients: 100 - Mode: Read Write - Average Latency ms < Lower Is Better 1 .. 10.47 |=============================================================== 2 .. 11.13 |=================================================================== 3a . 10.02 |============================================================ PostgreSQL pgbench 14.0 Scaling Factor: 100 - Clients: 250 - Mode: Read Write TPS > Higher Is Better 1 .. 10244 |=============================================================== 2 .. 9648 |=========================================================== 3a . 10922 |=================================================================== PostgreSQL pgbench 14.0 Scaling Factor: 100 - Clients: 250 - Mode: Read Write - Average Latency ms < Lower Is Better 1 .. 24.41 |=============================================================== 2 .. 26.01 |=================================================================== 3a . 22.89 |=========================================================== PostgreSQL pgbench 14.0 Scaling Factor: 100 - Clients: 500 - Mode: Read Write TPS > Higher Is Better 1 .. 10175 |================================================================ 2 .. 10587 |=================================================================== 3a . 10499 |================================================================== PostgreSQL pgbench 14.0 Scaling Factor: 100 - Clients: 500 - Mode: Read Write - Average Latency ms < Lower Is Better 1 .. 49.14 |=================================================================== 2 .. 47.23 |================================================================ 3a . 47.63 |=================================================================