pgbench 11900K Intel Core i9-11900K testing with a ASUS ROG MAXIMUS XIII HERO (0707 BIOS) and AMD Radeon VII 16GB on Ubuntu 21.10 via the Phoronix Test Suite. 1: Processor: Intel Core i9-11900K @ 5.10GHz (8 Cores / 16 Threads), Motherboard: ASUS ROG MAXIMUS XIII HERO (0707 BIOS), Chipset: Intel Tiger Lake-H, Memory: 32GB, Disk: 2000GB Corsair Force MP600, Graphics: AMD Radeon VII 16GB (1801/1000MHz), Audio: Intel Tiger Lake-H HD Audio, Monitor: ASUS MG28U, Network: 2 x Intel I225-V + Intel Wi-Fi 6 AX210/AX211/AX411 OS: Ubuntu 21.10, Kernel: 5.15.0-rc2-flush-in-the-ref (x86_64) 20210921, Desktop: GNOME Shell 40.2, Display Server: X Server + Wayland, OpenGL: 4.6 Mesa 21.2.1 (LLVM 12.0.1), Vulkan: 1.2.182, Compiler: GCC 11.2.0, File-System: ext4, Screen Resolution: 3840x2160 2: Processor: Intel Core i9-11900K @ 5.10GHz (8 Cores / 16 Threads), Motherboard: ASUS ROG MAXIMUS XIII HERO (0707 BIOS), Chipset: Intel Tiger Lake-H, Memory: 32GB, Disk: 2000GB Corsair Force MP600, Graphics: AMD Radeon VII 16GB (1801/1000MHz), Audio: Intel Tiger Lake-H HD Audio, Monitor: ASUS MG28U, Network: 2 x Intel I225-V + Intel Wi-Fi 6 AX210/AX211/AX411 OS: Ubuntu 21.10, Kernel: 5.15.0-rc2-flush-in-the-ref (x86_64) 20210921, Desktop: GNOME Shell 40.2, Display Server: X Server + Wayland, OpenGL: 4.6 Mesa 21.2.1 (LLVM 12.0.1), Vulkan: 1.2.182, Compiler: GCC 11.2.0, File-System: ext4, Screen Resolution: 3840x2160 3: Processor: Intel Core i9-11900K @ 5.10GHz (8 Cores / 16 Threads), Motherboard: ASUS ROG MAXIMUS XIII HERO (0707 BIOS), Chipset: Intel Tiger Lake-H, Memory: 32GB, Disk: 2000GB Corsair Force MP600, Graphics: AMD Radeon VII 16GB (1801/1000MHz), Audio: Intel Tiger Lake-H HD Audio, Monitor: ASUS MG28U, Network: 2 x Intel I225-V + Intel Wi-Fi 6 AX210/AX211/AX411 OS: Ubuntu 21.10, Kernel: 5.15.0-rc2-flush-in-the-ref (x86_64) 20210921, Desktop: GNOME Shell 40.2, Display Server: X Server + Wayland, OpenGL: 4.6 Mesa 21.2.1 (LLVM 12.0.1), Vulkan: 1.2.182, Compiler: GCC 11.2.0, File-System: ext4, Screen Resolution: 3840x2160 PostgreSQL pgbench 14.0 Scaling Factor: 1 - Clients: 1 - Mode: Read Only TPS > Higher Is Better 1 . 46233 |==================================================================== 2 . 44845 |================================================================== 3 . 44833 |================================================================== PostgreSQL pgbench 14.0 Scaling Factor: 1 - Clients: 1 - Mode: Read Only - Average Latency ms < Lower Is Better 1 . 0.022 |==================================================================== 2 . 0.022 |==================================================================== 3 . 0.022 |==================================================================== PostgreSQL pgbench 14.0 Scaling Factor: 1 - Clients: 1 - Mode: Read Write TPS > Higher Is Better 1 . 1575 |===================================================================== 2 . 965 |========================================== 3 . 949 |========================================== PostgreSQL pgbench 14.0 Scaling Factor: 1 - Clients: 1 - Mode: Read Write - Average Latency ms < Lower Is Better 1 . 0.635 |========================================= 2 . 1.036 |=================================================================== 3 . 1.054 |==================================================================== PostgreSQL pgbench 14.0 Scaling Factor: 1 - Clients: 50 - Mode: Read Only TPS > Higher Is Better 1 . 360185 |================================================================== 2 . 364670 |=================================================================== 3 . 358534 |================================================================== PostgreSQL pgbench 14.0 Scaling Factor: 1 - Clients: 50 - Mode: Read Only - Average Latency ms < Lower Is Better 1 . 0.139 |==================================================================== 2 . 0.137 |=================================================================== 3 . 0.139 |==================================================================== PostgreSQL pgbench 14.0 Scaling Factor: 1 - Clients: 100 - Mode: Read Only TPS > Higher Is Better 1 . 336048 |================================================================== 2 . 338665 |=================================================================== 3 . 336839 |=================================================================== PostgreSQL pgbench 14.0 Scaling Factor: 1 - Clients: 100 - Mode: Read Only - Average Latency ms < Lower Is Better 1 . 0.298 |==================================================================== 2 . 0.295 |=================================================================== 3 . 0.297 |==================================================================== PostgreSQL pgbench 14.0 Scaling Factor: 1 - Clients: 250 - Mode: Read Only TPS > Higher Is Better 1 . 272037 |=================================================================== 2 . 268575 |================================================================== 3 . 271358 |=================================================================== PostgreSQL pgbench 14.0 Scaling Factor: 1 - Clients: 250 - Mode: Read Only - Average Latency ms < Lower Is Better 1 . 0.919 |=================================================================== 2 . 0.931 |==================================================================== 3 . 0.921 |=================================================================== PostgreSQL pgbench 14.0 Scaling Factor: 1 - Clients: 50 - Mode: Read Write TPS > Higher Is Better 1 . 1557 |===================================================================== 2 . 1054 |=============================================== 3 . 1052 |=============================================== PostgreSQL pgbench 14.0 Scaling Factor: 1 - Clients: 50 - Mode: Read Write - Average Latency ms < Lower Is Better 1 . 32.10 |============================================== 2 . 47.45 |==================================================================== 3 . 47.54 |==================================================================== PostgreSQL pgbench 14.0 Scaling Factor: 1 - Clients: 500 - Mode: Read Only TPS > Higher Is Better 1 . 238283 |================================================================== 2 . 242563 |=================================================================== 3 . 242800 |=================================================================== PostgreSQL pgbench 14.0 Scaling Factor: 1 - Clients: 500 - Mode: Read Only - Average Latency ms < Lower Is Better 1 . 2.098 |==================================================================== 2 . 2.061 |=================================================================== 3 . 2.059 |=================================================================== PostgreSQL pgbench 14.0 Scaling Factor: 100 - Clients: 1 - Mode: Read Only TPS > Higher Is Better 1 . 42816 |==================================================================== 2 . 42369 |=================================================================== 3 . 42197 |=================================================================== PostgreSQL pgbench 14.0 Scaling Factor: 100 - Clients: 1 - Mode: Read Only - Average Latency ms < Lower Is Better 1 . 0.023 |================================================================= 2 . 0.024 |==================================================================== 3 . 0.024 |==================================================================== PostgreSQL pgbench 14.0 Scaling Factor: 1 - Clients: 100 - Mode: Read Write TPS > Higher Is Better 1 . 1766 |===================================================================== 2 . 1190 |============================================== 3 . 1012 |======================================== PostgreSQL pgbench 14.0 Scaling Factor: 1 - Clients: 100 - Mode: Read Write - Average Latency ms < Lower Is Better 1 . 56.61 |======================================= 2 . 84.04 |========================================================== 3 . 98.82 |==================================================================== PostgreSQL pgbench 14.0 Scaling Factor: 1 - Clients: 250 - Mode: Read Write TPS > Higher Is Better 1 . 1236 |===================================================================== 2 . 1013 |========================================================= 3 . 910 |=================================================== PostgreSQL pgbench 14.0 Scaling Factor: 1 - Clients: 250 - Mode: Read Write - Average Latency ms < Lower Is Better 1 . 202.30 |================================================= 2 . 246.79 |============================================================ 3 . 274.76 |=================================================================== PostgreSQL pgbench 14.0 Scaling Factor: 1 - Clients: 500 - Mode: Read Write TPS > Higher Is Better 1 . 986 |====================================================================== 2 . 978 |===================================================================== 3 . 898 |================================================================ PostgreSQL pgbench 14.0 Scaling Factor: 1 - Clients: 500 - Mode: Read Write - Average Latency ms < Lower Is Better 1 . 506.89 |============================================================= 2 . 511.05 |============================================================= 3 . 556.83 |=================================================================== PostgreSQL pgbench 14.0 Scaling Factor: 100 - Clients: 1 - Mode: Read Write TPS > Higher Is Better 1 . 228 |============================= 2 . 524 |================================================================== 3 . 555 |====================================================================== PostgreSQL pgbench 14.0 Scaling Factor: 100 - Clients: 1 - Mode: Read Write - Average Latency ms < Lower Is Better 1 . 4.381 |==================================================================== 2 . 1.910 |============================== 3 . 1.803 |============================ PostgreSQL pgbench 14.0 Scaling Factor: 100 - Clients: 50 - Mode: Read Only TPS > Higher Is Better 1 . 338552 |================================================================== 2 . 346043 |=================================================================== 3 . 339878 |================================================================== PostgreSQL pgbench 14.0 Scaling Factor: 100 - Clients: 50 - Mode: Read Only - Average Latency ms < Lower Is Better 1 . 0.148 |==================================================================== 2 . 0.144 |================================================================== 3 . 0.147 |==================================================================== PostgreSQL pgbench 14.0 Scaling Factor: 1000 - Clients: 1 - Mode: Read Only TPS > Higher Is Better 1 . 37385 |==================================================================== 2 . 37180 |==================================================================== 3 . 36920 |=================================================================== PostgreSQL pgbench 14.0 Scaling Factor: 1000 - Clients: 1 - Mode: Read Only - Average Latency ms < Lower Is Better 1 . 0.027 |==================================================================== 2 . 0.027 |==================================================================== 3 . 0.027 |==================================================================== PostgreSQL pgbench 14.0 Scaling Factor: 100 - Clients: 100 - Mode: Read Only TPS > Higher Is Better 1 . 321666 |================================================================= 2 . 327005 |================================================================== 3 . 329769 |=================================================================== PostgreSQL pgbench 14.0 Scaling Factor: 100 - Clients: 100 - Mode: Read Only - Average Latency ms < Lower Is Better 1 . 0.311 |==================================================================== 2 . 0.306 |=================================================================== 3 . 0.303 |================================================================== PostgreSQL pgbench 14.0 Scaling Factor: 100 - Clients: 250 - Mode: Read Only TPS > Higher Is Better 1 . 255129 |================================================================ 2 . 258929 |================================================================= 3 . 265125 |=================================================================== PostgreSQL pgbench 14.0 Scaling Factor: 100 - Clients: 250 - Mode: Read Only - Average Latency ms < Lower Is Better 1 . 0.980 |==================================================================== 2 . 0.966 |=================================================================== 3 . 0.943 |================================================================= PostgreSQL pgbench 14.0 Scaling Factor: 100 - Clients: 50 - Mode: Read Write TPS > Higher Is Better 1 . 22299 |==================================================================== 2 . 5896 |================== 3 . 7003 |===================== PostgreSQL pgbench 14.0 Scaling Factor: 100 - Clients: 50 - Mode: Read Write - Average Latency ms < Lower Is Better 1 . 2.242 |================== 2 . 8.481 |==================================================================== 3 . 7.139 |========================================================= PostgreSQL pgbench 14.0 Scaling Factor: 100 - Clients: 500 - Mode: Read Only TPS > Higher Is Better 1 . 223050 |=================================================================== 2 . 219639 |================================================================== 3 . 223683 |=================================================================== PostgreSQL pgbench 14.0 Scaling Factor: 100 - Clients: 500 - Mode: Read Only - Average Latency ms < Lower Is Better 1 . 2.242 |=================================================================== 2 . 2.276 |==================================================================== 3 . 2.235 |=================================================================== PostgreSQL pgbench 14.0 Scaling Factor: 1000 - Clients: 1 - Mode: Read Write TPS > Higher Is Better 1 . 219 |====================================================================== 2 . 216 |===================================================================== 3 . 215 |===================================================================== PostgreSQL pgbench 14.0 Scaling Factor: 1000 - Clients: 1 - Mode: Read Write - Average Latency ms < Lower Is Better 1 . 4.575 |=================================================================== 2 . 4.632 |==================================================================== 3 . 4.658 |==================================================================== PostgreSQL pgbench 14.0 Scaling Factor: 1000 - Clients: 50 - Mode: Read Only TPS > Higher Is Better 1 . 300871 |================================================================== 2 . 302413 |================================================================== 3 . 305978 |=================================================================== PostgreSQL pgbench 14.0 Scaling Factor: 1000 - Clients: 50 - Mode: Read Only - Average Latency ms < Lower Is Better 1 . 0.166 |==================================================================== 2 . 0.165 |==================================================================== 3 . 0.163 |=================================================================== PostgreSQL pgbench 14.0 Scaling Factor: 10000 - Clients: 1 - Mode: Read Only TPS > Higher Is Better 1 . 3385 |===================================================================== 2 . 3315 |==================================================================== 3 . 3226 |================================================================== PostgreSQL pgbench 14.0 Scaling Factor: 10000 - Clients: 1 - Mode: Read Only - Average Latency ms < Lower Is Better 1 . 0.295 |================================================================= 2 . 0.302 |================================================================== 3 . 0.310 |==================================================================== PostgreSQL pgbench 14.0 Scaling Factor: 100 - Clients: 100 - Mode: Read Write TPS > Higher Is Better 1 . 10026 |==================================================================== 2 . 9730 |================================================================== 3 . 8798 |============================================================ PostgreSQL pgbench 14.0 Scaling Factor: 100 - Clients: 100 - Mode: Read Write - Average Latency ms < Lower Is Better 1 . 9.974 |=========================================================== 2 . 10.278 |============================================================= 3 . 11.367 |=================================================================== PostgreSQL pgbench 14.0 Scaling Factor: 100 - Clients: 250 - Mode: Read Write TPS > Higher Is Better 1 . 11728 |==================================================================== 2 . 11519 |=================================================================== 3 . 11744 |==================================================================== PostgreSQL pgbench 14.0 Scaling Factor: 100 - Clients: 250 - Mode: Read Write - Average Latency ms < Lower Is Better 1 . 21.32 |=================================================================== 2 . 21.70 |==================================================================== 3 . 21.29 |=================================================================== PostgreSQL pgbench 14.0 Scaling Factor: 100 - Clients: 500 - Mode: Read Write TPS > Higher Is Better 1 . 12351 |==================================================================== 2 . 11124 |============================================================= 3 . 11629 |================================================================ PostgreSQL pgbench 14.0 Scaling Factor: 100 - Clients: 500 - Mode: Read Write - Average Latency ms < Lower Is Better 1 . 40.48 |============================================================= 2 . 44.95 |==================================================================== 3 . 43.00 |================================================================= PostgreSQL pgbench 14.0 Scaling Factor: 1000 - Clients: 100 - Mode: Read Only TPS > Higher Is Better 1 . 295676 |================================================================== 2 . 300111 |=================================================================== 3 . 300589 |=================================================================== PostgreSQL pgbench 14.0 Scaling Factor: 1000 - Clients: 100 - Mode: Read Only - Average Latency ms < Lower Is Better 1 . 0.338 |==================================================================== 2 . 0.333 |=================================================================== 3 . 0.333 |=================================================================== PostgreSQL pgbench 14.0 Scaling Factor: 1000 - Clients: 250 - Mode: Read Only TPS > Higher Is Better 1 . 272368 |============================================================ 2 . 295003 |================================================================= 3 . 302741 |=================================================================== PostgreSQL pgbench 14.0 Scaling Factor: 1000 - Clients: 250 - Mode: Read Only - Average Latency ms < Lower Is Better 1 . 0.918 |==================================================================== 2 . 0.847 |=============================================================== 3 . 0.826 |============================================================= PostgreSQL pgbench 14.0 Scaling Factor: 1000 - Clients: 50 - Mode: Read Write TPS > Higher Is Better 1 . 6697 |================================================================ 2 . 6550 |============================================================== 3 . 7251 |===================================================================== PostgreSQL pgbench 14.0 Scaling Factor: 1000 - Clients: 50 - Mode: Read Write - Average Latency ms < Lower Is Better 1 . 7.466 |=================================================================== 2 . 7.634 |==================================================================== 3 . 6.896 |============================================================= PostgreSQL pgbench 14.0 Scaling Factor: 1000 - Clients: 500 - Mode: Read Only TPS > Higher Is Better 1 . 228248 |=================================================================== 3 . 219698 |================================================================ PostgreSQL pgbench 14.0 Scaling Factor: 1000 - Clients: 500 - Mode: Read Only - Average Latency ms < Lower Is Better 1 . 2.191 |================================================================= 3 . 2.276 |==================================================================== PostgreSQL pgbench 14.0 Scaling Factor: 10000 - Clients: 1 - Mode: Read Write TPS > Higher Is Better 1 . 545 |====================================================================== 3 . 186 |======================== PostgreSQL pgbench 14.0 Scaling Factor: 10000 - Clients: 1 - Mode: Read Write - Average Latency ms < Lower Is Better 1 . 1.835 |======================= 3 . 5.371 |==================================================================== PostgreSQL pgbench 14.0 Scaling Factor: 10000 - Clients: 50 - Mode: Read Only TPS > Higher Is Better 1 . 88400 |==================================================================== 3 . 83836 |================================================================ PostgreSQL pgbench 14.0 Scaling Factor: 10000 - Clients: 50 - Mode: Read Only - Average Latency ms < Lower Is Better 1 . 0.566 |================================================================= 3 . 0.596 |==================================================================== PostgreSQL pgbench 14.0 Scaling Factor: 1000 - Clients: 100 - Mode: Read Write TPS > Higher Is Better 1 . 10166 |==================================================================== 3 . 9573 |================================================================ PostgreSQL pgbench 14.0 Scaling Factor: 1000 - Clients: 100 - Mode: Read Write - Average Latency ms < Lower Is Better 1 . 9.836 |=============================================================== 3 . 10.446 |=================================================================== PostgreSQL pgbench 14.0 Scaling Factor: 1000 - Clients: 250 - Mode: Read Write TPS > Higher Is Better 1 . 12577 |==================================================================== 3 . 11421 |============================================================== PostgreSQL pgbench 14.0 Scaling Factor: 1000 - Clients: 250 - Mode: Read Write - Average Latency ms < Lower Is Better 1 . 19.88 |============================================================== 3 . 21.89 |==================================================================== PostgreSQL pgbench 14.0 Scaling Factor: 1000 - Clients: 500 - Mode: Read Write TPS > Higher Is Better 1 . 10850 |==================================================================== 3 . 9597 |============================================================ PostgreSQL pgbench 14.0 Scaling Factor: 1000 - Clients: 500 - Mode: Read Write - Average Latency ms < Lower Is Better 1 . 46.08 |============================================================ 3 . 52.10 |==================================================================== PostgreSQL pgbench 14.0 Scaling Factor: 10000 - Clients: 100 - Mode: Read Only TPS > Higher Is Better 1 . 103704 |================================================================= 3 . 106573 |=================================================================== PostgreSQL pgbench 14.0 Scaling Factor: 10000 - Clients: 100 - Mode: Read Only - Average Latency ms < Lower Is Better 1 . 0.964 |==================================================================== 3 . 0.938 |================================================================== PostgreSQL pgbench 14.0 Scaling Factor: 10000 - Clients: 250 - Mode: Read Only TPS > Higher Is Better 1 . 100746 |=================================================================== 3 . 99054 |================================================================== PostgreSQL pgbench 14.0 Scaling Factor: 10000 - Clients: 250 - Mode: Read Only - Average Latency ms < Lower Is Better 1 . 2.481 |=================================================================== 3 . 2.524 |==================================================================== PostgreSQL pgbench 14.0 Scaling Factor: 10000 - Clients: 50 - Mode: Read Write TPS > Higher Is Better 1 . 4104 |============================================================= 3 . 4680 |===================================================================== PostgreSQL pgbench 14.0 Scaling Factor: 10000 - Clients: 50 - Mode: Read Write - Average Latency ms < Lower Is Better 1 . 12.18 |==================================================================== 3 . 10.68 |============================================================ PostgreSQL pgbench 14.0 Scaling Factor: 10000 - Clients: 500 - Mode: Read Only TPS > Higher Is Better 1 . 89254 |==================================================================== 3 . 88698 |==================================================================== PostgreSQL pgbench 14.0 Scaling Factor: 10000 - Clients: 500 - Mode: Read Only - Average Latency ms < Lower Is Better 1 . 5.602 |==================================================================== 3 . 5.637 |====================================================================