pgbench 15 amd epyc genoa Tests for a future article. 2 x AMD EPYC 9654 96-Core testing with a AMD Titanite_4G (RTI1002E BIOS) and ASPEED on Ubuntu 23.04 via the Phoronix Test Suite. a: Processor: 2 x AMD EPYC 9654 96-Core @ 3.71GHz (192 Cores / 384 Threads), Motherboard: AMD Titanite_4G (RTI1002E BIOS), Chipset: AMD Device 14a4, Memory: 24 x 64 GB DDR5-4800MT/s Samsung M321R8GA0BB0-CQKEG, Disk: 800GB INTEL SSDPF21Q800GB, Graphics: ASPEED, Monitor: VGA HDMI, Network: Broadcom NetXtreme BCM5720 PCIe OS: Ubuntu 23.04, Kernel: 5.19.0-21-generic (x86_64), Desktop: GNOME Shell 43.1, Display Server: X Server 1.21.1.4, Vulkan: 1.3.224, Compiler: GCC 12.2.0, File-System: ext4, Screen Resolution: 1920x1080 b: Processor: 2 x AMD EPYC 9654 96-Core @ 3.71GHz (192 Cores / 384 Threads), Motherboard: AMD Titanite_4G (RTI1002E BIOS), Chipset: AMD Device 14a4, Memory: 24 x 64 GB DDR5-4800MT/s Samsung M321R8GA0BB0-CQKEG, Disk: 800GB INTEL SSDPF21Q800GB, Graphics: ASPEED, Monitor: VGA HDMI, Network: Broadcom NetXtreme BCM5720 PCIe OS: Ubuntu 23.04, Kernel: 5.19.0-21-generic (x86_64), Desktop: GNOME Shell 43.1, Display Server: X Server 1.21.1.4, Vulkan: 1.3.224, Compiler: GCC 12.2.0, File-System: ext4, Screen Resolution: 1920x1080 c: Processor: 2 x AMD EPYC 9654 96-Core @ 3.71GHz (192 Cores / 384 Threads), Motherboard: AMD Titanite_4G (RTI1002E BIOS), Chipset: AMD Device 14a4, Memory: 24 x 64 GB DDR5-4800MT/s Samsung M321R8GA0BB0-CQKEG, Disk: 800GB INTEL SSDPF21Q800GB, Graphics: ASPEED, Monitor: VGA HDMI, Network: Broadcom NetXtreme BCM5720 PCIe OS: Ubuntu 23.04, Kernel: 5.19.0-21-generic (x86_64), Desktop: GNOME Shell 43.1, Display Server: X Server 1.21.1.4, Vulkan: 1.3.224, Compiler: GCC 12.2.0, File-System: ext4, Screen Resolution: 1920x1080 PostgreSQL 15 Scaling Factor: 1 - Clients: 1 - Mode: Read Only TPS > Higher Is Better a . 87304 |==================================================================== b . 85898 |=================================================================== c . 86780 |==================================================================== PostgreSQL 15 Scaling Factor: 1 - Clients: 1 - Mode: Read Only - Average Latency ms < Lower Is Better a . 0.011 |============================================================== b . 0.012 |==================================================================== c . 0.012 |==================================================================== PostgreSQL 15 Scaling Factor: 1 - Clients: 1 - Mode: Read Write TPS > Higher Is Better a . 9567 |===================================================================== b . 9169 |================================================================== c . 9039 |================================================================= PostgreSQL 15 Scaling Factor: 1 - Clients: 1 - Mode: Read Write - Average Latency ms < Lower Is Better a . 0.105 |================================================================ b . 0.109 |=================================================================== c . 0.111 |==================================================================== PostgreSQL 15 Scaling Factor: 1 - Clients: 50 - Mode: Read Only TPS > Higher Is Better a . 2028157 |================================================================== b . 2026910 |================================================================== c . 2032038 |================================================================== PostgreSQL 15 Scaling Factor: 1 - Clients: 50 - Mode: Read Only - Average Latency ms < Lower Is Better a . 0.025 |==================================================================== b . 0.025 |==================================================================== c . 0.025 |==================================================================== PostgreSQL 15 Scaling Factor: 1 - Clients: 100 - Mode: Read Only TPS > Higher Is Better a . 2696964 |================================================================== b . 2680970 |================================================================== c . 2669998 |================================================================= PostgreSQL 15 Scaling Factor: 1 - Clients: 100 - Mode: Read Only - Average Latency ms < Lower Is Better a . 0.037 |==================================================================== b . 0.037 |==================================================================== c . 0.037 |==================================================================== PostgreSQL 15 Scaling Factor: 1 - Clients: 250 - Mode: Read Only TPS > Higher Is Better a . 3223038 |================================================================== b . 3231805 |================================================================== c . 3192427 |================================================================= PostgreSQL 15 Scaling Factor: 1 - Clients: 250 - Mode: Read Only - Average Latency ms < Lower Is Better a . 0.078 |==================================================================== b . 0.077 |=================================================================== c . 0.078 |==================================================================== PostgreSQL 15 Scaling Factor: 1 - Clients: 50 - Mode: Read Write TPS > Higher Is Better a . 9936 |===================================================================== b . 8211 |========================================================= c . 8966 |============================================================== PostgreSQL 15 Scaling Factor: 1 - Clients: 50 - Mode: Read Write - Average Latency ms < Lower Is Better a . 5.032 |======================================================== b . 6.095 |==================================================================== c . 5.577 |============================================================== PostgreSQL 15 Scaling Factor: 1 - Clients: 500 - Mode: Read Only TPS > Higher Is Better a . 3695503 |================================================================= b . 3674114 |================================================================= c . 3738366 |================================================================== PostgreSQL 15 Scaling Factor: 1 - Clients: 500 - Mode: Read Only - Average Latency ms < Lower Is Better a . 0.135 |==================================================================== b . 0.136 |==================================================================== c . 0.134 |=================================================================== PostgreSQL 15 Scaling Factor: 1 - Clients: 800 - Mode: Read Only TPS > Higher Is Better a . 3657326 |================================================================= b . 3702208 |================================================================== c . 3665600 |================================================================= PostgreSQL 15 Scaling Factor: 1 - Clients: 800 - Mode: Read Only - Average Latency ms < Lower Is Better a . 0.219 |==================================================================== b . 0.216 |=================================================================== c . 0.218 |==================================================================== PostgreSQL 15 Scaling Factor: 100 - Clients: 1 - Mode: Read Only TPS > Higher Is Better a . 75129 |==================================================================== b . 75335 |==================================================================== c . 75450 |==================================================================== PostgreSQL 15 Scaling Factor: 100 - Clients: 1 - Mode: Read Only - Average Latency ms < Lower Is Better a . 0.013 |==================================================================== b . 0.013 |==================================================================== c . 0.013 |==================================================================== PostgreSQL 15 Scaling Factor: 1 - Clients: 100 - Mode: Read Write TPS > Higher Is Better a . 6115 |=================================================================== b . 5781 |=============================================================== c . 6339 |===================================================================== PostgreSQL 15 Scaling Factor: 1 - Clients: 100 - Mode: Read Write - Average Latency ms < Lower Is Better a . 16.35 |================================================================ b . 17.30 |==================================================================== c . 15.78 |============================================================== PostgreSQL 15 Scaling Factor: 1 - Clients: 1000 - Mode: Read Only TPS > Higher Is Better a . 3685575 |================================================================== b . 3656198 |================================================================= c . 3674827 |================================================================== PostgreSQL 15 Scaling Factor: 1 - Clients: 1000 - Mode: Read Only - Average Latency ms < Lower Is Better a . 0.271 |=================================================================== b . 0.274 |==================================================================== c . 0.272 |==================================================================== PostgreSQL 15 Scaling Factor: 1 - Clients: 250 - Mode: Read Write TPS > Higher Is Better a . 2507 |===================================================================== b . 2512 |===================================================================== c . 2344 |================================================================ PostgreSQL 15 Scaling Factor: 1 - Clients: 250 - Mode: Read Write - Average Latency ms < Lower Is Better a . 99.70 |=============================================================== b . 99.55 |=============================================================== c . 106.66 |=================================================================== PostgreSQL 15 Scaling Factor: 1 - Clients: 500 - Mode: Read Write TPS > Higher Is Better a . 1006 |===================================================================== b . 870 |============================================================ c . 940 |================================================================ PostgreSQL 15 Scaling Factor: 1 - Clients: 500 - Mode: Read Write - Average Latency ms < Lower Is Better a . 497.05 |======================================================== b . 589.61 |=================================================================== c . 532.15 |============================================================ PostgreSQL 15 Scaling Factor: 1 - Clients: 800 - Mode: Read Write TPS > Higher Is Better a . 649 |====================================================================== b . 525 |========================================================= c . 578 |============================================================== PostgreSQL 15 Scaling Factor: 1 - Clients: 800 - Mode: Read Write - Average Latency ms < Lower Is Better a . 1231.74 |===================================================== b . 1537.88 |================================================================== c . 1385.16 |=========================================================== PostgreSQL 15 Scaling Factor: 100 - Clients: 1 - Mode: Read Write TPS > Higher Is Better a . 8430 |===================================================================== b . 7474 |============================================================= c . 5716 |=============================================== PostgreSQL 15 Scaling Factor: 100 - Clients: 1 - Mode: Read Write - Average Latency ms < Lower Is Better a . 0.119 |============================================== b . 0.136 |===================================================== c . 0.175 |==================================================================== PostgreSQL 15 Scaling Factor: 100 - Clients: 50 - Mode: Read Only TPS > Higher Is Better a . 2012527 |================================================================== b . 2021663 |================================================================== c . 2008485 |================================================================== PostgreSQL 15 Scaling Factor: 100 - Clients: 50 - Mode: Read Only - Average Latency ms < Lower Is Better a . 0.025 |==================================================================== b . 0.025 |==================================================================== c . 0.025 |==================================================================== PostgreSQL 15 Scaling Factor: 1000 - Clients: 1 - Mode: Read Only TPS > Higher Is Better a . 63191 |=================================================================== b . 63765 |==================================================================== c . 63284 |=================================================================== PostgreSQL 15 Scaling Factor: 1000 - Clients: 1 - Mode: Read Only - Average Latency ms < Lower Is Better a . 0.016 |==================================================================== b . 0.016 |==================================================================== c . 0.016 |==================================================================== PostgreSQL 15 Scaling Factor: 1 - Clients: 1000 - Mode: Read Write TPS > Higher Is Better a . 500 |====================================================================== b . 450 |=============================================================== c . 488 |==================================================================== PostgreSQL 15 Scaling Factor: 1 - Clients: 1000 - Mode: Read Write - Average Latency ms < Lower Is Better a . 2001.10 |========================================================== b . 2276.45 |================================================================== c . 2047.16 |=========================================================== PostgreSQL 15 Scaling Factor: 100 - Clients: 100 - Mode: Read Only TPS > Higher Is Better a . 2647361 |================================================================== b . 2642652 |================================================================== c . 2662034 |================================================================== PostgreSQL 15 Scaling Factor: 100 - Clients: 100 - Mode: Read Only - Average Latency ms < Lower Is Better a . 0.038 |==================================================================== b . 0.038 |==================================================================== c . 0.038 |==================================================================== PostgreSQL 15 Scaling Factor: 100 - Clients: 250 - Mode: Read Only TPS > Higher Is Better a . 3169687 |================================================================== b . 3142114 |================================================================= c . 3153143 |================================================================== PostgreSQL 15 Scaling Factor: 100 - Clients: 250 - Mode: Read Only - Average Latency ms < Lower Is Better a . 0.079 |=================================================================== b . 0.080 |==================================================================== c . 0.079 |=================================================================== PostgreSQL 15 Scaling Factor: 100 - Clients: 50 - Mode: Read Write TPS > Higher Is Better a . 82377 |==================================================================== b . 23560 |=================== c . 21284 |================== PostgreSQL 15 Scaling Factor: 100 - Clients: 50 - Mode: Read Write - Average Latency ms < Lower Is Better a . 0.607 |================== b . 2.226 |================================================================ c . 2.349 |==================================================================== PostgreSQL 15 Scaling Factor: 100 - Clients: 500 - Mode: Read Only TPS > Higher Is Better a . 3440685 |================================================================= b . 3508837 |================================================================== c . 3392306 |================================================================ PostgreSQL 15 Scaling Factor: 100 - Clients: 500 - Mode: Read Only - Average Latency ms < Lower Is Better a . 0.145 |=================================================================== b . 0.143 |================================================================== c . 0.147 |==================================================================== PostgreSQL 15 Scaling Factor: 100 - Clients: 800 - Mode: Read Only TPS > Higher Is Better a . 3643262 |================================================================== b . 3360556 |============================================================= c . 3259643 |=========================================================== PostgreSQL 15 Scaling Factor: 100 - Clients: 800 - Mode: Read Only - Average Latency ms < Lower Is Better a . 0.220 |============================================================= b . 0.238 |================================================================== c . 0.245 |==================================================================== PostgreSQL 15 Scaling Factor: 1000 - Clients: 1 - Mode: Read Write TPS > Higher Is Better a . 7462 |===================================================================== b . 6643 |============================================================= c . 4014 |===================================== PostgreSQL 15 Scaling Factor: 1000 - Clients: 1 - Mode: Read Write - Average Latency ms < Lower Is Better a . 0.134 |===================================== b . 0.157 |=========================================== c . 0.249 |==================================================================== PostgreSQL 15 Scaling Factor: 1000 - Clients: 50 - Mode: Read Only TPS > Higher Is Better a . 1787790 |================================================================== b . 1769501 |================================================================= c . 1771860 |================================================================= PostgreSQL 15 Scaling Factor: 1000 - Clients: 50 - Mode: Read Only - Average Latency ms < Lower Is Better a . 0.028 |==================================================================== b . 0.028 |==================================================================== c . 0.028 |==================================================================== PostgreSQL 15 Scaling Factor: 100 - Clients: 100 - Mode: Read Write TPS > Higher Is Better a . 37917 |==================================================================== b . 18407 |================================= c . 25258 |============================================= PostgreSQL 15 Scaling Factor: 100 - Clients: 100 - Mode: Read Write - Average Latency ms < Lower Is Better a . 2.637 |=============================== b . 5.717 |==================================================================== c . 3.959 |=============================================== PostgreSQL 15 Scaling Factor: 100 - Clients: 1000 - Mode: Read Only TPS > Higher Is Better a . 3538947 |================================================================== b . 3340417 |============================================================== c . 3328025 |============================================================== PostgreSQL 15 Scaling Factor: 100 - Clients: 1000 - Mode: Read Only - Average Latency ms < Lower Is Better a . 0.283 |================================================================ b . 0.300 |==================================================================== c . 0.300 |==================================================================== PostgreSQL 15 Scaling Factor: 100 - Clients: 250 - Mode: Read Write TPS > Higher Is Better a . 21103 |==================================================================== b . 17036 |======================================================= PostgreSQL 15 Scaling Factor: 100 - Clients: 250 - Mode: Read Write - Average Latency ms < Lower Is Better a . 11.85 |===================================================== b . 15.16 |==================================================================== PostgreSQL 15 Scaling Factor: 100 - Clients: 500 - Mode: Read Write TPS > Higher Is Better a . 21235 |==================================================================== b . 15879 |=================================================== PostgreSQL 15 Scaling Factor: 100 - Clients: 500 - Mode: Read Write - Average Latency ms < Lower Is Better a . 23.55 |================================================== b . 32.01 |==================================================================== PostgreSQL 15 Scaling Factor: 100 - Clients: 800 - Mode: Read Write TPS > Higher Is Better a . 15089 |=================================================================== b . 15322 |==================================================================== PostgreSQL 15 Scaling Factor: 100 - Clients: 800 - Mode: Read Write - Average Latency ms < Lower Is Better a . 53.02 |==================================================================== b . 52.70 |==================================================================== PostgreSQL 15 Scaling Factor: 1000 - Clients: 100 - Mode: Read Only TPS > Higher Is Better a . 1483866 |=============================================================== b . 1561366 |================================================================== PostgreSQL 15 Scaling Factor: 1000 - Clients: 100 - Mode: Read Only - Average Latency ms < Lower Is Better a . 0.067 |==================================================================== b . 0.064 |================================================================= PostgreSQL 15 Scaling Factor: 1000 - Clients: 250 - Mode: Read Only TPS > Higher Is Better a . 1103071 |======================================================= b . 1314231 |================================================================== PostgreSQL 15 Scaling Factor: 1000 - Clients: 250 - Mode: Read Only - Average Latency ms < Lower Is Better a . 0.227 |==================================================================== b . 0.190 |========================================================= PostgreSQL 15 Scaling Factor: 1000 - Clients: 50 - Mode: Read Write TPS > Higher Is Better a . 10969 |======================================================== b . 13264 |==================================================================== PostgreSQL 15 Scaling Factor: 1000 - Clients: 50 - Mode: Read Write - Average Latency ms < Lower Is Better a . 4.558 |==================================================================== b . 3.770 |======================================================== PostgreSQL 15 Scaling Factor: 1000 - Clients: 500 - Mode: Read Only TPS > Higher Is Better a . 984445 |=================================================================== b . 947071 |================================================================ PostgreSQL 15 Scaling Factor: 1000 - Clients: 500 - Mode: Read Only - Average Latency ms < Lower Is Better a . 0.508 |================================================================= b . 0.528 |==================================================================== PostgreSQL 15 Scaling Factor: 1000 - Clients: 800 - Mode: Read Only TPS > Higher Is Better a . 821536 |============================================================== b . 887845 |=================================================================== PostgreSQL 15 Scaling Factor: 1000 - Clients: 800 - Mode: Read Only - Average Latency ms < Lower Is Better a . 0.974 |==================================================================== b . 0.901 |=============================================================== PostgreSQL 15 Scaling Factor: 100 - Clients: 1000 - Mode: Read Write TPS > Higher Is Better a . 14503 |=================================================================== b . 14779 |==================================================================== PostgreSQL 15 Scaling Factor: 100 - Clients: 1000 - Mode: Read Write - Average Latency ms < Lower Is Better a . 68.95 |==================================================================== b . 67.66 |=================================================================== PostgreSQL 15 Scaling Factor: 1000 - Clients: 100 - Mode: Read Write TPS > Higher Is Better a . 5726 |===================================== b . 10439 |==================================================================== PostgreSQL 15 Scaling Factor: 1000 - Clients: 100 - Mode: Read Write - Average Latency ms < Lower Is Better a . 17.465 |=================================================================== b . 9.579 |===================================== PostgreSQL 15 Scaling Factor: 1000 - Clients: 1000 - Mode: Read Only TPS > Higher Is Better a . 749819 |============================================================= b . 817159 |=================================================================== PostgreSQL 15 Scaling Factor: 1000 - Clients: 1000 - Mode: Read Only - Average Latency ms < Lower Is Better a . 1.334 |==================================================================== b . 1.224 |============================================================== PostgreSQL 15 Scaling Factor: 1000 - Clients: 250 - Mode: Read Write TPS > Higher Is Better a . 14880 |==================================================================== b . 14380 |================================================================== PostgreSQL 15 Scaling Factor: 1000 - Clients: 250 - Mode: Read Write - Average Latency ms < Lower Is Better a . 16.80 |================================================================== b . 17.39 |==================================================================== PostgreSQL 15 Scaling Factor: 1000 - Clients: 500 - Mode: Read Write TPS > Higher Is Better a . 11923 |======================================================= b . 14732 |==================================================================== PostgreSQL 15 Scaling Factor: 1000 - Clients: 500 - Mode: Read Write - Average Latency ms < Lower Is Better a . 41.94 |==================================================================== b . 33.94 |======================================================= PostgreSQL 15 Scaling Factor: 1000 - Clients: 800 - Mode: Read Write TPS > Higher Is Better a . 14230 |==================================================================== b . 13950 |=================================================================== PostgreSQL 15 Scaling Factor: 1000 - Clients: 800 - Mode: Read Write - Average Latency ms < Lower Is Better a . 56.22 |=================================================================== b . 57.35 |==================================================================== PostgreSQL 15 Scaling Factor: 1000 - Clients: 1000 - Mode: Read Write TPS > Higher Is Better a . 18425 |==================================================================== b . 15592 |========================================================== PostgreSQL 15 Scaling Factor: 1000 - Clients: 1000 - Mode: Read Write - Average Latency ms < Lower Is Better a . 54.28 |========================================================== b . 64.13 |====================================================================