postgresql 16 ryzen AMD Ryzen 9 7950X 16-Core testing with a ASUS ROG STRIX X670E-E GAMING WIFI (1416 BIOS) and AMD Radeon 16GB on Ubuntu 23.04 via the Phoronix Test Suite. a: Processor: AMD Ryzen 9 7950X 16-Core @ 5.88GHz (16 Cores / 32 Threads), Motherboard: ASUS ROG STRIX X670E-E GAMING WIFI (1416 BIOS), Chipset: AMD Device 14d8, Memory: 32GB, Disk: Western Digital WD_BLACK SN850X 1000GB + 4001GB Western Digital WD_BLACK SN850X 4000GB, Graphics: AMD Radeon 16GB (2124/1218MHz), Audio: AMD Device ab30, Monitor: ASUS MG28U, Network: Intel I225-V + Intel Wi-Fi 6 AX210/AX211/AX411 OS: Ubuntu 23.04, Kernel: 6.5.0-060500daily20230909-generic (x86_64), Desktop: GNOME Shell 44.3, Display Server: X Server 1.21.1.7 + Wayland, OpenGL: 4.6 Mesa 23.3~git2308310600.c8687a~oibaf~l (git-c8687a4 2023-08-31 lunar-oibaf-ppa) (LLVM 15.0.7 DRM 3.54), Compiler: GCC 12.3.0, File-System: ext4, Screen Resolution: 3840x2160 b: Processor: AMD Ryzen 9 7950X 16-Core @ 5.88GHz (16 Cores / 32 Threads), Motherboard: ASUS ROG STRIX X670E-E GAMING WIFI (1416 BIOS), Chipset: AMD Device 14d8, Memory: 32GB, Disk: Western Digital WD_BLACK SN850X 1000GB + 4001GB Western Digital WD_BLACK SN850X 4000GB, Graphics: AMD Radeon 16GB (2124/1218MHz), Audio: AMD Device ab30, Monitor: ASUS MG28U, Network: Intel I225-V + Intel Wi-Fi 6 AX210/AX211/AX411 OS: Ubuntu 23.04, Kernel: 6.5.0-060500daily20230909-generic (x86_64), Desktop: GNOME Shell 44.3, Display Server: X Server 1.21.1.7 + Wayland, OpenGL: 4.6 Mesa 23.3~git2308310600.c8687a~oibaf~l (git-c8687a4 2023-08-31 lunar-oibaf-ppa) (LLVM 15.0.7 DRM 3.54), Compiler: GCC 12.3.0, File-System: ext4, Screen Resolution: 3840x2160 c: Processor: AMD Ryzen 9 7950X 16-Core @ 5.88GHz (16 Cores / 32 Threads), Motherboard: ASUS ROG STRIX X670E-E GAMING WIFI (1416 BIOS), Chipset: AMD Device 14d8, Memory: 32GB, Disk: Western Digital WD_BLACK SN850X 1000GB + 4001GB Western Digital WD_BLACK SN850X 4000GB, Graphics: AMD Radeon 16GB (2124/1218MHz), Audio: AMD Device ab30, Monitor: ASUS MG28U, Network: Intel I225-V + Intel Wi-Fi 6 AX210/AX211/AX411 OS: Ubuntu 23.04, Kernel: 6.5.0-060500daily20230909-generic (x86_64), Desktop: GNOME Shell 44.3, Display Server: X Server 1.21.1.7 + Wayland, OpenGL: 4.6 Mesa 23.3~git2308310600.c8687a~oibaf~l (git-c8687a4 2023-08-31 lunar-oibaf-ppa) (LLVM 15.0.7 DRM 3.54), Compiler: GCC 12.3.0, File-System: ext4, Screen Resolution: 3840x2160 d: Processor: AMD Ryzen 9 7950X 16-Core @ 5.88GHz (16 Cores / 32 Threads), Motherboard: ASUS ROG STRIX X670E-E GAMING WIFI (1416 BIOS), Chipset: AMD Device 14d8, Memory: 32GB, Disk: Western Digital WD_BLACK SN850X 1000GB + 4001GB Western Digital WD_BLACK SN850X 4000GB, Graphics: AMD Radeon 16GB (2124/1218MHz), Audio: AMD Device ab30, Monitor: ASUS MG28U, Network: Intel I225-V + Intel Wi-Fi 6 AX210/AX211/AX411 OS: Ubuntu 23.04, Kernel: 6.5.0-060500daily20230909-generic (x86_64), Desktop: GNOME Shell 44.3, Display Server: X Server 1.21.1.7 + Wayland, OpenGL: 4.6 Mesa 23.3~git2308310600.c8687a~oibaf~l (git-c8687a4 2023-08-31 lunar-oibaf-ppa) (LLVM 15.0.7 DRM 3.54), Compiler: GCC 12.3.0, File-System: ext4, Screen Resolution: 3840x2160 e: Processor: AMD Ryzen 9 7950X 16-Core @ 5.88GHz (16 Cores / 32 Threads), Motherboard: ASUS ROG STRIX X670E-E GAMING WIFI (1416 BIOS), Chipset: AMD Device 14d8, Memory: 32GB, Disk: Western Digital WD_BLACK SN850X 1000GB + 4001GB Western Digital WD_BLACK SN850X 4000GB, Graphics: AMD Radeon 16GB (2124/1218MHz), Audio: AMD Device ab30, Monitor: ASUS MG28U, Network: Intel I225-V + Intel Wi-Fi 6 AX210/AX211/AX411 OS: Ubuntu 23.04, Kernel: 6.5.0-060500daily20230909-generic (x86_64), Desktop: GNOME Shell 44.3, Display Server: X Server 1.21.1.7 + Wayland, OpenGL: 4.6 Mesa 23.3~git2308310600.c8687a~oibaf~l (git-c8687a4 2023-08-31 lunar-oibaf-ppa) (LLVM 15.0.7 DRM 3.54), Compiler: GCC 12.3.0, File-System: ext4, Screen Resolution: 3840x2160 PostgreSQL 16 Scaling Factor: 1 - Clients: 800 - Mode: Read Only - Average Latency ms < Lower Is Better a . 0.581 |=================================================================== b . 0.593 |==================================================================== c . 0.584 |=================================================================== d . 0.579 |================================================================== e . 0.568 |================================================================= PostgreSQL 16 Scaling Factor: 1 - Clients: 800 - Mode: Read Only TPS > Higher Is Better a . 1376250 |================================================================= b . 1349891 |=============================================================== c . 1370452 |================================================================ d . 1381288 |================================================================= e . 1408165 |================================================================== PostgreSQL 16 Scaling Factor: 100 - Clients: 50 - Mode: Read Write - Average Latency ms < Lower Is Better a . 0.919 |==================================================================== b . 0.901 |=================================================================== c . 0.890 |================================================================== d . 0.889 |================================================================== e . 0.888 |================================================================== PostgreSQL 16 Scaling Factor: 100 - Clients: 50 - Mode: Read Write TPS > Higher Is Better a . 54436 |================================================================== b . 55478 |=================================================================== c . 56198 |==================================================================== d . 56241 |==================================================================== e . 56298 |==================================================================== PostgreSQL 16 Scaling Factor: 100 - Clients: 250 - Mode: Read Write - Average Latency ms < Lower Is Better a . 3.916 |=================================================================== b . 3.967 |==================================================================== c . 3.851 |================================================================== d . 3.849 |================================================================== e . 3.886 |=================================================================== PostgreSQL 16 Scaling Factor: 1 - Clients: 50 - Mode: Read Only - Average Latency ms < Lower Is Better a . 0.034 |==================================================================== b . 0.033 |================================================================== c . 0.033 |================================================================== d . 0.033 |================================================================== e . 0.033 |================================================================== PostgreSQL 16 Scaling Factor: 100 - Clients: 250 - Mode: Read Write TPS > Higher Is Better a . 63848 |=================================================================== b . 63052 |================================================================== c . 64925 |==================================================================== d . 64950 |==================================================================== e . 64340 |=================================================================== PostgreSQL 16 Scaling Factor: 100 - Clients: 100 - Mode: Read Write TPS > Higher Is Better a . 64298 |================================================================== b . 64873 |=================================================================== c . 65970 |==================================================================== d . 65892 |==================================================================== e . 65670 |==================================================================== PostgreSQL 16 Scaling Factor: 100 - Clients: 800 - Mode: Read Write - Average Latency ms < Lower Is Better a . 16.36 |=================================================================== b . 16.62 |==================================================================== c . 16.20 |================================================================== d . 16.24 |================================================================== e . 16.26 |=================================================================== PostgreSQL 16 Scaling Factor: 100 - Clients: 800 - Mode: Read Write TPS > Higher Is Better a . 48907 |=================================================================== b . 48126 |================================================================== c . 49372 |==================================================================== d . 49256 |==================================================================== e . 49192 |==================================================================== PostgreSQL 16 Scaling Factor: 100 - Clients: 100 - Mode: Read Write - Average Latency ms < Lower Is Better a . 1.555 |==================================================================== b . 1.542 |=================================================================== c . 1.516 |================================================================== d . 1.518 |================================================================== e . 1.523 |=================================================================== PostgreSQL 16 Scaling Factor: 100 - Clients: 800 - Mode: Read Only - Average Latency ms < Lower Is Better a . 0.673 |==================================================================== b . 0.658 |================================================================== c . 0.665 |=================================================================== d . 0.658 |================================================================== e . 0.662 |=================================================================== PostgreSQL 16 Scaling Factor: 100 - Clients: 500 - Mode: Read Only - Average Latency ms < Lower Is Better a . 0.354 |================================================================== b . 0.357 |=================================================================== c . 0.362 |==================================================================== d . 0.357 |=================================================================== e . 0.354 |================================================================== PostgreSQL 16 Scaling Factor: 100 - Clients: 800 - Mode: Read Only TPS > Higher Is Better a . 1189288 |================================================================= b . 1215557 |================================================================== c . 1203557 |================================================================= d . 1215503 |================================================================== e . 1207903 |================================================================== PostgreSQL 16 Scaling Factor: 100 - Clients: 500 - Mode: Read Only TPS > Higher Is Better a . 1411056 |================================================================== b . 1400715 |================================================================= c . 1381803 |================================================================= d . 1402239 |================================================================== e . 1411872 |================================================================== PostgreSQL 16 Scaling Factor: 100 - Clients: 100 - Mode: Read Only TPS > Higher Is Better a . 1433995 |================================================================= b . 1438110 |================================================================= c . 1427369 |================================================================= d . 1453808 |================================================================== e . 1437334 |================================================================= PostgreSQL 16 Scaling Factor: 1 - Clients: 50 - Mode: Read Only TPS > Higher Is Better a . 1486529 |================================================================= b . 1501437 |================================================================== c . 1496324 |================================================================= d . 1509879 |================================================================== e . 1503632 |================================================================== PostgreSQL 16 Scaling Factor: 100 - Clients: 100 - Mode: Read Only - Average Latency ms < Lower Is Better a . 0.070 |==================================================================== b . 0.069 |=================================================================== c . 0.070 |==================================================================== d . 0.069 |=================================================================== e . 0.070 |==================================================================== PostgreSQL 16 Scaling Factor: 1 - Clients: 50 - Mode: Read Write - Average Latency ms < Lower Is Better a . 12.66 |==================================================================== b . 12.57 |==================================================================== c . 12.51 |=================================================================== d . 12.51 |=================================================================== e . 12.48 |=================================================================== PostgreSQL 16 Scaling Factor: 1 - Clients: 50 - Mode: Read Write TPS > Higher Is Better a . 3950 |==================================================================== b . 3977 |===================================================================== c . 3997 |===================================================================== d . 3999 |===================================================================== e . 4006 |===================================================================== PostgreSQL 16 Scaling Factor: 1 - Clients: 500 - Mode: Read Only - Average Latency ms < Lower Is Better a . 0.319 |=================================================================== b . 0.319 |=================================================================== c . 0.321 |==================================================================== d . 0.318 |=================================================================== e . 0.322 |==================================================================== PostgreSQL 16 Scaling Factor: 1 - Clients: 500 - Mode: Read Only TPS > Higher Is Better a . 1566873 |================================================================== b . 1566167 |================================================================== c . 1559347 |================================================================== d . 1570215 |================================================================== e . 1551367 |================================================================= PostgreSQL 16 Scaling Factor: 100 - Clients: 250 - Mode: Read Only - Average Latency ms < Lower Is Better a . 0.173 |==================================================================== b . 0.172 |=================================================================== c . 0.174 |==================================================================== d . 0.172 |=================================================================== e . 0.172 |=================================================================== PostgreSQL 16 Scaling Factor: 100 - Clients: 250 - Mode: Read Only TPS > Higher Is Better a . 1446014 |================================================================== b . 1453635 |================================================================== c . 1438637 |================================================================= d . 1449818 |================================================================== e . 1454478 |================================================================== PostgreSQL 16 Scaling Factor: 1 - Clients: 100 - Mode: Read Write TPS > Higher Is Better a . 3664 |==================================================================== b . 3666 |==================================================================== c . 3682 |===================================================================== d . 3699 |===================================================================== e . 3683 |===================================================================== PostgreSQL 16 Scaling Factor: 1 - Clients: 100 - Mode: Read Write - Average Latency ms < Lower Is Better a . 27.30 |==================================================================== b . 27.28 |==================================================================== c . 27.16 |==================================================================== d . 27.04 |=================================================================== e . 27.15 |==================================================================== PostgreSQL 16 Scaling Factor: 100 - Clients: 50 - Mode: Read Only TPS > Higher Is Better a . 1419762 |================================================================= b . 1421853 |================================================================== c . 1432233 |================================================================== d . 1424500 |================================================================== e . 1419252 |================================================================= PostgreSQL 16 Scaling Factor: 100 - Clients: 500 - Mode: Read Write TPS > Higher Is Better a . 55642 |=================================================================== b . 56094 |==================================================================== c . 55661 |=================================================================== d . 55817 |==================================================================== e . 56017 |==================================================================== PostgreSQL 16 Scaling Factor: 100 - Clients: 500 - Mode: Read Write - Average Latency ms < Lower Is Better a . 8.986 |==================================================================== b . 8.914 |=================================================================== c . 8.983 |==================================================================== d . 8.958 |==================================================================== e . 8.926 |==================================================================== PostgreSQL 16 Scaling Factor: 1 - Clients: 250 - Mode: Read Only TPS > Higher Is Better a . 1576800 |================================================================== b . 1575894 |================================================================== c . 1570938 |================================================================== d . 1580324 |================================================================== e . 1582386 |================================================================== PostgreSQL 16 Scaling Factor: 1 - Clients: 250 - Mode: Read Only - Average Latency ms < Lower Is Better a . 0.159 |==================================================================== b . 0.159 |==================================================================== c . 0.159 |==================================================================== d . 0.158 |==================================================================== e . 0.158 |==================================================================== PostgreSQL 16 Scaling Factor: 1 - Clients: 100 - Mode: Read Only TPS > Higher Is Better a . 1542020 |================================================================== b . 1542655 |================================================================== c . 1541990 |================================================================== d . 1543912 |================================================================== e . 1547379 |================================================================== PostgreSQL 16 Scaling Factor: 100 - Clients: 50 - Mode: Read Only - Average Latency ms < Lower Is Better a . 0.035 |==================================================================== b . 0.035 |==================================================================== c . 0.035 |==================================================================== d . 0.035 |==================================================================== e . 0.035 |==================================================================== PostgreSQL 16 Scaling Factor: 1 - Clients: 100 - Mode: Read Only - Average Latency ms < Lower Is Better a . 0.065 |==================================================================== b . 0.065 |==================================================================== c . 0.065 |==================================================================== d . 0.065 |==================================================================== e . 0.065 |==================================================================== PostgreSQL 16 Scaling Factor: 1 - Clients: 800 - Mode: Read Write - Average Latency ms < Lower Is Better a . 699.69 |============================================================== b . 703.42 |============================================================== c . 648.71 |========================================================= d . 725.89 |================================================================ e . 760.40 |=================================================================== PostgreSQL 16 Scaling Factor: 1 - Clients: 800 - Mode: Read Write TPS > Higher Is Better a . 1153 |================================================================= b . 1142 |================================================================ c . 1233 |===================================================================== d . 1102 |============================================================== e . 1052 |=========================================================== PostgreSQL 16 Scaling Factor: 1 - Clients: 500 - Mode: Read Write - Average Latency ms < Lower Is Better a . 255.75 |================================================================ b . 244.09 |============================================================= c . 230.70 |========================================================= d . 269.75 |=================================================================== e . 262.42 |================================================================= PostgreSQL 16 Scaling Factor: 1 - Clients: 500 - Mode: Read Write TPS > Higher Is Better a . 1972 |=============================================================== b . 2050 |================================================================= c . 2167 |===================================================================== d . 1854 |=========================================================== e . 1905 |============================================================= PostgreSQL 16 Scaling Factor: 1 - Clients: 250 - Mode: Read Write - Average Latency ms < Lower Is Better a . 88.82 |==================================================================== b . 88.34 |==================================================================== c . 87.99 |=================================================================== d . 88.88 |==================================================================== e . 87.93 |=================================================================== PostgreSQL 16 Scaling Factor: 1 - Clients: 250 - Mode: Read Write TPS > Higher Is Better a . 2831 |===================================================================== b . 2830 |===================================================================== c . 2841 |===================================================================== d . 2813 |==================================================================== e . 2843 |=====================================================================