pgbench core i9 13900k Intel Core i9-13900K testing with a ASUS PRIME Z790-P WIFI (0602 BIOS) and AMD Radeon RX 6700 XT 12GB on Ubuntu 22.10 via the Phoronix Test Suite. a: Processor: Intel Core i9-13900K @ 5.50GHz (24 Cores / 32 Threads), Motherboard: ASUS PRIME Z790-P WIFI (0602 BIOS), Chipset: Intel Device 7a27, Memory: 32GB, Disk: 2048GB SOLIDIGM SSDPFKKW020X7, Graphics: AMD Radeon RX 6700 XT 12GB (2855/1000MHz), Audio: Realtek ALC897, Monitor: ASUS VP28U, Network: Intel Device 7a70 OS: Ubuntu 22.10, Kernel: 6.2.0-rc2-phx (x86_64), Desktop: GNOME Shell 43.1, Display Server: X Server 1.21.1.4 + Wayland, OpenGL: 4.6 Mesa 23.0.0-devel (git-fc0e23b 2023-01-02 kinetic-oibaf-ppa) (LLVM 15.0.5 DRM 3.49), Vulkan: 1.3.238, Compiler: GCC 12.2.0, File-System: ext4, Screen Resolution: 3840x2160 b: Processor: Intel Core i9-13900K @ 5.50GHz (24 Cores / 32 Threads), Motherboard: ASUS PRIME Z790-P WIFI (0602 BIOS), Chipset: Intel Device 7a27, Memory: 32GB, Disk: 2048GB SOLIDIGM SSDPFKKW020X7, Graphics: AMD Radeon RX 6700 XT 12GB (2855/1000MHz), Audio: Realtek ALC897, Monitor: ASUS VP28U, Network: Intel Device 7a70 OS: Ubuntu 22.10, Kernel: 6.2.0-rc2-phx (x86_64), Desktop: GNOME Shell 43.1, Display Server: X Server 1.21.1.4 + Wayland, OpenGL: 4.6 Mesa 23.0.0-devel (git-fc0e23b 2023-01-02 kinetic-oibaf-ppa) (LLVM 15.0.5 DRM 3.49), Vulkan: 1.3.238, Compiler: GCC 12.2.0, File-System: ext4, Screen Resolution: 3840x2160 c: Processor: Intel Core i9-13900K @ 5.50GHz (24 Cores / 32 Threads), Motherboard: ASUS PRIME Z790-P WIFI (0602 BIOS), Chipset: Intel Device 7a27, Memory: 32GB, Disk: 2048GB SOLIDIGM SSDPFKKW020X7, Graphics: AMD Radeon RX 6700 XT 12GB (2855/1000MHz), Audio: Realtek ALC897, Monitor: ASUS VP28U, Network: Intel Device 7a70 OS: Ubuntu 22.10, Kernel: 6.2.0-rc2-phx (x86_64), Desktop: GNOME Shell 43.1, Display Server: X Server 1.21.1.4 + Wayland, OpenGL: 4.6 Mesa 23.0.0-devel (git-fc0e23b 2023-01-02 kinetic-oibaf-ppa) (LLVM 15.0.5 DRM 3.49), Vulkan: 1.3.238, Compiler: GCC 12.2.0, File-System: ext4, Screen Resolution: 3840x2160 d: Processor: Intel Core i9-13900K @ 5.50GHz (24 Cores / 32 Threads), Motherboard: ASUS PRIME Z790-P WIFI (0602 BIOS), Chipset: Intel Device 7a27, Memory: 32GB, Disk: 2048GB SOLIDIGM SSDPFKKW020X7, Graphics: AMD Radeon RX 6700 XT 12GB (2855/1000MHz), Audio: Realtek ALC897, Monitor: ASUS VP28U, Network: Intel Device 7a70 OS: Ubuntu 22.10, Kernel: 6.2.0-rc2-phx (x86_64), Desktop: GNOME Shell 43.1, Display Server: X Server 1.21.1.4 + Wayland, OpenGL: 4.6 Mesa 23.0.0-devel (git-fc0e23b 2023-01-02 kinetic-oibaf-ppa) (LLVM 15.0.5 DRM 3.49), Vulkan: 1.3.238, Compiler: GCC 12.2.0, File-System: ext4, Screen Resolution: 3840x2160 PostgreSQL 15 Scaling Factor: 1 - Clients: 1000 - Mode: Read Write - Average Latency ms < Lower Is Better a . 1427.81 |================================================ b . 1976.96 |================================================================== c . 1351.15 |============================================= d . 1604.05 |====================================================== PostgreSQL 15 Scaling Factor: 1 - Clients: 1000 - Mode: Read Write TPS > Higher Is Better a . 700 |================================================================== b . 506 |================================================ c . 740 |====================================================================== d . 623 |=========================================================== PostgreSQL 15 Scaling Factor: 1 - Clients: 800 - Mode: Read Write TPS > Higher Is Better a . 797 |==================================================== b . 839 |======================================================= c . 824 |====================================================== d . 1053 |===================================================================== PostgreSQL 15 Scaling Factor: 1 - Clients: 800 - Mode: Read Write - Average Latency ms < Lower Is Better a . 1003.48 |================================================================== b . 953.60 |=============================================================== c . 970.80 |================================================================ d . 760.04 |================================================== PostgreSQL 15 Scaling Factor: 1 - Clients: 500 - Mode: Read Write - Average Latency ms < Lower Is Better a . 344.92 |============================================================ b . 379.47 |================================================================== c . 327.06 |========================================================= d . 385.60 |=================================================================== PostgreSQL 15 Scaling Factor: 1 - Clients: 500 - Mode: Read Write TPS > Higher Is Better a . 1450 |================================================================= b . 1318 |=========================================================== c . 1529 |===================================================================== d . 1297 |=========================================================== PostgreSQL 15 Scaling Factor: 1 - Clients: 250 - Mode: Read Write - Average Latency ms < Lower Is Better a . 118.11 |================================================================ b . 110.78 |============================================================ c . 119.32 |================================================================= d . 123.18 |=================================================================== PostgreSQL 15 Scaling Factor: 1 - Clients: 250 - Mode: Read Write TPS > Higher Is Better a . 2117 |================================================================= b . 2257 |===================================================================== c . 2095 |================================================================ d . 2030 |============================================================== PostgreSQL 15 Scaling Factor: 100 - Clients: 500 - Mode: Read Only TPS > Higher Is Better a . 1931581 |================================================================== b . 1927354 |================================================================== c . 1818309 |============================================================== d . 1927894 |================================================================== PostgreSQL 15 Scaling Factor: 100 - Clients: 500 - Mode: Read Only - Average Latency ms < Lower Is Better a . 0.259 |================================================================ b . 0.259 |================================================================ c . 0.275 |==================================================================== d . 0.259 |================================================================ PostgreSQL 15 Scaling Factor: 100 - Clients: 100 - Mode: Read Only TPS > Higher Is Better a . 1996219 |=============================================================== b . 2080553 |================================================================== c . 2073224 |================================================================== d . 2049509 |================================================================= PostgreSQL 15 Scaling Factor: 100 - Clients: 100 - Mode: Read Only - Average Latency ms < Lower Is Better a . 0.050 |==================================================================== b . 0.048 |================================================================= c . 0.048 |================================================================= d . 0.049 |=================================================================== PostgreSQL 15 Scaling Factor: 1 - Clients: 500 - Mode: Read Only TPS > Higher Is Better a . 2158688 |================================================================= b . 2195595 |================================================================== c . 2108541 |=============================================================== d . 2161023 |================================================================= PostgreSQL 15 Scaling Factor: 1 - Clients: 500 - Mode: Read Only - Average Latency ms < Lower Is Better a . 0.232 |=================================================================== b . 0.228 |================================================================= c . 0.237 |==================================================================== d . 0.231 |================================================================== PostgreSQL 15 Scaling Factor: 1000 - Clients: 50 - Mode: Read Only TPS > Higher Is Better a . 1603100 |================================================================= c . 1572165 |================================================================ d . 1623340 |================================================================== PostgreSQL 15 Scaling Factor: 1000 - Clients: 50 - Mode: Read Only - Average Latency ms < Lower Is Better a . 0.031 |================================================================== c . 0.032 |==================================================================== d . 0.031 |================================================================== PostgreSQL 15 Scaling Factor: 1 - Clients: 100 - Mode: Read Write - Average Latency ms < Lower Is Better a . 31.13 |================================================================== b . 32.00 |==================================================================== c . 32.10 |==================================================================== d . 31.81 |=================================================================== PostgreSQL 15 Scaling Factor: 1 - Clients: 100 - Mode: Read Write TPS > Higher Is Better a . 3212 |===================================================================== b . 3125 |=================================================================== c . 3115 |=================================================================== d . 3143 |==================================================================== PostgreSQL 15 Scaling Factor: 100 - Clients: 1000 - Mode: Read Only - Average Latency ms < Lower Is Better a . 0.524 |================================================================== c . 0.536 |==================================================================== d . 0.539 |==================================================================== PostgreSQL 15 Scaling Factor: 100 - Clients: 1000 - Mode: Read Only TPS > Higher Is Better a . 1907480 |================================================================== c . 1865867 |================================================================= d . 1854709 |================================================================ PostgreSQL 15 Scaling Factor: 1 - Clients: 800 - Mode: Read Only TPS > Higher Is Better a . 2114333 |================================================================ b . 2168623 |================================================================== c . 2133485 |================================================================= d . 2111396 |================================================================ PostgreSQL 15 Scaling Factor: 1 - Clients: 800 - Mode: Read Only - Average Latency ms < Lower Is Better a . 0.378 |==================================================================== b . 0.369 |================================================================== c . 0.375 |=================================================================== d . 0.379 |==================================================================== PostgreSQL 15 Scaling Factor: 1 - Clients: 1000 - Mode: Read Only - Average Latency ms < Lower Is Better a . 0.476 |==================================================================== b . 0.477 |==================================================================== c . 0.467 |=================================================================== d . 0.465 |================================================================== PostgreSQL 15 Scaling Factor: 1000 - Clients: 500 - Mode: Read Only - Average Latency ms < Lower Is Better a . 0.484 |==================================================================== c . 0.472 |================================================================== PostgreSQL 15 Scaling Factor: 1000 - Clients: 500 - Mode: Read Only TPS > Higher Is Better a . 1032434 |================================================================ c . 1058413 |================================================================== PostgreSQL 15 Scaling Factor: 1 - Clients: 1000 - Mode: Read Only TPS > Higher Is Better a . 2102931 |================================================================= b . 2096348 |================================================================ c . 2143602 |================================================================== d . 2148266 |================================================================== PostgreSQL 15 Scaling Factor: 100 - Clients: 250 - Mode: Read Only - Average Latency ms < Lower Is Better a . 0.126 |================================================================== b . 0.129 |==================================================================== c . 0.126 |================================================================== d . 0.128 |=================================================================== PostgreSQL 15 Scaling Factor: 1 - Clients: 100 - Mode: Read Only - Average Latency ms < Lower Is Better a . 0.045 |==================================================================== b . 0.045 |==================================================================== c . 0.044 |================================================================== d . 0.044 |================================================================== PostgreSQL 15 Scaling Factor: 1000 - Clients: 1 - Mode: Read Only TPS > Higher Is Better a . 103620 |=================================================================== b . 102740 |================================================================== c . 101600 |================================================================== d . 103329 |=================================================================== PostgreSQL 15 Scaling Factor: 1 - Clients: 100 - Mode: Read Only TPS > Higher Is Better a . 2239864 |================================================================= b . 2218178 |================================================================= c . 2261565 |================================================================== d . 2261978 |================================================================== PostgreSQL 15 Scaling Factor: 100 - Clients: 250 - Mode: Read Only TPS > Higher Is Better a . 1983038 |================================================================== b . 1945393 |================================================================= c . 1983576 |================================================================== d . 1945860 |================================================================= PostgreSQL 15 Scaling Factor: 100 - Clients: 1 - Mode: Read Only TPS > Higher Is Better a . 121555 |================================================================== b . 120803 |================================================================== c . 121107 |================================================================== d . 122961 |=================================================================== PostgreSQL 15 Scaling Factor: 1 - Clients: 50 - Mode: Read Only TPS > Higher Is Better a . 2268112 |================================================================== b . 2231465 |================================================================= c . 2258205 |================================================================== d . 2268958 |================================================================== PostgreSQL 15 Scaling Factor: 1 - Clients: 50 - Mode: Read Write TPS > Higher Is Better a . 3580 |===================================================================== b . 3521 |==================================================================== c . 3523 |==================================================================== d . 3522 |==================================================================== PostgreSQL 15 Scaling Factor: 1 - Clients: 50 - Mode: Read Write - Average Latency ms < Lower Is Better a . 13.97 |=================================================================== b . 14.20 |==================================================================== c . 14.19 |==================================================================== d . 14.20 |==================================================================== PostgreSQL 15 Scaling Factor: 100 - Clients: 800 - Mode: Read Only - Average Latency ms < Lower Is Better a . 0.429 |==================================================================== b . 0.427 |==================================================================== c . 0.426 |==================================================================== d . 0.423 |=================================================================== PostgreSQL 15 Scaling Factor: 100 - Clients: 800 - Mode: Read Only TPS > Higher Is Better a . 1865550 |================================================================= b . 1873104 |================================================================= c . 1879765 |================================================================== d . 1891833 |================================================================== PostgreSQL 15 Scaling Factor: 1000 - Clients: 100 - Mode: Read Only - Average Latency ms < Lower Is Better a . 0.078 |=================================================================== c . 0.079 |==================================================================== PostgreSQL 15 Scaling Factor: 1 - Clients: 1 - Mode: Read Only TPS > Higher Is Better a . 140159 |================================================================== b . 141888 |=================================================================== c . 140967 |=================================================================== d . 141927 |=================================================================== PostgreSQL 15 Scaling Factor: 1 - Clients: 1 - Mode: Read Write - Average Latency ms < Lower Is Better a . 0.287 |==================================================================== b . 0.284 |=================================================================== c . 0.285 |==================================================================== d . 0.284 |=================================================================== PostgreSQL 15 Scaling Factor: 100 - Clients: 1 - Mode: Read Write - Average Latency ms < Lower Is Better a . 0.288 |=================================================================== b . 0.290 |==================================================================== c . 0.290 |==================================================================== d . 0.291 |==================================================================== PostgreSQL 15 Scaling Factor: 1 - Clients: 1 - Mode: Read Write TPS > Higher Is Better a . 3489 |==================================================================== b . 3525 |===================================================================== c . 3514 |===================================================================== d . 3525 |===================================================================== PostgreSQL 15 Scaling Factor: 100 - Clients: 100 - Mode: Read Write TPS > Higher Is Better a . 71487 |==================================================================== c . 71080 |==================================================================== d . 70807 |=================================================================== PostgreSQL 15 Scaling Factor: 1 - Clients: 250 - Mode: Read Only TPS > Higher Is Better a . 2138091 |================================================================= b . 2158017 |================================================================== c . 2156346 |================================================================== d . 2137565 |================================================================= PostgreSQL 15 Scaling Factor: 100 - Clients: 1 - Mode: Read Write TPS > Higher Is Better a . 3472 |===================================================================== b . 3449 |===================================================================== c . 3446 |==================================================================== d . 3440 |==================================================================== PostgreSQL 15 Scaling Factor: 100 - Clients: 100 - Mode: Read Write - Average Latency ms < Lower Is Better a . 1.399 |=================================================================== c . 1.407 |==================================================================== d . 1.412 |==================================================================== PostgreSQL 15 Scaling Factor: 100 - Clients: 500 - Mode: Read Write TPS > Higher Is Better a . 72616 |==================================================================== c . 71988 |=================================================================== PostgreSQL 15 Scaling Factor: 100 - Clients: 500 - Mode: Read Write - Average Latency ms < Lower Is Better a . 6.886 |=================================================================== c . 6.946 |==================================================================== PostgreSQL 15 Scaling Factor: 1 - Clients: 250 - Mode: Read Only - Average Latency ms < Lower Is Better a . 0.117 |==================================================================== b . 0.116 |=================================================================== c . 0.116 |=================================================================== d . 0.117 |==================================================================== PostgreSQL 15 Scaling Factor: 100 - Clients: 50 - Mode: Read Only TPS > Higher Is Better a . 2079232 |================================================================== b . 2094557 |================================================================== c . 2084669 |================================================================== d . 2078639 |================================================================= PostgreSQL 15 Scaling Factor: 1000 - Clients: 1 - Mode: Read Write - Average Latency ms < Lower Is Better a . 0.293 |==================================================================== b . 0.295 |==================================================================== c . 0.294 |==================================================================== d . 0.295 |==================================================================== PostgreSQL 15 Scaling Factor: 100 - Clients: 250 - Mode: Read Write TPS > Higher Is Better a . 82732 |==================================================================== c . 82202 |==================================================================== d . 82601 |==================================================================== PostgreSQL 15 Scaling Factor: 100 - Clients: 250 - Mode: Read Write - Average Latency ms < Lower Is Better a . 3.022 |==================================================================== c . 3.041 |==================================================================== d . 3.027 |==================================================================== PostgreSQL 15 Scaling Factor: 100 - Clients: 50 - Mode: Read Write - Average Latency ms < Lower Is Better a . 0.909 |==================================================================== b . 0.914 |==================================================================== c . 0.913 |==================================================================== d . 0.912 |==================================================================== PostgreSQL 15 Scaling Factor: 1000 - Clients: 250 - Mode: Read Only - Average Latency ms < Lower Is Better a . 0.198 |==================================================================== c . 0.199 |==================================================================== PostgreSQL 15 Scaling Factor: 100 - Clients: 50 - Mode: Read Write TPS > Higher Is Better a . 54978 |==================================================================== b . 54713 |==================================================================== c . 54773 |==================================================================== d . 54818 |==================================================================== PostgreSQL 15 Scaling Factor: 1000 - Clients: 1 - Mode: Read Write TPS > Higher Is Better a . 3407 |===================================================================== b . 3391 |===================================================================== c . 3404 |===================================================================== d . 3394 |===================================================================== PostgreSQL 15 Scaling Factor: 1000 - Clients: 100 - Mode: Read Only TPS > Higher Is Better a . 1273982 |================================================================== c . 1269695 |================================================================== PostgreSQL 15 Scaling Factor: 1000 - Clients: 250 - Mode: Read Only TPS > Higher Is Better a . 1260983 |================================================================== c . 1258863 |================================================================== PostgreSQL 15 Scaling Factor: 100 - Clients: 800 - Mode: Read Write - Average Latency ms < Lower Is Better a . 13.81 |==================================================================== c . 13.79 |==================================================================== PostgreSQL 15 Scaling Factor: 100 - Clients: 800 - Mode: Read Write TPS > Higher Is Better a . 57925 |==================================================================== c . 58021 |==================================================================== PostgreSQL 15 Scaling Factor: 1000 - Clients: 50 - Mode: Read Write - Average Latency ms < Lower Is Better a . 0.859 |==================================================================== c . 0.858 |==================================================================== PostgreSQL 15 Scaling Factor: 1000 - Clients: 50 - Mode: Read Write TPS > Higher Is Better a . 58189 |==================================================================== c . 58251 |==================================================================== PostgreSQL 15 Scaling Factor: 1000 - Clients: 1 - Mode: Read Only - Average Latency ms < Lower Is Better a . 0.01 |===================================================================== b . 0.01 |===================================================================== c . 0.01 |===================================================================== d . 0.01 |===================================================================== PostgreSQL 15 Scaling Factor: 100 - Clients: 50 - Mode: Read Only - Average Latency ms < Lower Is Better a . 0.024 |==================================================================== b . 0.024 |==================================================================== c . 0.024 |==================================================================== d . 0.024 |==================================================================== PostgreSQL 15 Scaling Factor: 100 - Clients: 1 - Mode: Read Only - Average Latency ms < Lower Is Better a . 0.008 |==================================================================== b . 0.008 |==================================================================== c . 0.008 |==================================================================== d . 0.008 |==================================================================== PostgreSQL 15 Scaling Factor: 1 - Clients: 50 - Mode: Read Only - Average Latency ms < Lower Is Better a . 0.022 |==================================================================== b . 0.022 |==================================================================== c . 0.022 |==================================================================== d . 0.022 |==================================================================== PostgreSQL 15 Scaling Factor: 1 - Clients: 1 - Mode: Read Only - Average Latency ms < Lower Is Better a . 0.007 |==================================================================== b . 0.007 |==================================================================== c . 0.007 |==================================================================== d . 0.007 |====================================================================