pgbench epyc 2 x AMD EPYC 7742 64-Core testing with a Supermicro H11DSi-NT v2.00 (2.1 BIOS) and ASPEED on Ubuntu 21.10 via the Phoronix Test Suite. 1: Processor: 2 x AMD EPYC 7742 64-Core @ 2.25GHz (128 Cores / 256 Threads), Motherboard: Supermicro H11DSi-NT v2.00 (2.1 BIOS), Chipset: AMD Starship/Matisse, Memory: 126GB, Disk: 280GB INTEL SSDPE21D280GA, Graphics: ASPEED, Monitor: VE228, Network: 2 x Intel 10G X550T OS: Ubuntu 21.10, Kernel: 5.15.0-rc4-cluster-sched (x86_64), Desktop: GNOME Shell 40.5, Display Server: X Server, Vulkan: 1.1.182, Compiler: GCC 11.2.0, File-System: ext4, Screen Resolution: 1920x1080 2: Processor: 2 x AMD EPYC 7742 64-Core @ 2.25GHz (128 Cores / 256 Threads), Motherboard: Supermicro H11DSi-NT v2.00 (2.1 BIOS), Chipset: AMD Starship/Matisse, Memory: 126GB, Disk: 280GB INTEL SSDPE21D280GA, Graphics: ASPEED, Monitor: VE228, Network: 2 x Intel 10G X550T OS: Ubuntu 21.10, Kernel: 5.15.0-rc4-cluster-sched (x86_64), Desktop: GNOME Shell 40.5, Display Server: X Server, Vulkan: 1.1.182, Compiler: GCC 11.2.0, File-System: ext4, Screen Resolution: 1920x1080 3: Processor: 2 x AMD EPYC 7742 64-Core @ 2.25GHz (128 Cores / 256 Threads), Motherboard: Supermicro H11DSi-NT v2.00 (2.1 BIOS), Chipset: AMD Starship/Matisse, Memory: 126GB, Disk: 280GB INTEL SSDPE21D280GA, Graphics: ASPEED, Monitor: VE228, Network: 2 x Intel 10G X550T OS: Ubuntu 21.10, Kernel: 5.15.0-rc4-cluster-sched (x86_64), Desktop: GNOME Shell 40.5, Display Server: X Server, Vulkan: 1.1.182, Compiler: GCC 11.2.0, File-System: ext4, Screen Resolution: 1920x1080 PostgreSQL pgbench 14.0 Scaling Factor: 1 - Clients: 1 - Mode: Read Only TPS > Higher Is Better 1 . 27022 |==================================================================== 2 . 17823 |============================================= 3 . 18344 |============================================== PostgreSQL pgbench 14.0 Scaling Factor: 1 - Clients: 1 - Mode: Read Only - Average Latency ms < Lower Is Better 1 . 0.037 |============================================= 2 . 0.056 |==================================================================== 3 . 0.055 |=================================================================== PostgreSQL pgbench 14.0 Scaling Factor: 1 - Clients: 1 - Mode: Read Write TPS > Higher Is Better 1 . 3405 |===================================================================== 2 . 2482 |================================================== 3 . 2469 |================================================== PostgreSQL pgbench 14.0 Scaling Factor: 1 - Clients: 1 - Mode: Read Write - Average Latency ms < Lower Is Better 1 . 0.294 |================================================= 2 . 0.403 |==================================================================== 3 . 0.405 |==================================================================== PostgreSQL pgbench 14.0 Scaling Factor: 1 - Clients: 50 - Mode: Read Only TPS > Higher Is Better 1 . 986964 |=================================================================== 2 . 487432 |================================= 3 . 498536 |================================== PostgreSQL pgbench 14.0 Scaling Factor: 1 - Clients: 50 - Mode: Read Only - Average Latency ms < Lower Is Better 1 . 0.051 |================================== 2 . 0.103 |==================================================================== 3 . 0.100 |================================================================== PostgreSQL pgbench 14.0 Scaling Factor: 1 - Clients: 100 - Mode: Read Only TPS > Higher Is Better 1 . 1337490 |================================================================== 2 . 805864 |======================================== 3 . 806749 |======================================== PostgreSQL pgbench 14.0 Scaling Factor: 1 - Clients: 100 - Mode: Read Only - Average Latency ms < Lower Is Better 1 . 0.075 |========================================= 2 . 0.124 |==================================================================== 3 . 0.124 |==================================================================== PostgreSQL pgbench 14.0 Scaling Factor: 1 - Clients: 250 - Mode: Read Only TPS > Higher Is Better 1 . 1914045 |================================================================== 2 . 1640661 |========================================================= 3 . 1602302 |======================================================= PostgreSQL pgbench 14.0 Scaling Factor: 1 - Clients: 250 - Mode: Read Only - Average Latency ms < Lower Is Better 1 . 0.131 |========================================================= 2 . 0.152 |================================================================== 3 . 0.156 |==================================================================== PostgreSQL pgbench 14.0 Scaling Factor: 1 - Clients: 50 - Mode: Read Write TPS > Higher Is Better 1 . 2859 |===================================================================== 2 . 2431 |=========================================================== 3 . 2441 |=========================================================== PostgreSQL pgbench 14.0 Scaling Factor: 1 - Clients: 50 - Mode: Read Write - Average Latency ms < Lower Is Better 1 . 17.49 |========================================================== 2 . 20.57 |==================================================================== 3 . 20.49 |==================================================================== PostgreSQL pgbench 14.0 Scaling Factor: 1 - Clients: 500 - Mode: Read Only TPS > Higher Is Better 1 . 1823635 |================================================================== 2 . 1586454 |========================================================= 3 . 1587304 |========================================================= PostgreSQL pgbench 14.0 Scaling Factor: 1 - Clients: 500 - Mode: Read Only - Average Latency ms < Lower Is Better 1 . 0.274 |=========================================================== 2 . 0.315 |==================================================================== 3 . 0.315 |==================================================================== PostgreSQL pgbench 14.0 Scaling Factor: 100 - Clients: 1 - Mode: Read Only TPS > Higher Is Better 1 . 24141 |==================================================================== 2 . 17448 |================================================= 3 . 17316 |================================================= PostgreSQL pgbench 14.0 Scaling Factor: 100 - Clients: 1 - Mode: Read Only - Average Latency ms < Lower Is Better 1 . 0.041 |================================================ 2 . 0.057 |=================================================================== 3 . 0.058 |==================================================================== PostgreSQL pgbench 14.0 Scaling Factor: 1 - Clients: 100 - Mode: Read Write TPS > Higher Is Better 1 . 1841 |===================================================================== 2 . 1608 |============================================================ 3 . 1556 |========================================================== PostgreSQL pgbench 14.0 Scaling Factor: 1 - Clients: 100 - Mode: Read Write - Average Latency ms < Lower Is Better 1 . 54.41 |========================================================== 2 . 62.21 |================================================================== 3 . 64.25 |==================================================================== PostgreSQL pgbench 14.0 Scaling Factor: 1 - Clients: 250 - Mode: Read Write TPS > Higher Is Better 1 . 1074 |=============================================================== 2 . 1175 |===================================================================== 3 . 1178 |===================================================================== PostgreSQL pgbench 14.0 Scaling Factor: 1 - Clients: 250 - Mode: Read Write - Average Latency ms < Lower Is Better 1 . 235.05 |=================================================================== 2 . 212.69 |============================================================= 3 . 212.22 |============================================================ PostgreSQL pgbench 14.0 Scaling Factor: 1 - Clients: 500 - Mode: Read Write TPS > Higher Is Better 1 . 387 |=================================================== 2 . 397 |==================================================== 3 . 535 |====================================================================== PostgreSQL pgbench 14.0 Scaling Factor: 1 - Clients: 500 - Mode: Read Write - Average Latency ms < Lower Is Better 1 . 1322.12 |================================================================== 2 . 1258.99 |=============================================================== 3 . 934.48 |=============================================== PostgreSQL pgbench 14.0 Scaling Factor: 100 - Clients: 1 - Mode: Read Write TPS > Higher Is Better 1 . 3053 |===================================================================== 2 . 1905 |=========================================== 3 . 2055 |============================================== PostgreSQL pgbench 14.0 Scaling Factor: 100 - Clients: 1 - Mode: Read Write - Average Latency ms < Lower Is Better 1 . 0.328 |========================================== 2 . 0.525 |==================================================================== 3 . 0.487 |=============================================================== PostgreSQL pgbench 14.0 Scaling Factor: 100 - Clients: 50 - Mode: Read Only TPS > Higher Is Better 1 . 982789 |=================================================================== 2 . 513658 |=================================== 3 . 516036 |=================================== PostgreSQL pgbench 14.0 Scaling Factor: 100 - Clients: 50 - Mode: Read Only - Average Latency ms < Lower Is Better 1 . 0.051 |==================================== 2 . 0.097 |==================================================================== 3 . 0.097 |==================================================================== PostgreSQL pgbench 14.0 Scaling Factor: 1000 - Clients: 1 - Mode: Read Only TPS > Higher Is Better 1 . 21215 |==================================================================== 2 . 15387 |================================================= 3 . 15174 |================================================= PostgreSQL pgbench 14.0 Scaling Factor: 1000 - Clients: 1 - Mode: Read Only - Average Latency ms < Lower Is Better 1 . 0.047 |================================================ 2 . 0.065 |=================================================================== 3 . 0.066 |==================================================================== PostgreSQL pgbench 14.0 Scaling Factor: 100 - Clients: 100 - Mode: Read Only TPS > Higher Is Better 1 . 1375728 |================================================================== 2 . 815953 |======================================= 3 . 831586 |======================================== PostgreSQL pgbench 14.0 Scaling Factor: 100 - Clients: 100 - Mode: Read Only - Average Latency ms < Lower Is Better 1 . 0.073 |======================================== 2 . 0.123 |==================================================================== 3 . 0.120 |================================================================== PostgreSQL pgbench 14.0 Scaling Factor: 100 - Clients: 250 - Mode: Read Only TPS > Higher Is Better 1 . 2013192 |================================================================== 2 . 1600454 |==================================================== 3 . 1664922 |======================================================= PostgreSQL pgbench 14.0 Scaling Factor: 100 - Clients: 250 - Mode: Read Only - Average Latency ms < Lower Is Better 1 . 0.124 |====================================================== 2 . 0.156 |==================================================================== 3 . 0.150 |================================================================= PostgreSQL pgbench 14.0 Scaling Factor: 100 - Clients: 50 - Mode: Read Write TPS > Higher Is Better 1 . 24506 |==================================================================== 2 . 12246 |================================== 3 . 12966 |==================================== PostgreSQL pgbench 14.0 Scaling Factor: 100 - Clients: 50 - Mode: Read Write - Average Latency ms < Lower Is Better 1 . 2.350 |======================================= 2 . 4.083 |==================================================================== 3 . 3.856 |================================================================ PostgreSQL pgbench 14.0 Scaling Factor: 100 - Clients: 500 - Mode: Read Only TPS > Higher Is Better 1 . 1819482 |================================================================== 2 . 1556653 |======================================================== 3 . 1613179 |=========================================================== PostgreSQL pgbench 14.0 Scaling Factor: 100 - Clients: 500 - Mode: Read Only - Average Latency ms < Lower Is Better 1 . 0.275 |========================================================== 2 . 0.321 |==================================================================== 3 . 0.310 |================================================================== PostgreSQL pgbench 14.0 Scaling Factor: 1000 - Clients: 1 - Mode: Read Write TPS > Higher Is Better 1 . 2323 |===================================================================== 2 . 1939 |========================================================== 3 . 1987 |=========================================================== PostgreSQL pgbench 14.0 Scaling Factor: 1000 - Clients: 1 - Mode: Read Write - Average Latency ms < Lower Is Better 1 . 0.432 |========================================================= 2 . 0.516 |==================================================================== 3 . 0.503 |================================================================== PostgreSQL pgbench 14.0 Scaling Factor: 1000 - Clients: 50 - Mode: Read Only TPS > Higher Is Better 1 . 843205 |=================================================================== 2 . 469978 |===================================== 3 . 505559 |======================================== PostgreSQL pgbench 14.0 Scaling Factor: 1000 - Clients: 50 - Mode: Read Only - Average Latency ms < Lower Is Better 1 . 0.060 |====================================== 2 . 0.106 |==================================================================== 3 . 0.099 |================================================================ PostgreSQL pgbench 14.0 Scaling Factor: 100 - Clients: 100 - Mode: Read Write TPS > Higher Is Better 1 . 16281 |==================================================================== 2 . 12775 |===================================================== 3 . 13437 |======================================================== PostgreSQL pgbench 14.0 Scaling Factor: 100 - Clients: 100 - Mode: Read Write - Average Latency ms < Lower Is Better 1 . 6.250 |====================================================== 2 . 7.828 |==================================================================== 3 . 7.442 |================================================================= PostgreSQL pgbench 14.0 Scaling Factor: 100 - Clients: 250 - Mode: Read Write TPS > Higher Is Better 1 . 15099 |============================================================== 2 . 13683 |========================================================= 3 . 16443 |==================================================================== PostgreSQL pgbench 14.0 Scaling Factor: 100 - Clients: 250 - Mode: Read Write - Average Latency ms < Lower Is Better 1 . 16.65 |============================================================== 2 . 18.27 |==================================================================== 3 . 15.20 |========================================================= PostgreSQL pgbench 14.0 Scaling Factor: 100 - Clients: 500 - Mode: Read Write TPS > Higher Is Better 1 . 14830 |==================================================================== 2 . 13915 |================================================================ 3 . 12738 |========================================================== PostgreSQL pgbench 14.0 Scaling Factor: 100 - Clients: 500 - Mode: Read Write - Average Latency ms < Lower Is Better 1 . 34.32 |=========================================================== 2 . 35.93 |============================================================== 3 . 39.25 |==================================================================== PostgreSQL pgbench 14.0 Scaling Factor: 1000 - Clients: 100 - Mode: Read Only TPS > Higher Is Better 1 . 1248968 |================================================================== 2 . 766993 |========================================= 3 . 860510 |============================================= PostgreSQL pgbench 14.0 Scaling Factor: 1000 - Clients: 100 - Mode: Read Only - Average Latency ms < Lower Is Better 1 . 0.080 |========================================== 2 . 0.130 |==================================================================== 3 . 0.116 |============================================================= PostgreSQL pgbench 14.0 Scaling Factor: 1000 - Clients: 250 - Mode: Read Only TPS > Higher Is Better 1 . 895856 |================================================================== 2 . 882258 |================================================================= 3 . 916359 |=================================================================== PostgreSQL pgbench 14.0 Scaling Factor: 1000 - Clients: 250 - Mode: Read Only - Average Latency ms < Lower Is Better 1 . 0.279 |=================================================================== 2 . 0.283 |==================================================================== 3 . 0.273 |================================================================== PostgreSQL pgbench 14.0 Scaling Factor: 1000 - Clients: 50 - Mode: Read Write TPS > Higher Is Better 1 . 9951 |============================================== 2 . 14681 |==================================================================== 3 . 10632 |================================================= PostgreSQL pgbench 14.0 Scaling Factor: 1000 - Clients: 50 - Mode: Read Write - Average Latency ms < Lower Is Better 1 . 5.612 |==================================================================== 2 . 3.406 |========================================= 3 . 4.703 |========================================================= PostgreSQL pgbench 14.0 Scaling Factor: 1000 - Clients: 500 - Mode: Read Only TPS > Higher Is Better 1 . 808264 |=================================================================== 2 . 676525 |======================================================== 3 . 772499 |================================================================ PostgreSQL pgbench 14.0 Scaling Factor: 1000 - Clients: 500 - Mode: Read Only - Average Latency ms < Lower Is Better 1 . 0.620 |========================================================= 2 . 0.739 |==================================================================== 3 . 0.647 |============================================================ PostgreSQL pgbench 14.0 Scaling Factor: 1000 - Clients: 100 - Mode: Read Write TPS > Higher Is Better 1 . 11870 |========================================================== 2 . 13894 |==================================================================== 3 . 12738 |============================================================== PostgreSQL pgbench 14.0 Scaling Factor: 1000 - Clients: 100 - Mode: Read Write - Average Latency ms < Lower Is Better 1 . 8.808 |==================================================================== 2 . 7.197 |======================================================== 3 . 7.851 |============================================================= PostgreSQL pgbench 14.0 Scaling Factor: 1000 - Clients: 250 - Mode: Read Write TPS > Higher Is Better 1 . 9534 |===================================================================== 2 . 8607 |============================================================== 3 . 9080 |================================================================== PostgreSQL pgbench 14.0 Scaling Factor: 1000 - Clients: 250 - Mode: Read Write - Average Latency ms < Lower Is Better 1 . 26.41 |============================================================== 2 . 29.05 |==================================================================== 3 . 27.53 |================================================================ PostgreSQL pgbench 14.0 Scaling Factor: 1000 - Clients: 500 - Mode: Read Write TPS > Higher Is Better 1 . 8446 |==================================================== 2 . 8698 |===================================================== 3 . 11068 |==================================================================== PostgreSQL pgbench 14.0 Scaling Factor: 1000 - Clients: 500 - Mode: Read Write - Average Latency ms < Lower Is Better 1 . 59.20 |==================================================================== 2 . 57.49 |================================================================== 3 . 45.18 |====================================================