PostgreSQL Ryzen AMD Ryzen 9 7900 12-Core testing with a ASRockRack B650D4U-2L2T/BCM (2.09 BIOS) and ASPEED on Ubuntu 22.04 via the Phoronix Test Suite. a: Processor: AMD Ryzen 9 7900 12-Core @ 5.48GHz (12 Cores / 24 Threads), Motherboard: ASRockRack B650D4U-2L2T/BCM (2.09 BIOS), Chipset: AMD Device 14d8, Memory: 62GB, Disk: 3201GB Micron_7450_MTFDKCC3T2TFS + 0GB Virtual HDisk0 + 0GB Virtual HDisk1 + 0GB Virtual HDisk2 + 0GB Virtual HDisk3, Graphics: ASPEED, Audio: AMD Device 1640, Monitor: VA2431, Network: 2 x Intel I210 + 2 x Broadcom BCM57416 NetXtreme-E Dual-Media 10G RDMA OS: Ubuntu 22.04, Kernel: 6.6.0-060600rc1daily20230913-generic (x86_64), Desktop: GNOME Shell 42.9, Display Server: X Server 1.21.1.4, Vulkan: 1.3.238, Compiler: GCC 11.4.0, File-System: ext4, Screen Resolution: 1920x1200 b: Processor: AMD Ryzen 9 7900 12-Core @ 5.48GHz (12 Cores / 24 Threads), Motherboard: ASRockRack B650D4U-2L2T/BCM (2.09 BIOS), Chipset: AMD Device 14d8, Memory: 62GB, Disk: 3201GB Micron_7450_MTFDKCC3T2TFS + 0GB Virtual HDisk0 + 0GB Virtual HDisk1 + 0GB Virtual HDisk2 + 0GB Virtual HDisk3, Graphics: ASPEED, Audio: AMD Device 1640, Monitor: VA2431, Network: 2 x Intel I210 + 2 x Broadcom BCM57416 NetXtreme-E Dual-Media 10G RDMA OS: Ubuntu 22.04, Kernel: 6.6.0-060600rc1daily20230913-generic (x86_64), Desktop: GNOME Shell 42.9, Display Server: X Server 1.21.1.4, Vulkan: 1.3.238, Compiler: GCC 11.4.0, File-System: ext4, Screen Resolution: 1920x1200 c: Processor: AMD Ryzen 9 7900 12-Core @ 5.48GHz (12 Cores / 24 Threads), Motherboard: ASRockRack B650D4U-2L2T/BCM (2.09 BIOS), Chipset: AMD Device 14d8, Memory: 62GB, Disk: 3201GB Micron_7450_MTFDKCC3T2TFS + 0GB Virtual HDisk0 + 0GB Virtual HDisk1 + 0GB Virtual HDisk2 + 0GB Virtual HDisk3, Graphics: ASPEED, Audio: AMD Device 1640, Monitor: VA2431, Network: 2 x Intel I210 + 2 x Broadcom BCM57416 NetXtreme-E Dual-Media 10G RDMA OS: Ubuntu 22.04, Kernel: 6.6.0-060600rc1daily20230913-generic (x86_64), Desktop: GNOME Shell 42.9, Display Server: X Server 1.21.1.4, Vulkan: 1.3.238, Compiler: GCC 11.4.0, File-System: ext4, Screen Resolution: 1920x1200 d: Processor: AMD Ryzen 9 7900 12-Core @ 5.48GHz (12 Cores / 24 Threads), Motherboard: ASRockRack B650D4U-2L2T/BCM (2.09 BIOS), Chipset: AMD Device 14d8, Memory: 62GB, Disk: 3201GB Micron_7450_MTFDKCC3T2TFS + 0GB Virtual HDisk0 + 0GB Virtual HDisk1 + 0GB Virtual HDisk2 + 0GB Virtual HDisk3, Graphics: ASPEED, Audio: AMD Device 1640, Monitor: VA2431, Network: 2 x Intel I210 + 2 x Broadcom BCM57416 NetXtreme-E Dual-Media 10G RDMA OS: Ubuntu 22.04, Kernel: 6.6.0-060600rc1daily20230913-generic (x86_64), Desktop: GNOME Shell 42.9, Display Server: X Server 1.21.1.4, Vulkan: 1.3.238, Compiler: GCC 11.4.0, File-System: ext4, Screen Resolution: 1920x1200 PostgreSQL 16 Scaling Factor: 1 - Clients: 100 - Mode: Read Only TPS > Higher Is Better a . 1149370 |================================================================== b . 1149560 |================================================================== c . 1145088 |================================================================== d . 1148486 |================================================================== PostgreSQL 16 Scaling Factor: 1 - Clients: 100 - Mode: Read Only - Average Latency ms < Lower Is Better a . 0.087 |==================================================================== b . 0.087 |==================================================================== c . 0.087 |==================================================================== d . 0.087 |==================================================================== PostgreSQL 16 Scaling Factor: 1 - Clients: 250 - Mode: Read Only TPS > Higher Is Better a . 1059034 |================================================================== b . 1038875 |================================================================= c . 1037332 |================================================================= d . 1038400 |================================================================= PostgreSQL 16 Scaling Factor: 1 - Clients: 250 - Mode: Read Only - Average Latency ms < Lower Is Better a . 0.236 |=================================================================== b . 0.241 |==================================================================== c . 0.241 |==================================================================== d . 0.241 |==================================================================== PostgreSQL 16 Scaling Factor: 1 - Clients: 500 - Mode: Read Only TPS > Higher Is Better a . 1021623 |================================================================= b . 1024472 |================================================================= c . 1040539 |================================================================== d . 1015669 |================================================================ PostgreSQL 16 Scaling Factor: 1 - Clients: 500 - Mode: Read Only - Average Latency ms < Lower Is Better a . 0.489 |==================================================================== b . 0.488 |=================================================================== c . 0.481 |================================================================== d . 0.492 |==================================================================== PostgreSQL 16 Scaling Factor: 1 - Clients: 800 - Mode: Read Only TPS > Higher Is Better a . 993132 |=================================================================== b . 983121 |================================================================== c . 992112 |=================================================================== d . 979499 |================================================================== PostgreSQL 16 Scaling Factor: 1 - Clients: 800 - Mode: Read Only - Average Latency ms < Lower Is Better a . 0.806 |=================================================================== b . 0.814 |==================================================================== c . 0.806 |=================================================================== d . 0.817 |==================================================================== PostgreSQL 16 Scaling Factor: 1 - Clients: 100 - Mode: Read Write TPS > Higher Is Better a . 7471 |===================================================================== b . 7404 |==================================================================== c . 7390 |==================================================================== d . 7439 |===================================================================== PostgreSQL 16 Scaling Factor: 1 - Clients: 100 - Mode: Read Write - Average Latency ms < Lower Is Better a . 13.39 |=================================================================== b . 13.51 |==================================================================== c . 13.53 |==================================================================== d . 13.44 |==================================================================== PostgreSQL 16 Scaling Factor: 1 - Clients: 1000 - Mode: Read Only TPS > Higher Is Better a . 956139 |================================================================== b . 967680 |=================================================================== c . 952918 |================================================================== d . 960127 |================================================================== PostgreSQL 16 Scaling Factor: 1 - Clients: 1000 - Mode: Read Only - Average Latency ms < Lower Is Better a . 1.046 |==================================================================== b . 1.033 |=================================================================== c . 1.049 |==================================================================== d . 1.042 |==================================================================== PostgreSQL 16 Scaling Factor: 1 - Clients: 250 - Mode: Read Write TPS > Higher Is Better a . 4791 |===================================================================== b . 4493 |================================================================= c . 4634 |=================================================================== d . 4466 |================================================================ PostgreSQL 16 Scaling Factor: 1 - Clients: 250 - Mode: Read Write - Average Latency ms < Lower Is Better a . 52.18 |=============================================================== b . 55.64 |==================================================================== c . 53.95 |================================================================== d . 55.98 |==================================================================== PostgreSQL 16 Scaling Factor: 1 - Clients: 500 - Mode: Read Write TPS > Higher Is Better a . 2375 |===================================================================== b . 2226 |================================================================= c . 2353 |==================================================================== d . 2182 |=============================================================== PostgreSQL 16 Scaling Factor: 1 - Clients: 500 - Mode: Read Write - Average Latency ms < Lower Is Better a . 210.50 |============================================================== b . 224.57 |================================================================== c . 212.51 |============================================================== d . 229.13 |=================================================================== PostgreSQL 16 Scaling Factor: 1 - Clients: 800 - Mode: Read Write TPS > Higher Is Better a . 1501 |===================================================================== b . 1388 |================================================================ c . 1278 |=========================================================== d . 1310 |============================================================ PostgreSQL 16 Scaling Factor: 1 - Clients: 800 - Mode: Read Write - Average Latency ms < Lower Is Better a . 533.00 |========================================================= b . 576.33 |============================================================== c . 626.10 |=================================================================== d . 610.78 |================================================================= PostgreSQL 16 Scaling Factor: 1 - Clients: 1000 - Mode: Read Write TPS > Higher Is Better a . 1236 |========================================================== b . 1140 |===================================================== c . 1163 |====================================================== d . 1475 |===================================================================== PostgreSQL 16 Scaling Factor: 1 - Clients: 1000 - Mode: Read Write - Average Latency ms < Lower Is Better a . 808.95 |============================================================== b . 877.53 |=================================================================== c . 860.09 |================================================================== d . 678.16 |==================================================== PostgreSQL 16 Scaling Factor: 100 - Clients: 100 - Mode: Read Only TPS > Higher Is Better a . 1072078 |================================================================= b . 1083638 |================================================================== c . 1080174 |================================================================== d . 1074656 |================================================================= PostgreSQL 16 Scaling Factor: 100 - Clients: 100 - Mode: Read Only - Average Latency ms < Lower Is Better a . 0.093 |==================================================================== b . 0.092 |=================================================================== c . 0.093 |==================================================================== d . 0.093 |==================================================================== PostgreSQL 16 Scaling Factor: 100 - Clients: 250 - Mode: Read Only TPS > Higher Is Better a . 954828 |================================================================== b . 959346 |=================================================================== c . 963682 |=================================================================== d . 957088 |=================================================================== PostgreSQL 16 Scaling Factor: 100 - Clients: 250 - Mode: Read Only - Average Latency ms < Lower Is Better a . 0.262 |==================================================================== b . 0.261 |==================================================================== c . 0.259 |=================================================================== d . 0.261 |==================================================================== PostgreSQL 16 Scaling Factor: 100 - Clients: 500 - Mode: Read Only TPS > Higher Is Better a . 938875 |=================================================================== b . 926183 |================================================================== c . 930236 |================================================================== d . 929546 |================================================================== PostgreSQL 16 Scaling Factor: 100 - Clients: 500 - Mode: Read Only - Average Latency ms < Lower Is Better a . 0.533 |=================================================================== b . 0.540 |==================================================================== c . 0.537 |==================================================================== d . 0.538 |==================================================================== PostgreSQL 16 Scaling Factor: 100 - Clients: 800 - Mode: Read Only TPS > Higher Is Better a . 873253 |================================================================== b . 876505 |=================================================================== c . 881787 |=================================================================== d . 864801 |================================================================== PostgreSQL 16 Scaling Factor: 100 - Clients: 800 - Mode: Read Only - Average Latency ms < Lower Is Better a . 0.916 |=================================================================== b . 0.913 |=================================================================== c . 0.907 |=================================================================== d . 0.925 |==================================================================== PostgreSQL 16 Scaling Factor: 100 - Clients: 100 - Mode: Read Write TPS > Higher Is Better a . 65575 |=================================================================== b . 64421 |================================================================= c . 66880 |==================================================================== d . 65949 |=================================================================== PostgreSQL 16 Scaling Factor: 100 - Clients: 100 - Mode: Read Write - Average Latency ms < Lower Is Better a . 1.525 |=================================================================== b . 1.552 |==================================================================== c . 1.495 |================================================================== d . 1.516 |================================================================== PostgreSQL 16 Scaling Factor: 100 - Clients: 1000 - Mode: Read Only TPS > Higher Is Better a . 838930 |================================================================== b . 839363 |================================================================== c . 833131 |================================================================= d . 852255 |=================================================================== PostgreSQL 16 Scaling Factor: 100 - Clients: 1000 - Mode: Read Only - Average Latency ms < Lower Is Better a . 1.192 |==================================================================== b . 1.191 |=================================================================== c . 1.200 |==================================================================== d . 1.173 |================================================================== PostgreSQL 16 Scaling Factor: 100 - Clients: 250 - Mode: Read Write TPS > Higher Is Better a . 56995 |==================================================================== b . 55345 |================================================================== c . 56072 |=================================================================== d . 56143 |=================================================================== PostgreSQL 16 Scaling Factor: 100 - Clients: 250 - Mode: Read Write - Average Latency ms < Lower Is Better a . 4.386 |================================================================== b . 4.517 |==================================================================== c . 4.459 |=================================================================== d . 4.453 |=================================================================== PostgreSQL 16 Scaling Factor: 100 - Clients: 500 - Mode: Read Write TPS > Higher Is Better a . 42312 |================================================================ b . 43676 |================================================================== c . 44517 |=================================================================== d . 44982 |==================================================================== PostgreSQL 16 Scaling Factor: 100 - Clients: 500 - Mode: Read Write - Average Latency ms < Lower Is Better a . 11.82 |==================================================================== b . 11.45 |================================================================== c . 11.23 |================================================================= d . 11.12 |================================================================ PostgreSQL 16 Scaling Factor: 100 - Clients: 800 - Mode: Read Write TPS > Higher Is Better a . 36584 |==================================================================== b . 36761 |==================================================================== c . 36407 |=================================================================== d . 35505 |================================================================== PostgreSQL 16 Scaling Factor: 100 - Clients: 800 - Mode: Read Write - Average Latency ms < Lower Is Better a . 21.87 |================================================================== b . 21.76 |================================================================== c . 21.97 |================================================================== d . 22.53 |==================================================================== PostgreSQL 16 Scaling Factor: 1000 - Clients: 100 - Mode: Read Only TPS > Higher Is Better a . 758195 |=================================================================== b . 754972 |=================================================================== c . 754744 |=================================================================== d . 759216 |=================================================================== PostgreSQL 16 Scaling Factor: 1000 - Clients: 100 - Mode: Read Only - Average Latency ms < Lower Is Better a . 0.132 |==================================================================== b . 0.132 |==================================================================== c . 0.132 |==================================================================== d . 0.132 |==================================================================== PostgreSQL 16 Scaling Factor: 1000 - Clients: 250 - Mode: Read Only TPS > Higher Is Better a . 744850 |================================================================== b . 754581 |=================================================================== c . 742614 |================================================================== d . 744506 |================================================================== PostgreSQL 16 Scaling Factor: 1000 - Clients: 250 - Mode: Read Only - Average Latency ms < Lower Is Better a . 0.336 |==================================================================== b . 0.331 |=================================================================== c . 0.337 |==================================================================== d . 0.336 |==================================================================== PostgreSQL 16 Scaling Factor: 1000 - Clients: 500 - Mode: Read Only TPS > Higher Is Better a . 632309 |================================================================== b . 642871 |=================================================================== c . 636687 |================================================================== d . 646297 |=================================================================== PostgreSQL 16 Scaling Factor: 1000 - Clients: 500 - Mode: Read Only - Average Latency ms < Lower Is Better a . 0.791 |==================================================================== b . 0.778 |=================================================================== c . 0.785 |=================================================================== d . 0.774 |=================================================================== PostgreSQL 16 Scaling Factor: 1000 - Clients: 800 - Mode: Read Only TPS > Higher Is Better a . 549915 |=================================================================== b . 539853 |================================================================== c . 544293 |================================================================== d . 536000 |================================================================= PostgreSQL 16 Scaling Factor: 1000 - Clients: 800 - Mode: Read Only - Average Latency ms < Lower Is Better a . 1.455 |================================================================== b . 1.482 |=================================================================== c . 1.470 |=================================================================== d . 1.493 |==================================================================== PostgreSQL 16 Scaling Factor: 100 - Clients: 1000 - Mode: Read Write TPS > Higher Is Better a . 32644 |==================================================================== b . 32288 |=================================================================== c . 32457 |==================================================================== d . 32225 |=================================================================== PostgreSQL 16 Scaling Factor: 100 - Clients: 1000 - Mode: Read Write - Average Latency ms < Lower Is Better a . 30.63 |=================================================================== b . 30.97 |==================================================================== c . 30.81 |==================================================================== d . 31.03 |==================================================================== PostgreSQL 16 Scaling Factor: 1000 - Clients: 100 - Mode: Read Write TPS > Higher Is Better a . 65983 |==================================================================== b . 66032 |==================================================================== c . 66064 |==================================================================== d . 65660 |==================================================================== PostgreSQL 16 Scaling Factor: 1000 - Clients: 100 - Mode: Read Write - Average Latency ms < Lower Is Better a . 1.516 |==================================================================== b . 1.514 |==================================================================== c . 1.514 |==================================================================== d . 1.523 |==================================================================== PostgreSQL 16 Scaling Factor: 1000 - Clients: 1000 - Mode: Read Only TPS > Higher Is Better a . 463601 |=================================================================== b . 436208 |=============================================================== c . 444429 |================================================================ d . 444654 |================================================================ PostgreSQL 16 Scaling Factor: 1000 - Clients: 1000 - Mode: Read Only - Average Latency ms < Lower Is Better a . 2.157 |================================================================ b . 2.292 |==================================================================== c . 2.250 |=================================================================== d . 2.249 |=================================================================== PostgreSQL 16 Scaling Factor: 1000 - Clients: 250 - Mode: Read Write TPS > Higher Is Better a . 59208 |==================================================================== b . 57327 |================================================================== c . 57037 |================================================================== d . 58412 |=================================================================== PostgreSQL 16 Scaling Factor: 1000 - Clients: 250 - Mode: Read Write - Average Latency ms < Lower Is Better a . 4.222 |================================================================== b . 4.361 |==================================================================== c . 4.383 |==================================================================== d . 4.280 |================================================================== PostgreSQL 16 Scaling Factor: 1000 - Clients: 500 - Mode: Read Write TPS > Higher Is Better a . 41382 |==================================================================== b . 40891 |=================================================================== c . 41570 |==================================================================== d . 40263 |================================================================== PostgreSQL 16 Scaling Factor: 1000 - Clients: 500 - Mode: Read Write - Average Latency ms < Lower Is Better a . 12.08 |================================================================== b . 12.23 |=================================================================== c . 12.03 |================================================================== d . 12.42 |==================================================================== PostgreSQL 16 Scaling Factor: 1000 - Clients: 800 - Mode: Read Write TPS > Higher Is Better a . 32804 |==================================================================== b . 32700 |==================================================================== c . 32523 |=================================================================== d . 32553 |=================================================================== PostgreSQL 16 Scaling Factor: 1000 - Clients: 800 - Mode: Read Write - Average Latency ms < Lower Is Better a . 24.39 |=================================================================== b . 24.47 |==================================================================== c . 24.60 |==================================================================== d . 24.58 |==================================================================== PostgreSQL 16 Scaling Factor: 1000 - Clients: 1000 - Mode: Read Write TPS > Higher Is Better a . 29957 |==================================================================== b . 29993 |==================================================================== c . 29466 |=================================================================== d . 29645 |=================================================================== PostgreSQL 16 Scaling Factor: 1000 - Clients: 1000 - Mode: Read Write - Average Latency ms < Lower Is Better a . 33.38 |=================================================================== b . 33.34 |=================================================================== c . 33.94 |==================================================================== d . 33.73 |====================================================================