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.
Compare your own system(s) to this result file with the
Phoronix Test Suite by running the command:
phoronix-test-suite benchmark 2110011-PTS-PGBENCH141
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: 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: 250 - Mode: Read Only
TPS > Higher Is Better
1 . 100746 |===================================================================
3 . 99054 |==================================================================
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: 100 - Mode: Read Only
TPS > Higher Is Better
1 . 103704 |=================================================================
3 . 106573 |===================================================================
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: 1 - Mode: Read Write
TPS > Higher Is Better
1 . 545 |======================================================================
3 . 186 |========================
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: 10000 - Clients: 50 - Mode: Read Only
TPS > Higher Is Better
1 . 88400 |====================================================================
3 . 83836 |================================================================
PostgreSQL pgbench 14.0
Scaling Factor: 10000 - Clients: 500 - Mode: Read Only - Average Latency
ms < Lower Is Better
1 . 5.602 |====================================================================
3 . 5.637 |====================================================================
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: 50 - Mode: Read Write - Average Latency
ms < Lower Is Better
1 . 12.18 |====================================================================
3 . 10.68 |============================================================
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: 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: 10000 - Clients: 1 - Mode: Read Only
TPS > Higher Is Better
1 . 3385 |=====================================================================
2 . 3315 |====================================================================
3 . 3226 |==================================================================
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: 1000 - Clients: 500 - Mode: Read Only
TPS > Higher Is Better
1 . 228248 |===================================================================
3 . 219698 |================================================================
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: 100 - Mode: Read Only
TPS > Higher Is Better
1 . 295676 |==================================================================
2 . 300111 |===================================================================
3 . 300589 |===================================================================
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: 250 - Mode: Read Only
TPS > Higher Is Better
1 . 272368 |============================================================
2 . 295003 |=================================================================
3 . 302741 |===================================================================
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: 1000 - Clients: 500 - Mode: Read Write
TPS > Higher Is Better
1 . 10850 |====================================================================
3 . 9597 |============================================================
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: 250 - Mode: Read Write
TPS > Higher Is Better
1 . 12577 |====================================================================
3 . 11421 |==============================================================
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: 50 - Mode: Read Write
TPS > Higher Is Better
1 . 6697 |================================================================
2 . 6550 |==============================================================
3 . 7251 |=====================================================================
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: 100 - Mode: Read Write
TPS > Higher Is Better
1 . 10166 |====================================================================
3 . 9573 |================================================================
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: 1000 - Clients: 1 - Mode: Read Only
TPS > Higher Is Better
1 . 37385 |====================================================================
2 . 37180 |====================================================================
3 . 36920 |===================================================================
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: 1000 - Clients: 50 - Mode: Read Only
TPS > Higher Is Better
1 . 300871 |==================================================================
2 . 302413 |==================================================================
3 . 305978 |===================================================================
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: 1 - Mode: Read Write
TPS > Higher Is Better
1 . 219 |======================================================================
2 . 216 |=====================================================================
3 . 215 |=====================================================================
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: 100 - Clients: 1 - Mode: Read Only
TPS > Higher Is Better
1 . 42816 |====================================================================
2 . 42369 |===================================================================
3 . 42197 |===================================================================
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: 250 - Mode: Read Write
TPS > Higher Is Better
1 . 11728 |====================================================================
2 . 11519 |===================================================================
3 . 11744 |====================================================================
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: 100 - Mode: Read Write
TPS > Higher Is Better
1 . 10026 |====================================================================
2 . 9730 |==================================================================
3 . 8798 |============================================================
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: 100 - Clients: 500 - Mode: Read Only
TPS > Higher Is Better
1 . 223050 |===================================================================
2 . 219639 |==================================================================
3 . 223683 |===================================================================
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: 1 - Mode: Read Write
TPS > Higher Is Better
1 . 228 |=============================
2 . 524 |==================================================================
3 . 555 |======================================================================
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: 100 - Clients: 500 - Mode: Read Write
TPS > Higher Is Better
1 . 12351 |====================================================================
2 . 11124 |=============================================================
3 . 11629 |================================================================
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: 100 - Clients: 50 - Mode: Read Only
TPS > Higher Is Better
1 . 338552 |==================================================================
2 . 346043 |===================================================================
3 . 339878 |==================================================================
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: 250 - Mode: Read Only
TPS > Higher Is Better
1 . 255129 |================================================================
2 . 258929 |=================================================================
3 . 265125 |===================================================================
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: 50 - Mode: Read Write
TPS > Higher Is Better
1 . 22299 |====================================================================
2 . 5896 |==================
3 . 7003 |=====================
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: 100 - Mode: Read Only
TPS > Higher Is Better
1 . 321666 |=================================================================
2 . 327005 |==================================================================
3 . 329769 |===================================================================
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 Only
TPS > Higher Is Better
1 . 46233 |====================================================================
2 . 44845 |==================================================================
3 . 44833 |==================================================================
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: 1 - Clients: 500 - Mode: Read Write
TPS > Higher Is Better
1 . 986 |======================================================================
2 . 978 |=====================================================================
3 . 898 |================================================================
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: 250 - Mode: Read Write
TPS > Higher Is Better
1 . 1236 |=====================================================================
2 . 1013 |=========================================================
3 . 910 |===================================================
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: 50 - Mode: Read Write
TPS > Higher Is Better
1 . 1557 |=====================================================================
2 . 1054 |===============================================
3 . 1052 |===============================================
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: 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 Write - Average Latency
ms < Lower Is Better
1 . 56.61 |=======================================
2 . 84.04 |==========================================================
3 . 98.82 |====================================================================
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: 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: 250 - Mode: Read Only
TPS > Higher Is Better
1 . 272037 |===================================================================
2 . 268575 |==================================================================
3 . 271358 |===================================================================
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: 1 - Clients: 500 - Mode: Read Only
TPS > Higher Is Better
1 . 238283 |==================================================================
2 . 242563 |===================================================================
3 . 242800 |===================================================================
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: 50 - Mode: Read Only
TPS > Higher Is Better
1 . 360185 |==================================================================
2 . 364670 |===================================================================
3 . 358534 |==================================================================
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: 1 - Mode: Read Write
TPS > Higher Is Better
1 . 1575 |=====================================================================
2 . 965 |==========================================
3 . 949 |==========================================