pgbench threadripper AMD Ryzen Threadripper 3990X 64-Core testing with a Gigabyte TRX40 AORUS PRO WIFI (F4p BIOS) and AMD Radeon RX 5700 8GB on Ubuntu 22.10 via the Phoronix Test Suite. a: Processor: AMD Ryzen Threadripper 3990X 64-Core @ 2.90GHz (64 Cores / 128 Threads), Motherboard: Gigabyte TRX40 AORUS PRO WIFI (F4p BIOS), Chipset: AMD Starship/Matisse, Memory: 128GB, Disk: Samsung SSD 970 EVO Plus 500GB, Graphics: AMD Radeon RX 5700 8GB (1750/875MHz), Audio: AMD Navi 10 HDMI Audio, Monitor: DELL P2415Q, Network: Intel I211 + Intel Wi-Fi 6 AX200 OS: Ubuntu 22.10, Kernel: 6.1.0-rc8-phx-mglru (x86_64), Desktop: GNOME Shell 43.0, Display Server: X Server 1.21.1.4 + Wayland, OpenGL: 4.6 Mesa 22.2.1 (LLVM 15.0.2 DRM 3.49), Vulkan: 1.3.224, Compiler: GCC 12.2.0 + LLVM 15.0.2, File-System: ext4, Screen Resolution: 3840x2160 b: Processor: AMD Ryzen Threadripper 3990X 64-Core @ 2.90GHz (64 Cores / 128 Threads), Motherboard: Gigabyte TRX40 AORUS PRO WIFI (F4p BIOS), Chipset: AMD Starship/Matisse, Memory: 128GB, Disk: Samsung SSD 970 EVO Plus 500GB, Graphics: AMD Radeon RX 5700 8GB (1750/875MHz), Audio: AMD Navi 10 HDMI Audio, Monitor: DELL P2415Q, Network: Intel I211 + Intel Wi-Fi 6 AX200 OS: Ubuntu 22.10, Kernel: 6.1.0-rc8-phx-mglru (x86_64), Desktop: GNOME Shell 43.0, Display Server: X Server 1.21.1.4 + Wayland, OpenGL: 4.6 Mesa 22.2.1 (LLVM 15.0.2 DRM 3.49), Vulkan: 1.3.224, Compiler: GCC 12.2.0 + LLVM 15.0.2, File-System: ext4, Screen Resolution: 3840x2160 c: Processor: AMD Ryzen Threadripper 3990X 64-Core @ 2.90GHz (64 Cores / 128 Threads), Motherboard: Gigabyte TRX40 AORUS PRO WIFI (F4p BIOS), Chipset: AMD Starship/Matisse, Memory: 128GB, Disk: Samsung SSD 970 EVO Plus 500GB, Graphics: AMD Radeon RX 5700 8GB (1750/875MHz), Audio: AMD Navi 10 HDMI Audio, Monitor: DELL P2415Q, Network: Intel I211 + Intel Wi-Fi 6 AX200 OS: Ubuntu 22.10, Kernel: 6.1.0-rc8-phx-mglru (x86_64), Desktop: GNOME Shell 43.0, Display Server: X Server 1.21.1.4 + Wayland, OpenGL: 4.6 Mesa 22.2.1 (LLVM 15.0.2 DRM 3.49), Vulkan: 1.3.224, Compiler: GCC 12.2.0 + LLVM 15.0.2, File-System: ext4, Screen Resolution: 3840x2160 PostgreSQL 15 Scaling Factor: 1 - Clients: 1 - Mode: Read Only TPS > Higher Is Better a . 38534 |================================================================== b . 39673 |==================================================================== c . 39441 |==================================================================== PostgreSQL 15 Scaling Factor: 1 - Clients: 1 - Mode: Read Only - Average Latency ms < Lower Is Better a . 0.026 |==================================================================== b . 0.025 |================================================================= c . 0.025 |================================================================= PostgreSQL 15 Scaling Factor: 1 - Clients: 1 - Mode: Read Write TPS > Higher Is Better a . 698 |===================================================================== b . 704 |====================================================================== c . 703 |====================================================================== PostgreSQL 15 Scaling Factor: 1 - Clients: 1 - Mode: Read Write - Average Latency ms < Lower Is Better a . 1.432 |==================================================================== b . 1.419 |=================================================================== c . 1.423 |==================================================================== PostgreSQL 15 Scaling Factor: 1 - Clients: 50 - Mode: Read Only TPS > Higher Is Better a . 1784956 |================================================================ b . 1754664 |=============================================================== c . 1827511 |================================================================== PostgreSQL 15 Scaling Factor: 1 - Clients: 50 - Mode: Read Only - Average Latency ms < Lower Is Better a . 0.028 |==================================================================== b . 0.028 |==================================================================== c . 0.027 |================================================================== PostgreSQL 15 Scaling Factor: 1 - Clients: 100 - Mode: Read Only TPS > Higher Is Better a . 1887539 |================================================================== b . 1870497 |================================================================= c . 1895973 |================================================================== PostgreSQL 15 Scaling Factor: 1 - Clients: 100 - Mode: Read Only - Average Latency ms < Lower Is Better a . 0.053 |=================================================================== b . 0.054 |==================================================================== c . 0.053 |=================================================================== PostgreSQL 15 Scaling Factor: 1 - Clients: 250 - Mode: Read Only TPS > Higher Is Better a . 2440508 |================================================================== b . 2363709 |================================================================ c . 2409891 |================================================================= PostgreSQL 15 Scaling Factor: 1 - Clients: 250 - Mode: Read Only - Average Latency ms < Lower Is Better a . 0.102 |================================================================= b . 0.106 |==================================================================== c . 0.104 |=================================================================== PostgreSQL 15 Scaling Factor: 1 - Clients: 50 - Mode: Read Write TPS > Higher Is Better a . 701 |====================================================================== b . 690 |===================================================================== c . 695 |===================================================================== PostgreSQL 15 Scaling Factor: 1 - Clients: 50 - Mode: Read Write - Average Latency ms < Lower Is Better a . 71.32 |=================================================================== b . 72.46 |==================================================================== c . 71.99 |==================================================================== PostgreSQL 15 Scaling Factor: 1 - Clients: 500 - Mode: Read Only TPS > Higher Is Better a . 2435508 |================================================================== b . 2380298 |================================================================= c . 2382344 |================================================================= PostgreSQL 15 Scaling Factor: 1 - Clients: 500 - Mode: Read Only - Average Latency ms < Lower Is Better a . 0.205 |================================================================== b . 0.210 |==================================================================== c . 0.210 |==================================================================== PostgreSQL 15 Scaling Factor: 1 - Clients: 800 - Mode: Read Only TPS > Higher Is Better a . 2386549 |================================================================== b . 2374779 |================================================================= c . 2395535 |================================================================== PostgreSQL 15 Scaling Factor: 1 - Clients: 800 - Mode: Read Only - Average Latency ms < Lower Is Better a . 0.335 |==================================================================== b . 0.337 |==================================================================== c . 0.334 |=================================================================== PostgreSQL 15 Scaling Factor: 100 - Clients: 1 - Mode: Read Only TPS > Higher Is Better a . 35871 |================================================================== b . 36776 |==================================================================== c . 36439 |=================================================================== PostgreSQL 15 Scaling Factor: 100 - Clients: 1 - Mode: Read Only - Average Latency ms < Lower Is Better a . 0.028 |==================================================================== b . 0.027 |================================================================== c . 0.027 |================================================================== PostgreSQL 15 Scaling Factor: 1 - Clients: 100 - Mode: Read Write TPS > Higher Is Better a . 681 |====================================================================== b . 680 |====================================================================== c . 669 |===================================================================== PostgreSQL 15 Scaling Factor: 1 - Clients: 100 - Mode: Read Write - Average Latency ms < Lower Is Better a . 146.83 |================================================================== b . 147.12 |================================================================== c . 149.42 |=================================================================== PostgreSQL 15 Scaling Factor: 1 - Clients: 1000 - Mode: Read Only TPS > Higher Is Better a . 2407675 |================================================================= b . 2423998 |================================================================== c . 2427300 |================================================================== PostgreSQL 15 Scaling Factor: 1 - Clients: 1000 - Mode: Read Only - Average Latency ms < Lower Is Better a . 0.415 |==================================================================== b . 0.413 |==================================================================== c . 0.412 |==================================================================== PostgreSQL 15 Scaling Factor: 1 - Clients: 250 - Mode: Read Write TPS > Higher Is Better a . 631 |====================================================================== b . 630 |====================================================================== c . 620 |===================================================================== PostgreSQL 15 Scaling Factor: 1 - Clients: 250 - Mode: Read Write - Average Latency ms < Lower Is Better a . 396.40 |================================================================== b . 396.94 |================================================================== c . 403.51 |=================================================================== PostgreSQL 15 Scaling Factor: 1 - Clients: 500 - Mode: Read Write TPS > Higher Is Better a . 483 |============================================================== b . 546 |====================================================================== c . 500 |================================================================ PostgreSQL 15 Scaling Factor: 1 - Clients: 500 - Mode: Read Write - Average Latency ms < Lower Is Better a . 1036.00 |================================================================== b . 917.42 |========================================================== c . 999.63 |================================================================ PostgreSQL 15 Scaling Factor: 1 - Clients: 800 - Mode: Read Write TPS > Higher Is Better a . 356 |================================================================ b . 392 |====================================================================== c . 374 |=================================================================== PostgreSQL 15 Scaling Factor: 1 - Clients: 800 - Mode: Read Write - Average Latency ms < Lower Is Better a . 2244.47 |================================================================== b . 2061.54 |============================================================= c . 2137.70 |=============================================================== PostgreSQL 15 Scaling Factor: 100 - Clients: 1 - Mode: Read Write TPS > Higher Is Better a . 436 |====================================================================== b . 431 |===================================================================== c . 436 |====================================================================== PostgreSQL 15 Scaling Factor: 100 - Clients: 1 - Mode: Read Write - Average Latency ms < Lower Is Better a . 2.294 |=================================================================== b . 2.320 |==================================================================== c . 2.295 |=================================================================== PostgreSQL 15 Scaling Factor: 100 - Clients: 50 - Mode: Read Only TPS > Higher Is Better a . 1623968 |================================================================== b . 1610958 |================================================================= c . 1623194 |================================================================== PostgreSQL 15 Scaling Factor: 100 - Clients: 50 - Mode: Read Only - Average Latency ms < Lower Is Better a . 0.031 |==================================================================== b . 0.031 |==================================================================== c . 0.031 |==================================================================== PostgreSQL 15 Scaling Factor: 1000 - Clients: 1 - Mode: Read Only TPS > Higher Is Better a . 34998 |==================================================================== b . 34825 |==================================================================== c . 33964 |================================================================== PostgreSQL 15 Scaling Factor: 1000 - Clients: 1 - Mode: Read Only - Average Latency ms < Lower Is Better a . 0.029 |==================================================================== b . 0.029 |==================================================================== c . 0.029 |==================================================================== PostgreSQL 15 Scaling Factor: 1 - Clients: 1000 - Mode: Read Write TPS > Higher Is Better a . 349 |========================================================== b . 368 |============================================================= c . 421 |====================================================================== PostgreSQL 15 Scaling Factor: 1 - Clients: 1000 - Mode: Read Write - Average Latency ms < Lower Is Better a . 2867.33 |================================================================== b . 2736.53 |=============================================================== c . 2377.09 |======================================================= PostgreSQL 15 Scaling Factor: 100 - Clients: 100 - Mode: Read Only TPS > Higher Is Better a . 1811132 |================================================================== b . 1791916 |================================================================= c . 1807598 |================================================================== PostgreSQL 15 Scaling Factor: 100 - Clients: 100 - Mode: Read Only - Average Latency ms < Lower Is Better a . 0.055 |=================================================================== b . 0.056 |==================================================================== c . 0.055 |=================================================================== PostgreSQL 15 Scaling Factor: 100 - Clients: 250 - Mode: Read Only TPS > Higher Is Better a . 2191120 |================================================================= b . 2195579 |================================================================= c . 2227477 |================================================================== PostgreSQL 15 Scaling Factor: 100 - Clients: 250 - Mode: Read Only - Average Latency ms < Lower Is Better a . 0.114 |==================================================================== b . 0.114 |==================================================================== c . 0.112 |=================================================================== PostgreSQL 15 Scaling Factor: 100 - Clients: 50 - Mode: Read Write TPS > Higher Is Better a . 5922 |===================================================================== b . 4494 |==================================================== c . 4188 |================================================= PostgreSQL 15 Scaling Factor: 100 - Clients: 50 - Mode: Read Write - Average Latency ms < Lower Is Better a . 8.443 |=============================================== b . 11.127 |============================================================== c . 11.938 |=================================================================== PostgreSQL 15 Scaling Factor: 100 - Clients: 500 - Mode: Read Only TPS > Higher Is Better a . 2167082 |================================================================= b . 2217374 |================================================================== c . 2177299 |================================================================= PostgreSQL 15 Scaling Factor: 100 - Clients: 500 - Mode: Read Only - Average Latency ms < Lower Is Better a . 0.231 |==================================================================== b . 0.225 |================================================================== c . 0.230 |==================================================================== PostgreSQL 15 Scaling Factor: 100 - Clients: 800 - Mode: Read Only TPS > Higher Is Better a . 2181055 |================================================================= b . 2178413 |================================================================= c . 2202851 |================================================================== PostgreSQL 15 Scaling Factor: 100 - Clients: 800 - Mode: Read Only - Average Latency ms < Lower Is Better a . 0.367 |==================================================================== b . 0.367 |==================================================================== c . 0.363 |=================================================================== PostgreSQL 15 Scaling Factor: 1000 - Clients: 1 - Mode: Read Write TPS > Higher Is Better a . 354 |====================================================================== b . 347 |===================================================================== c . 349 |===================================================================== PostgreSQL 15 Scaling Factor: 1000 - Clients: 1 - Mode: Read Write - Average Latency ms < Lower Is Better a . 2.823 |=================================================================== b . 2.878 |==================================================================== c . 2.866 |==================================================================== PostgreSQL 15 Scaling Factor: 1000 - Clients: 50 - Mode: Read Only TPS > Higher Is Better a . 1387004 |================================================================== b . 1360566 |================================================================= c . 1373211 |================================================================= PostgreSQL 15 Scaling Factor: 1000 - Clients: 50 - Mode: Read Only - Average Latency ms < Lower Is Better a . 0.036 |================================================================== b . 0.037 |==================================================================== c . 0.036 |================================================================== PostgreSQL 15 Scaling Factor: 100 - Clients: 100 - Mode: Read Write TPS > Higher Is Better a . 7591 |===================================================================== b . 5963 |====================================================== c . 5784 |===================================================== PostgreSQL 15 Scaling Factor: 100 - Clients: 100 - Mode: Read Write - Average Latency ms < Lower Is Better a . 13.17 |==================================================== b . 16.77 |================================================================== c . 17.29 |==================================================================== PostgreSQL 15 Scaling Factor: 100 - Clients: 1000 - Mode: Read Only TPS > Higher Is Better a . 2190656 |================================================================== b . 2191297 |================================================================== c . 2198749 |================================================================== PostgreSQL 15 Scaling Factor: 100 - Clients: 1000 - Mode: Read Only - Average Latency ms < Lower Is Better a . 0.456 |==================================================================== b . 0.456 |==================================================================== c . 0.455 |==================================================================== PostgreSQL 15 Scaling Factor: 100 - Clients: 250 - Mode: Read Write TPS > Higher Is Better a . 8220 |===================================================================== b . 6815 |========================================================= c . 6810 |========================================================= PostgreSQL 15 Scaling Factor: 100 - Clients: 250 - Mode: Read Write - Average Latency ms < Lower Is Better a . 30.41 |======================================================== b . 36.69 |==================================================================== c . 36.71 |==================================================================== PostgreSQL 15 Scaling Factor: 100 - Clients: 500 - Mode: Read Write TPS > Higher Is Better a . 7000 |================================================================= b . 7393 |===================================================================== c . 7115 |================================================================== PostgreSQL 15 Scaling Factor: 100 - Clients: 500 - Mode: Read Write - Average Latency ms < Lower Is Better a . 71.43 |==================================================================== b . 67.66 |================================================================ c . 70.28 |=================================================================== PostgreSQL 15 Scaling Factor: 100 - Clients: 800 - Mode: Read Write TPS > Higher Is Better a . 7483 |===================================================================== b . 7334 |==================================================================== c . 6969 |================================================================ PostgreSQL 15 Scaling Factor: 100 - Clients: 800 - Mode: Read Write - Average Latency ms < Lower Is Better a . 106.91 |============================================================== b . 109.14 |================================================================ c . 114.80 |=================================================================== PostgreSQL 15 Scaling Factor: 1000 - Clients: 100 - Mode: Read Only TPS > Higher Is Better a . 1536965 |================================================================= b . 1559199 |================================================================== c . 1561682 |================================================================== PostgreSQL 15 Scaling Factor: 1000 - Clients: 100 - Mode: Read Only - Average Latency ms < Lower Is Better a . 0.065 |==================================================================== b . 0.064 |=================================================================== c . 0.064 |=================================================================== PostgreSQL 15 Scaling Factor: 1000 - Clients: 250 - Mode: Read Only TPS > Higher Is Better a . 1101728 |================================================================= b . 1095251 |================================================================= c . 1120004 |================================================================== PostgreSQL 15 Scaling Factor: 1000 - Clients: 250 - Mode: Read Only - Average Latency ms < Lower Is Better a . 0.227 |==================================================================== b . 0.228 |==================================================================== c . 0.223 |=================================================================== PostgreSQL 15 Scaling Factor: 1000 - Clients: 50 - Mode: Read Write TPS > Higher Is Better a . 4816 |===================================================================== b . 3664 |==================================================== c . 3438 |================================================= PostgreSQL 15 Scaling Factor: 1000 - Clients: 50 - Mode: Read Write - Average Latency ms < Lower Is Better a . 10.38 |================================================= b . 13.65 |================================================================ c . 14.55 |==================================================================== PostgreSQL 15 Scaling Factor: 1000 - Clients: 500 - Mode: Read Only TPS > Higher Is Better a . 987180 |=================================================================== b . 940604 |=============================================================== c . 992488 |=================================================================== PostgreSQL 15 Scaling Factor: 1000 - Clients: 500 - Mode: Read Only - Average Latency ms < Lower Is Better a . 0.506 |================================================================= b . 0.532 |==================================================================== c . 0.504 |================================================================ PostgreSQL 15 Scaling Factor: 1000 - Clients: 800 - Mode: Read Only TPS > Higher Is Better a . 827644 |=================================================================== b . 813927 |================================================================== c . 825397 |=================================================================== PostgreSQL 15 Scaling Factor: 1000 - Clients: 800 - Mode: Read Only - Average Latency ms < Lower Is Better a . 0.967 |=================================================================== b . 0.983 |==================================================================== c . 0.969 |=================================================================== PostgreSQL 15 Scaling Factor: 100 - Clients: 1000 - Mode: Read Write TPS > Higher Is Better a . 8991 |===================================================================== b . 7486 |========================================================= c . 7005 |====================================================== PostgreSQL 15 Scaling Factor: 100 - Clients: 1000 - Mode: Read Write - Average Latency ms < Lower Is Better a . 111.23 |==================================================== b . 133.77 |=============================================================== c . 142.75 |=================================================================== PostgreSQL 15 Scaling Factor: 1000 - Clients: 100 - Mode: Read Write TPS > Higher Is Better a . 6912 |===================================================================== b . 5290 |===================================================== c . 5156 |=================================================== PostgreSQL 15 Scaling Factor: 1000 - Clients: 100 - Mode: Read Write - Average Latency ms < Lower Is Better a . 14.47 |=================================================== b . 18.91 |================================================================== c . 19.40 |==================================================================== PostgreSQL 15 Scaling Factor: 1000 - Clients: 1000 - Mode: Read Only TPS > Higher Is Better a . 844138 |=================================================================== b . 843969 |=================================================================== c . 831690 |================================================================== PostgreSQL 15 Scaling Factor: 1000 - Clients: 1000 - Mode: Read Only - Average Latency ms < Lower Is Better a . 1.185 |=================================================================== b . 1.186 |=================================================================== c . 1.202 |==================================================================== PostgreSQL 15 Scaling Factor: 1000 - Clients: 250 - Mode: Read Write TPS > Higher Is Better a . 7100 |===================================================================== b . 6097 |=========================================================== c . 6062 |=========================================================== PostgreSQL 15 Scaling Factor: 1000 - Clients: 250 - Mode: Read Write - Average Latency ms < Lower Is Better a . 35.21 |========================================================== b . 41.01 |==================================================================== c . 41.24 |==================================================================== PostgreSQL 15 Scaling Factor: 1000 - Clients: 500 - Mode: Read Write TPS > Higher Is Better a . 6526 |===================================================================== b . 6149 |================================================================= c . 5805 |============================================================= PostgreSQL 15 Scaling Factor: 1000 - Clients: 500 - Mode: Read Write - Average Latency ms < Lower Is Better a . 76.61 |============================================================ b . 81.59 |================================================================ c . 86.14 |==================================================================== PostgreSQL 15 Scaling Factor: 1000 - Clients: 800 - Mode: Read Write TPS > Higher Is Better a . 7488 |===================================================================== b . 6793 |=============================================================== c . 6605 |============================================================= PostgreSQL 15 Scaling Factor: 1000 - Clients: 800 - Mode: Read Write - Average Latency ms < Lower Is Better a . 106.84 |=========================================================== b . 118.14 |================================================================= c . 121.13 |=================================================================== PostgreSQL 15 Scaling Factor: 1000 - Clients: 1000 - Mode: Read Write TPS > Higher Is Better a . 7580 |======================================================== b . 9353 |===================================================================== c . 7183 |===================================================== PostgreSQL 15 Scaling Factor: 1000 - Clients: 1000 - Mode: Read Write - Average Latency ms < Lower Is Better a . 131.93 |=============================================================== b . 107.27 |==================================================== c . 139.22 |===================================================================