PostgreSQL 16 AMD EPYC AMD EPYC 9684X 96-Core testing with a AMD Titanite_4G (RTI1007B BIOS) and ASPEED on Ubuntu 23.10 via the Phoronix Test Suite. 9754 a: Processor: AMD EPYC 9754 128-Core @ 2.25GHz (128 Cores / 256 Threads), Motherboard: AMD Titanite_4G (RTI1007B BIOS), Chipset: AMD Device 14a4, Memory: 768GB, Disk: 3201GB Micron_7450_MTFDKCC3T2TFS, Graphics: ASPEED, Network: Broadcom NetXtreme BCM5720 PCIe OS: Ubuntu 23.10, Kernel: 6.5.1-060501-generic (x86_64), Desktop: GNOME Shell, Display Server: X Server 1.21.1.7, Compiler: GCC 13.2.0, File-System: ext4, Screen Resolution: 640x480 9654: Processor: AMD EPYC 9654 96-Core @ 2.40GHz (96 Cores / 192 Threads), Motherboard: AMD Titanite_4G (RTI1007B BIOS), Chipset: AMD Device 14a4, Memory: 768GB, Disk: 3201GB Micron_7450_MTFDKCC3T2TFS, Graphics: ASPEED, Network: Broadcom NetXtreme BCM5720 PCIe OS: Ubuntu 23.10, Kernel: 6.5.1-060501-generic (x86_64), Desktop: GNOME Shell, Display Server: X Server 1.21.1.7, Compiler: GCC 13.2.0, File-System: ext4, Screen Resolution: 640x480 9654 2: Processor: AMD EPYC 9654 96-Core @ 2.40GHz (96 Cores / 192 Threads), Motherboard: AMD Titanite_4G (RTI1007B BIOS), Chipset: AMD Device 14a4, Memory: 768GB, Disk: 3201GB Micron_7450_MTFDKCC3T2TFS, Graphics: ASPEED, Network: Broadcom NetXtreme BCM5720 PCIe OS: Ubuntu 23.10, Kernel: 6.6.0-060600rc1-generic (x86_64), Desktop: GNOME Shell, Display Server: X Server 1.21.1.7, Compiler: GCC 13.2.0, File-System: ext4, Screen Resolution: 1920x1200 9684x: Processor: AMD EPYC 9684X 96-Core @ 2.55GHz (96 Cores / 192 Threads), Motherboard: AMD Titanite_4G (RTI1007B BIOS), Chipset: AMD Device 14a4, Memory: 768GB, Disk: 3201GB Micron_7450_MTFDKCC3T2TFS, Graphics: ASPEED, Network: Broadcom NetXtreme BCM5720 PCIe OS: Ubuntu 23.10, Kernel: 6.6.0-060600rc1-generic (x86_64), Display Server: X Server 1.21.1.7, Compiler: GCC 13.2.0, File-System: ext4, Screen Resolution: 1920x1200 9684x 2: Processor: AMD EPYC 9684X 96-Core @ 2.55GHz (96 Cores / 192 Threads), Motherboard: AMD Titanite_4G (RTI1007B BIOS), Chipset: AMD Device 14a4, Memory: 768GB, Disk: 3201GB Micron_7450_MTFDKCC3T2TFS, Graphics: ASPEED, Network: Broadcom NetXtreme BCM5720 PCIe OS: Ubuntu 23.10, Kernel: 6.6.0-060600rc1-generic (x86_64), Display Server: X Server 1.21.1.7, Compiler: GCC 13.2.0, File-System: ext4, Screen Resolution: 1920x1200 PostgreSQL 16 Scaling Factor: 1000 - Clients: 500 - Mode: Read Only - Average Latency ms < Lower Is Better 9754 a .. 0.222 |===================================================== 9654 .... 0.237 |======================================================== 9654 2 .. 0.249 |=========================================================== 9684x ... 0.262 |============================================================== 9684x 2 . 0.262 |============================================================== PostgreSQL 16 Scaling Factor: 1000 - Clients: 500 - Mode: Read Only TPS > Higher Is Better 9754 a .. 2248583 |============================================================ 9654 .... 2113776 |======================================================== 9654 2 .. 2010379 |====================================================== 9684x ... 1906670 |=================================================== 9684x 2 . 1908831 |=================================================== PostgreSQL 16 Scaling Factor: 1000 - Clients: 800 - Mode: Read Only - Average Latency ms < Lower Is Better 9754 a .. 0.349 |============================================= 9654 .... 0.390 |================================================== 9654 2 .. 0.459 |=========================================================== 9684x ... 0.481 |============================================================== 9684x 2 . 0.471 |============================================================= PostgreSQL 16 Scaling Factor: 1000 - Clients: 800 - Mode: Read Only TPS > Higher Is Better 9754 a .. 2293591 |============================================================ 9654 .... 2048667 |====================================================== 9654 2 .. 1743953 |============================================== 9684x ... 1662214 |=========================================== 9684x 2 . 1698086 |============================================ PostgreSQL 16 Scaling Factor: 1000 - Clients: 100 - Mode: Read Only - Average Latency ms < Lower Is Better 9754 a .. 0.055 |============================================================== 9654 .... 0.046 |==================================================== 9654 2 .. 0.044 |================================================== 9684x ... 0.047 |===================================================== 9684x 2 . 0.048 |====================================================== PostgreSQL 16 Scaling Factor: 1000 - Clients: 100 - Mode: Read Only TPS > Higher Is Better 9754 a .. 1827118 |================================================ 9654 .... 2170402 |========================================================= 9654 2 .. 2274877 |============================================================ 9684x ... 2131667 |======================================================== 9684x 2 . 2097171 |======================================================= PostgreSQL 16 Scaling Factor: 1000 - Clients: 250 - Mode: Read Only - Average Latency ms < Lower Is Better 9754 a .. 0.117 |===================================================== 9654 .... 0.126 |========================================================= 9654 2 .. 0.121 |======================================================= 9684x ... 0.136 |============================================================== 9684x 2 . 0.129 |=========================================================== PostgreSQL 16 Scaling Factor: 1000 - Clients: 250 - Mode: Read Only TPS > Higher Is Better 9754 a .. 2130866 |============================================================ 9654 .... 1976344 |======================================================== 9654 2 .. 2068938 |========================================================== 9684x ... 1835450 |==================================================== 9684x 2 . 1933047 |====================================================== PostgreSQL 16 Scaling Factor: 1000 - Clients: 50 - Mode: Read Write - Average Latency ms < Lower Is Better 9754 a .. 1.741 |======================================== 9654 .... 2.730 |============================================================== 9654 2 .. 0.753 |================= 9684x ... 0.791 |================== 9684x 2 . 0.784 |================== PostgreSQL 16 Scaling Factor: 1000 - Clients: 50 - Mode: Read Write TPS > Higher Is Better 9754 a .. 28727 |=========================== 9654 .... 18315 |================= 9654 2 .. 66417 |============================================================== 9684x ... 63183 |=========================================================== 9684x 2 . 63740 |============================================================ PostgreSQL 16 Scaling Factor: 1000 - Clients: 50 - Mode: Read Only - Average Latency ms < Lower Is Better 9754 a .. 0.031 |============================================================== 9654 .... 0.030 |============================================================ 9654 2 .. 0.028 |======================================================== 9684x ... 0.029 |========================================================== 9684x 2 . 0.029 |========================================================== PostgreSQL 16 Scaling Factor: 1000 - Clients: 50 - Mode: Read Only TPS > Higher Is Better 9754 a .. 1631106 |====================================================== 9654 .... 1656704 |======================================================= 9654 2 .. 1810014 |============================================================ 9684x ... 1711627 |========================================================= 9684x 2 . 1714198 |========================================================= PostgreSQL 16 Scaling Factor: 100 - Clients: 50 - Mode: Read Only - Average Latency ms < Lower Is Better 9754 a .. 0.026 |============================================================== 9654 .... 0.024 |========================================================= 9654 2 .. 0.023 |======================================================= 9684x ... 0.025 |============================================================ 9684x 2 . 0.025 |============================================================ PostgreSQL 16 Scaling Factor: 100 - Clients: 50 - Mode: Read Only TPS > Higher Is Better 9754 a .. 1901416 |===================================================== 9654 .... 2097243 |=========================================================== 9654 2 .. 2135540 |============================================================ 9684x ... 1999282 |======================================================== 9684x 2 . 1972246 |======================================================= PostgreSQL 16 Scaling Factor: 100 - Clients: 1000 - Mode: Read Only - Average Latency ms < Lower Is Better 9754 a .. 0.290 |========================================================== 9654 .... 0.268 |====================================================== 9654 2 .. 0.287 |========================================================= 9684x ... 0.306 |============================================================= 9684x 2 . 0.310 |============================================================== PostgreSQL 16 Scaling Factor: 100 - Clients: 1000 - Mode: Read Only TPS > Higher Is Better 9754 a .. 3449794 |======================================================= 9654 .... 3732425 |============================================================ 9654 2 .. 3480555 |======================================================== 9684x ... 3273230 |===================================================== 9684x 2 . 3222573 |==================================================== PostgreSQL 16 Scaling Factor: 100 - Clients: 800 - Mode: Read Write - Average Latency ms < Lower Is Better 9754 a .. 14.503 |============================================ 9654 .... 20.068 |============================================================= 9654 2 .. 9.876 |============================== 9684x ... 11.556 |=================================== 9684x 2 . 11.571 |=================================== PostgreSQL 16 Scaling Factor: 100 - Clients: 800 - Mode: Read Write TPS > Higher Is Better 9754 a .. 55162 |========================================== 9654 .... 39865 |=============================== 9654 2 .. 81001 |============================================================== 9684x ... 69228 |===================================================== 9684x 2 . 69139 |===================================================== PostgreSQL 16 Scaling Factor: 100 - Clients: 500 - Mode: Read Write - Average Latency ms < Lower Is Better 9754 a .. 8.452 |=============================================== 9654 .... 11.059 |============================================================= 9654 2 .. 5.831 |================================ 9684x ... 6.706 |===================================== 9684x 2 . 6.750 |===================================== PostgreSQL 16 Scaling Factor: 100 - Clients: 500 - Mode: Read Write TPS > Higher Is Better 9754 a .. 59156 |=========================================== 9654 .... 45212 |================================= 9654 2 .. 85743 |============================================================== 9684x ... 74563 |====================================================== 9684x 2 . 74074 |====================================================== PostgreSQL 16 Scaling Factor: 100 - Clients: 1000 - Mode: Read Write - Average Latency ms < Lower Is Better 9754 a .. 19.79 |====================================================== 9654 .... 22.71 |============================================================== 9684x ... 15.39 |========================================== 9684x 2 . 15.21 |========================================== PostgreSQL 16 Scaling Factor: 100 - Clients: 1000 - Mode: Read Write TPS > Higher Is Better 9754 a .. 50524 |================================================ 9654 .... 44035 |========================================== 9684x ... 64970 |============================================================= 9684x 2 . 65752 |============================================================== PostgreSQL 16 Scaling Factor: 100 - Clients: 800 - Mode: Read Only - Average Latency ms < Lower Is Better 9754 a .. 0.237 |============================================================== 9654 .... 0.212 |======================================================= 9654 2 .. 0.223 |========================================================== 9684x ... 0.234 |============================================================= 9684x 2 . 0.236 |============================================================== PostgreSQL 16 Scaling Factor: 100 - Clients: 800 - Mode: Read Only TPS > Higher Is Better 9754 a .. 3369008 |====================================================== 9654 .... 3772221 |============================================================ 9654 2 .. 3584538 |========================================================= 9684x ... 3424651 |====================================================== 9684x 2 . 3384420 |====================================================== PostgreSQL 16 Scaling Factor: 100 - Clients: 500 - Mode: Read Only - Average Latency ms < Lower Is Better 9754 a .. 0.152 |============================================================== 9654 .... 0.136 |======================================================= 9654 2 .. 0.137 |======================================================== 9684x ... 0.144 |=========================================================== 9684x 2 . 0.144 |=========================================================== PostgreSQL 16 Scaling Factor: 100 - Clients: 500 - Mode: Read Only TPS > Higher Is Better 9754 a .. 3295911 |====================================================== 9654 .... 3669408 |============================================================ 9654 2 .. 3643827 |============================================================ 9684x ... 3467050 |========================================================= 9684x 2 . 3467366 |========================================================= PostgreSQL 16 Scaling Factor: 100 - Clients: 250 - Mode: Read Write - Average Latency ms < Lower Is Better 9754 a .. 3.802 |============================================= 9654 .... 5.287 |============================================================== 9654 2 .. 2.748 |================================ 9684x ... 3.107 |==================================== 9684x 2 . 3.085 |==================================== PostgreSQL 16 Scaling Factor: 100 - Clients: 250 - Mode: Read Write TPS > Higher Is Better 9754 a .. 65749 |============================================= 9654 .... 47284 |================================ 9654 2 .. 90963 |============================================================== 9684x ... 80468 |======================================================= 9684x 2 . 81026 |======================================================= PostgreSQL 16 Scaling Factor: 100 - Clients: 100 - Mode: Read Write - Average Latency ms < Lower Is Better 9754 a .. 1.221 |============================================ 9654 .... 1.735 |============================================================== 9654 2 .. 1.138 |========================================= 9684x ... 1.164 |========================================== 9684x 2 . 1.187 |========================================== PostgreSQL 16 Scaling Factor: 100 - Clients: 100 - Mode: Read Write TPS > Higher Is Better 9754 a .. 81867 |========================================================== 9654 .... 57647 |========================================= 9654 2 .. 87883 |============================================================== 9684x ... 85924 |============================================================= 9684x 2 . 84253 |=========================================================== PostgreSQL 16 Scaling Factor: 100 - Clients: 50 - Mode: Read Write - Average Latency ms < Lower Is Better 9754 a .. 0.668 |====================================== 9654 .... 1.089 |============================================================== 9654 2 .. 0.594 |================================== 9684x ... 0.634 |==================================== 9684x 2 . 0.635 |==================================== PostgreSQL 16 Scaling Factor: 100 - Clients: 50 - Mode: Read Write TPS > Higher Is Better 9754 a .. 74844 |======================================================= 9654 .... 45898 |================================== 9654 2 .. 84180 |============================================================== 9684x ... 78865 |========================================================== 9684x 2 . 78792 |========================================================== PostgreSQL 16 Scaling Factor: 100 - Clients: 100 - Mode: Read Only - Average Latency ms < Lower Is Better 9754 a .. 0.036 |========================================================= 9654 .... 0.035 |======================================================== 9654 2 .. 0.036 |========================================================= 9684x ... 0.039 |============================================================== 9684x 2 . 0.039 |============================================================== PostgreSQL 16 Scaling Factor: 100 - Clients: 100 - Mode: Read Only TPS > Higher Is Better 9754 a .. 2770261 |=========================================================== 9654 .... 2817847 |============================================================ 9654 2 .. 2791059 |=========================================================== 9684x ... 2566129 |======================================================= 9684x 2 . 2556366 |====================================================== PostgreSQL 16 Scaling Factor: 100 - Clients: 250 - Mode: Read Only - Average Latency ms < Lower Is Better 9754 a .. 0.074 |============================================================== 9654 .... 0.067 |======================================================== 9654 2 .. 0.067 |======================================================== 9684x ... 0.070 |=========================================================== 9684x 2 . 0.070 |=========================================================== PostgreSQL 16 Scaling Factor: 100 - Clients: 250 - Mode: Read Only TPS > Higher Is Better 9754 a .. 3362423 |====================================================== 9654 .... 3731124 |============================================================ 9654 2 .. 3746240 |============================================================ 9684x ... 3568078 |========================================================= 9684x 2 . 3588981 |========================================================= PostgreSQL 16 Scaling Factor: 1 - Clients: 1000 - Mode: Read Write - Average Latency ms < Lower Is Better 9754 a .. 1123.23 |======================================================== 9654 .... 1051.62 |==================================================== 9654 2 .. 1212.52 |============================================================ 9684x ... 1113.47 |======================================================= 9684x 2 . 1045.60 |==================================================== PostgreSQL 16 Scaling Factor: 1 - Clients: 1000 - Mode: Read Write TPS > Higher Is Better 9754 a .. 890 |============================================================ 9654 .... 951 |================================================================ 9654 2 .. 825 |======================================================= 9684x ... 898 |============================================================ 9684x 2 . 956 |================================================================ PostgreSQL 16 Scaling Factor: 1 - Clients: 800 - Mode: Read Write - Average Latency ms < Lower Is Better 9754 a .. 739.21 |====================================================== 9654 .... 595.37 |=========================================== 9654 2 .. 735.62 |===================================================== 9684x ... 840.62 |============================================================= 9684x 2 . 734.46 |===================================================== PostgreSQL 16 Scaling Factor: 1 - Clients: 800 - Mode: Read Write TPS > Higher Is Better 9754 a .. 1082 |=================================================== 9654 .... 1344 |=============================================================== 9654 2 .. 1088 |=================================================== 9684x ... 952 |============================================= 9684x 2 . 1089 |=================================================== PostgreSQL 16 Scaling Factor: 1 - Clients: 50 - Mode: Read Only - Average Latency ms < Lower Is Better 9754 a .. 0.025 |============================================================== 9654 .... 0.022 |======================================================= 9654 2 .. 0.022 |======================================================= 9684x ... 0.023 |========================================================= 9684x 2 . 0.023 |========================================================= PostgreSQL 16 Scaling Factor: 1 - Clients: 50 - Mode: Read Only TPS > Higher Is Better 9754 a .. 2019157 |===================================================== 9654 .... 2230747 |=========================================================== 9654 2 .. 2281274 |============================================================ 9684x ... 2134963 |======================================================== 9684x 2 . 2129207 |======================================================== PostgreSQL 16 Scaling Factor: 1 - Clients: 500 - Mode: Read Write - Average Latency ms < Lower Is Better 9754 a .. 293.28 |========================================================== 9654 .... 232.74 |============================================== 9654 2 .. 245.60 |================================================= 9684x ... 247.09 |================================================= 9684x 2 . 308.05 |============================================================= PostgreSQL 16 Scaling Factor: 1 - Clients: 500 - Mode: Read Write TPS > Higher Is Better 9754 a .. 1705 |================================================== 9654 .... 2148 |=============================================================== 9654 2 .. 2036 |============================================================ 9684x ... 2024 |=========================================================== 9684x 2 . 1623 |================================================ PostgreSQL 16 Scaling Factor: 1 - Clients: 250 - Mode: Read Write - Average Latency ms < Lower Is Better 9754 a .. 72.08 |============================================================== 9654 .... 65.94 |========================================================= 9654 2 .. 63.28 |====================================================== 9684x ... 64.23 |======================================================= 9684x 2 . 64.42 |======================================================= PostgreSQL 16 Scaling Factor: 1 - Clients: 250 - Mode: Read Write TPS > Higher Is Better 9754 a .. 3468 |======================================================= 9654 .... 3791 |============================================================ 9654 2 .. 3951 |=============================================================== 9684x ... 3892 |============================================================== 9684x 2 . 3881 |============================================================== PostgreSQL 16 Scaling Factor: 1 - Clients: 100 - Mode: Read Write - Average Latency ms < Lower Is Better 9754 a .. 18.42 |============================================================== 9654 .... 16.55 |======================================================== 9654 2 .. 15.96 |====================================================== 9684x ... 15.72 |===================================================== 9684x 2 . 15.39 |==================================================== PostgreSQL 16 Scaling Factor: 1 - Clients: 100 - Mode: Read Write TPS > Higher Is Better 9754 a .. 5430 |===================================================== 9654 .... 6044 |=========================================================== 9654 2 .. 6267 |============================================================= 9684x ... 6363 |============================================================== 9684x 2 . 6497 |=============================================================== PostgreSQL 16 Scaling Factor: 1 - Clients: 1000 - Mode: Read Only - Average Latency ms < Lower Is Better 9754 a .. 0.307 |============================================================== 9654 .... 0.265 |====================================================== 9654 2 .. 0.264 |===================================================== 9684x ... 0.278 |======================================================== 9684x 2 . 0.277 |======================================================== PostgreSQL 16 Scaling Factor: 1 - Clients: 1000 - Mode: Read Only TPS > Higher Is Better 9754 a .. 3253060 |=================================================== 9654 .... 3766560 |============================================================ 9654 2 .. 3794526 |============================================================ 9684x ... 3591156 |========================================================= 9684x 2 . 3606341 |========================================================= PostgreSQL 16 Scaling Factor: 1 - Clients: 50 - Mode: Read Write - Average Latency ms < Lower Is Better 9754 a .. 7.299 |============================================================== 9654 .... 7.012 |============================================================ 9654 2 .. 6.340 |====================================================== 9684x ... 6.498 |======================================================= 9684x 2 . 6.257 |===================================================== PostgreSQL 16 Scaling Factor: 1 - Clients: 50 - Mode: Read Write TPS > Higher Is Better 9754 a .. 6850 |====================================================== 9654 .... 7130 |======================================================== 9654 2 .. 7887 |============================================================== 9684x ... 7695 |============================================================= 9684x 2 . 7991 |=============================================================== PostgreSQL 16 Scaling Factor: 1 - Clients: 800 - Mode: Read Only - Average Latency ms < Lower Is Better 9754 a .. 0.238 |============================================================== 9654 .... 0.210 |======================================================= 9654 2 .. 0.221 |========================================================== 9684x ... 0.218 |========================================================= 9684x 2 . 0.222 |========================================================== PostgreSQL 16 Scaling Factor: 1 - Clients: 800 - Mode: Read Only TPS > Higher Is Better 9754 a .. 3365469 |===================================================== 9654 .... 3813783 |============================================================ 9654 2 .. 3628066 |========================================================= 9684x ... 3662778 |========================================================== 9684x 2 . 3607544 |========================================================= PostgreSQL 16 Scaling Factor: 1 - Clients: 100 - Mode: Read Only - Average Latency ms < Lower Is Better 9754 a .. 0.034 |========================================================= 9654 .... 0.033 |======================================================= 9654 2 .. 0.034 |========================================================= 9684x ... 0.037 |============================================================== 9684x 2 . 0.037 |============================================================== PostgreSQL 16 Scaling Factor: 1 - Clients: 100 - Mode: Read Only TPS > Higher Is Better 9754 a .. 2911296 |========================================================== 9654 .... 3006116 |============================================================ 9654 2 .. 2977070 |=========================================================== 9684x ... 2716415 |====================================================== 9684x 2 . 2724512 |====================================================== PostgreSQL 16 Scaling Factor: 1 - Clients: 500 - Mode: Read Only - Average Latency ms < Lower Is Better 9754 a .. 0.141 |============================================================== 9654 .... 0.132 |========================================================== 9654 2 .. 0.131 |========================================================== 9684x ... 0.135 |=========================================================== 9684x 2 . 0.136 |============================================================ PostgreSQL 16 Scaling Factor: 1 - Clients: 500 - Mode: Read Only TPS > Higher Is Better 9754 a .. 3538976 |======================================================== 9654 .... 3785416 |============================================================ 9654 2 .. 3811823 |============================================================ 9684x ... 3698699 |========================================================== 9684x 2 . 3683445 |========================================================== PostgreSQL 16 Scaling Factor: 1 - Clients: 250 - Mode: Read Only - Average Latency ms < Lower Is Better 9754 a .. 0.073 |============================================================== 9654 .... 0.064 |====================================================== 9654 2 .. 0.066 |======================================================== 9684x ... 0.067 |========================================================= 9684x 2 . 0.068 |========================================================== PostgreSQL 16 Scaling Factor: 1 - Clients: 250 - Mode: Read Only TPS > Higher Is Better 9754 a .. 3437087 |==================================================== 9654 .... 3930469 |============================================================ 9654 2 .. 3805943 |========================================================== 9684x ... 3728084 |========================================================= 9684x 2 . 3687260 |========================================================