pgbench 17 AMD Ryzen 9 9950X 16-Core testing with a ASUS ROG STRIX X670E-E GAMING WIFI (2401 BIOS) and AMD Radeon PRO W7900 45GB on Ubuntu 24.04 via the Phoronix Test Suite. a: Processor: AMD Ryzen 9 9950X 16-Core @ 5.75GHz (16 Cores / 32 Threads), Motherboard: ASUS ROG STRIX X670E-E GAMING WIFI (2401 BIOS), Chipset: AMD Device 14d8, Memory: 2 x 32GB DDR5-6400MT/s Corsair CMK64GX5M2B6400C32, Disk: 4001GB Western Digital WD_BLACK SN850X 4000GB + Western Digital WD_BLACK SN850X 2000GB + 257GB Flash Drive, Graphics: AMD Radeon PRO W7900 45GB (2200/3200MHz), Audio: AMD Navi 31 HDMI/DP, Monitor: DELL U2723QE, Network: Intel I225-V + Intel Wi-Fi 6E OS: Ubuntu 24.04, Kernel: 6.10.1-061001-generic (x86_64), Desktop: GNOME Shell 46.0, Display Server: X Server 1.21.1.11 + Wayland, OpenGL: 4.6 Mesa 24.2.0-devel (LLVM 18.1.7 DRM 3.57), OpenCL: OpenCL 2.1 AMD-APP (3625.0), Compiler: GCC 13.2.0, File-System: ext4, Screen Resolution: 3840x2160 b: Processor: AMD Ryzen 9 9950X 16-Core @ 5.75GHz (16 Cores / 32 Threads), Motherboard: ASUS ROG STRIX X670E-E GAMING WIFI (2401 BIOS), Chipset: AMD Device 14d8, Memory: 2 x 32GB DDR5-6400MT/s Corsair CMK64GX5M2B6400C32, Disk: 4001GB Western Digital WD_BLACK SN850X 4000GB + Western Digital WD_BLACK SN850X 2000GB + 257GB Flash Drive, Graphics: AMD Radeon PRO W7900 45GB (2200/3200MHz), Audio: AMD Navi 31 HDMI/DP, Monitor: DELL U2723QE, Network: Intel I225-V + Intel Wi-Fi 6E OS: Ubuntu 24.04, Kernel: 6.10.1-061001-generic (x86_64), Desktop: GNOME Shell 46.0, Display Server: X Server 1.21.1.11 + Wayland, OpenGL: 4.6 Mesa 24.2.0-devel (LLVM 18.1.7 DRM 3.57), OpenCL: OpenCL 2.1 AMD-APP (3625.0), Compiler: GCC 13.2.0, File-System: ext4, Screen Resolution: 3840x2160 c: Processor: AMD Ryzen 9 9950X 16-Core @ 5.75GHz (16 Cores / 32 Threads), Motherboard: ASUS ROG STRIX X670E-E GAMING WIFI (2401 BIOS), Chipset: AMD Device 14d8, Memory: 2 x 32GB DDR5-6400MT/s Corsair CMK64GX5M2B6400C32, Disk: 4001GB Western Digital WD_BLACK SN850X 4000GB + Western Digital WD_BLACK SN850X 2000GB + 257GB Flash Drive, Graphics: AMD Radeon PRO W7900 45GB (2200/3200MHz), Audio: AMD Navi 31 HDMI/DP, Monitor: DELL U2723QE, Network: Intel I225-V + Intel Wi-Fi 6E OS: Ubuntu 24.04, Kernel: 6.10.1-061001-generic (x86_64), Desktop: GNOME Shell 46.0, Display Server: X Server 1.21.1.11 + Wayland, OpenGL: 4.6 Mesa 24.2.0-devel (LLVM 18.1.7 DRM 3.57), OpenCL: OpenCL 2.1 AMD-APP (3625.0), Compiler: GCC 13.2.0, File-System: ext4, Screen Resolution: 3840x2160 PostgreSQL 17 Scaling Factor: 1 - Clients: 250 - Mode: Read Only TPS > Higher Is Better a . 2494898 |================================================================== b . 2487931 |================================================================== c . 2493234 |================================================================== PostgreSQL 17 Scaling Factor: 1 - Clients: 500 - Mode: Read Only TPS > Higher Is Better a . 2424319 |================================================================== b . 2416203 |================================================================== c . 2420293 |================================================================== PostgreSQL 17 Scaling Factor: 1 - Clients: 800 - Mode: Read Only TPS > Higher Is Better a . 2148559 |================================================================== b . 2123261 |================================================================= c . 2125239 |================================================================= PostgreSQL 17 Scaling Factor: 1 - Clients: 1000 - Mode: Read Only TPS > Higher Is Better a . 1792086 |================================================================= b . 1787489 |================================================================= c . 1821156 |================================================================== PostgreSQL 17 Scaling Factor: 1 - Clients: 250 - Mode: Read Write TPS > Higher Is Better a . 3614 |===================================================================== b . 3601 |===================================================================== c . 3600 |===================================================================== PostgreSQL 17 Scaling Factor: 1 - Clients: 500 - Mode: Read Write TPS > Higher Is Better a . 2643 |================================================================== b . 2623 |================================================================= c . 2782 |===================================================================== PostgreSQL 17 Scaling Factor: 1 - Clients: 800 - Mode: Read Write TPS > Higher Is Better a . 1687 |===================================================================== b . 1547 |=============================================================== c . 1504 |============================================================== PostgreSQL 17 Scaling Factor: 1 - Clients: 1000 - Mode: Read Write TPS > Higher Is Better a . 1302 |================================================================== b . 1352 |===================================================================== c . 1246 |================================================================ PostgreSQL 17 Scaling Factor: 100 - Clients: 250 - Mode: Read Only TPS > Higher Is Better a . 2195660 |================================================================== b . 2190080 |================================================================== c . 2195449 |================================================================== PostgreSQL 17 Scaling Factor: 100 - Clients: 500 - Mode: Read Only TPS > Higher Is Better a . 2114985 |================================================================== b . 2109580 |================================================================== c . 2101053 |================================================================== PostgreSQL 17 Scaling Factor: 100 - Clients: 800 - Mode: Read Only TPS > Higher Is Better a . 1849541 |================================================================== b . 1857810 |================================================================== c . 1861481 |================================================================== PostgreSQL 17 Scaling Factor: 100 - Clients: 1000 - Mode: Read Only TPS > Higher Is Better a . 1539681 |================================================================== b . 1521013 |================================================================= c . 1500977 |================================================================ PostgreSQL 17 Scaling Factor: 100 - Clients: 250 - Mode: Read Write TPS > Higher Is Better a . 49215 |==================================================================== b . 46096 |================================================================ c . 38332 |===================================================== PostgreSQL 17 Scaling Factor: 100 - Clients: 500 - Mode: Read Write TPS > Higher Is Better a . 46782 |==================================================================== b . 45173 |================================================================== c . 39751 |========================================================== PostgreSQL 17 Scaling Factor: 100 - Clients: 800 - Mode: Read Write TPS > Higher Is Better a . 43923 |==================================================================== b . 43487 |=================================================================== c . 38708 |============================================================ PostgreSQL 17 Scaling Factor: 1000 - Clients: 250 - Mode: Read Only TPS > Higher Is Better a . 1466539 |================================================================== b . 1473104 |================================================================== c . 1469404 |================================================================== PostgreSQL 17 Scaling Factor: 1000 - Clients: 500 - Mode: Read Only TPS > Higher Is Better a . 1351988 |================================================================== b . 1337223 |================================================================= c . 1350914 |================================================================== PostgreSQL 17 Scaling Factor: 1000 - Clients: 800 - Mode: Read Only TPS > Higher Is Better a . 1136399 |================================================================== b . 1118360 |================================================================= c . 1116572 |================================================================= PostgreSQL 17 Scaling Factor: 100 - Clients: 1000 - Mode: Read Write TPS > Higher Is Better a . 40100 |==================================================================== b . 37542 |================================================================ c . 34520 |=========================================================== PostgreSQL 17 Scaling Factor: 1000 - Clients: 1000 - Mode: Read Only TPS > Higher Is Better a . 979984 |================================================================== b . 988422 |=================================================================== c . 986623 |=================================================================== PostgreSQL 17 Scaling Factor: 1000 - Clients: 250 - Mode: Read Write TPS > Higher Is Better a . 24195 |==================================================================== b . 18781 |===================================================== c . 16719 |=============================================== PostgreSQL 17 Scaling Factor: 1000 - Clients: 500 - Mode: Read Write TPS > Higher Is Better a . 16413 |==================================================================== b . 14298 |=========================================================== c . 16101 |=================================================================== PostgreSQL 17 Scaling Factor: 1000 - Clients: 800 - Mode: Read Write TPS > Higher Is Better a . 16367 |==================================================================== b . 15269 |=============================================================== c . 15795 |================================================================== PostgreSQL 17 Scaling Factor: 1000 - Clients: 1000 - Mode: Read Write TPS > Higher Is Better a . 17010 |================================================================== b . 14721 |========================================================= c . 17620 |==================================================================== PostgreSQL 17 Scaling Factor: 1 - Clients: 250 - Mode: Read Only - Average Latency ms < Lower Is Better a . 0.100 |==================================================================== b . 0.100 |==================================================================== c . 0.100 |==================================================================== PostgreSQL 17 Scaling Factor: 1 - Clients: 500 - Mode: Read Only - Average Latency ms < Lower Is Better a . 0.206 |==================================================================== b . 0.207 |==================================================================== c . 0.207 |==================================================================== PostgreSQL 17 Scaling Factor: 1 - Clients: 800 - Mode: Read Only - Average Latency ms < Lower Is Better a . 0.372 |=================================================================== b . 0.377 |==================================================================== c . 0.376 |==================================================================== PostgreSQL 17 Scaling Factor: 1 - Clients: 1000 - Mode: Read Only - Average Latency ms < Lower Is Better a . 0.558 |==================================================================== b . 0.559 |==================================================================== c . 0.549 |=================================================================== PostgreSQL 17 Scaling Factor: 1 - Clients: 250 - Mode: Read Write - Average Latency ms < Lower Is Better a . 69.18 |==================================================================== b . 69.42 |==================================================================== c . 69.44 |==================================================================== PostgreSQL 17 Scaling Factor: 1 - Clients: 500 - Mode: Read Write - Average Latency ms < Lower Is Better a . 189.37 |================================================================== b . 190.82 |=================================================================== c . 179.73 |=============================================================== PostgreSQL 17 Scaling Factor: 1 - Clients: 800 - Mode: Read Write - Average Latency ms < Lower Is Better a . 476.59 |============================================================ b . 523.03 |================================================================== c . 531.87 |=================================================================== PostgreSQL 17 Scaling Factor: 1 - Clients: 1000 - Mode: Read Write - Average Latency ms < Lower Is Better a . 775.62 |================================================================= b . 739.73 |============================================================== c . 802.51 |=================================================================== PostgreSQL 17 Scaling Factor: 100 - Clients: 250 - Mode: Read Only - Average Latency ms < Lower Is Better a . 0.114 |==================================================================== b . 0.114 |==================================================================== c . 0.114 |==================================================================== PostgreSQL 17 Scaling Factor: 100 - Clients: 500 - Mode: Read Only - Average Latency ms < Lower Is Better a . 0.236 |=================================================================== b . 0.237 |==================================================================== c . 0.238 |==================================================================== PostgreSQL 17 Scaling Factor: 100 - Clients: 800 - Mode: Read Only - Average Latency ms < Lower Is Better a . 0.433 |==================================================================== b . 0.431 |==================================================================== c . 0.430 |==================================================================== PostgreSQL 17 Scaling Factor: 100 - Clients: 1000 - Mode: Read Only - Average Latency ms < Lower Is Better a . 0.650 |================================================================== b . 0.657 |=================================================================== c . 0.666 |==================================================================== PostgreSQL 17 Scaling Factor: 100 - Clients: 250 - Mode: Read Write - Average Latency ms < Lower Is Better a . 5.095 |===================================================== b . 5.445 |========================================================= c . 6.522 |==================================================================== PostgreSQL 17 Scaling Factor: 100 - Clients: 500 - Mode: Read Write - Average Latency ms < Lower Is Better a . 10.70 |========================================================== b . 11.11 |============================================================ c . 12.58 |==================================================================== PostgreSQL 17 Scaling Factor: 100 - Clients: 800 - Mode: Read Write - Average Latency ms < Lower Is Better a . 18.22 |============================================================ b . 18.40 |============================================================= c . 20.67 |==================================================================== PostgreSQL 17 Scaling Factor: 1000 - Clients: 250 - Mode: Read Only - Average Latency ms < Lower Is Better a . 0.171 |==================================================================== b . 0.170 |==================================================================== c . 0.170 |==================================================================== PostgreSQL 17 Scaling Factor: 1000 - Clients: 500 - Mode: Read Only - Average Latency ms < Lower Is Better a . 0.370 |=================================================================== b . 0.374 |==================================================================== c . 0.370 |=================================================================== PostgreSQL 17 Scaling Factor: 1000 - Clients: 800 - Mode: Read Only - Average Latency ms < Lower Is Better a . 0.704 |=================================================================== b . 0.715 |==================================================================== c . 0.716 |==================================================================== PostgreSQL 17 Scaling Factor: 100 - Clients: 1000 - Mode: Read Write - Average Latency ms < Lower Is Better a . 24.98 |=========================================================== b . 26.75 |=============================================================== c . 28.97 |==================================================================== PostgreSQL 17 Scaling Factor: 1000 - Clients: 1000 - Mode: Read Only - Average Latency ms < Lower Is Better a . 1.021 |==================================================================== b . 1.012 |=================================================================== c . 1.014 |==================================================================== PostgreSQL 17 Scaling Factor: 1000 - Clients: 250 - Mode: Read Write - Average Latency ms < Lower Is Better a . 10.55 |================================================ b . 13.57 |============================================================== c . 14.95 |==================================================================== PostgreSQL 17 Scaling Factor: 1000 - Clients: 500 - Mode: Read Write - Average Latency ms < Lower Is Better a . 30.73 |=========================================================== b . 35.25 |==================================================================== c . 31.05 |============================================================ PostgreSQL 17 Scaling Factor: 1000 - Clients: 800 - Mode: Read Write - Average Latency ms < Lower Is Better a . 49.01 |=============================================================== b . 52.93 |==================================================================== c . 50.65 |================================================================= PostgreSQL 17 Scaling Factor: 1000 - Clients: 1000 - Mode: Read Write - Average Latency ms < Lower Is Better a . 59.10 |=========================================================== b . 68.41 |==================================================================== c . 56.76 |========================================================