henny-ribeye-2950x-main-postgres Intel Core i7-3930K testing with a ASUS SABERTOOTH X79 (4608 BIOS) and Sapphire AMD Radeon R7 370 R9 270X/370X on Ubuntu 22.04 via the Phoronix Test Suite. henny-ribeye-2950x-main-postgres: Processor: AMD Ryzen Threadripper 2950X 16-Core @ 3.50GHz (16 Cores / 32 Threads), Motherboard: ASRock X399M Taichi (P3.80 BIOS), Chipset: AMD 17h, Memory: 32GB, Disk: 2048GB INTEL SSDPEKNW020T8 + 1000GB Samsung SSD 970 EVO 1TB + 1024GB INTEL SSDPEKNU010TZ, Graphics: MSI NVIDIA GeForce RTX 2080 8GB, Audio: Realtek ALC1220, Monitor: LC49G95T, Network: 2 x Intel I211 + Intel Dual Band-AC 3168NGW OS: Ubuntu 18.04, Kernel: 4.15.0-201-lowlatency (x86_64), Desktop: GNOME Shell 3.28.4, Display Server: X Server 1.19.6, Display Driver: NVIDIA 415.27, OpenGL: 4.6.0, Compiler: GCC 7.5.0 + Clang 6.0.0-1ubuntu2 + LLVM 6.0.0 + CUDA 9.1, File-System: ext4, Screen Resolution: 5120x1440 henny-ribeye-2950x-main-postgres-real: Processor: AMD Ryzen Threadripper 2950X 16-Core @ 3.50GHz (16 Cores / 32 Threads), Motherboard: ASRock X399M Taichi (P3.80 BIOS), Chipset: AMD 17h, Memory: 32GB, Disk: 2048GB INTEL SSDPEKNW020T8 + 1000GB Samsung SSD 970 EVO 1TB + 1024GB INTEL SSDPEKNU010TZ, Graphics: MSI NVIDIA GeForce RTX 2080 8GB, Audio: Realtek ALC1220, Monitor: LC49G95T, Network: 2 x Intel I211 + Intel Dual Band-AC 3168NGW OS: Ubuntu 18.04, Kernel: 4.15.0-201-lowlatency (x86_64), Desktop: GNOME Shell 3.28.4, Display Server: X Server 1.19.6, Display Driver: NVIDIA 415.27, OpenGL: 4.6.0, Compiler: GCC 7.5.0 + Clang 6.0.0-1ubuntu2 + LLVM 6.0.0 + CUDA 9.1, File-System: ext4, Screen Resolution: 5120x1440 henny-ribeye-2950x-vs-i73930k-postgres-real: Processor: Intel Core i7-3930K @ 5.70GHz (6 Cores / 12 Threads), Motherboard: ASUS SABERTOOTH X79 (4608 BIOS), Chipset: Intel Xeon E5/Core, Memory: 16GB, Disk: 400GB INTEL SSDPEDMW400G4 + 256GB Samsung SSD 840, Graphics: Sapphire AMD Radeon R7 370 R9 270X/370X, Audio: Realtek ALC892, Network: Intel 82579V OS: Ubuntu 22.04, Kernel: 5.15.0-57-lowlatency (x86_64), Compiler: GCC 11.3.0 + LLVM 14.0.0, File-System: ext4, Screen Resolution: 1024x768 PostgreSQL 15 Scaling Factor: 1 - Clients: 1 - Mode: Read Only TPS > Higher Is Better henny-ribeye-2950x-main-postgres-real ....... 48243 |========================== henny-ribeye-2950x-vs-i73930k-postgres-real . 29935 |================ PostgreSQL 15 Scaling Factor: 1 - Clients: 1 - Mode: Read Only - Average Latency ms < Lower Is Better henny-ribeye-2950x-main-postgres-real ....... 0.021 |================= henny-ribeye-2950x-vs-i73930k-postgres-real . 0.033 |========================== PostgreSQL 15 Scaling Factor: 1 - Clients: 1 - Mode: Read Write TPS > Higher Is Better henny-ribeye-2950x-main-postgres-real ....... 807 |====== henny-ribeye-2950x-vs-i73930k-postgres-real . 3364 |=========================== PostgreSQL 15 Scaling Factor: 1 - Clients: 1 - Mode: Read Write - Average Latency ms < Lower Is Better henny-ribeye-2950x-main-postgres-real ....... 1.239 |========================== henny-ribeye-2950x-vs-i73930k-postgres-real . 0.297 |====== PostgreSQL 15 Scaling Factor: 1 - Clients: 50 - Mode: Read Only TPS > Higher Is Better henny-ribeye-2950x-main-postgres-real ....... 708092 |========================= henny-ribeye-2950x-vs-i73930k-postgres-real . 194767 |======= PostgreSQL 15 Scaling Factor: 1 - Clients: 50 - Mode: Read Only - Average Latency ms < Lower Is Better henny-ribeye-2950x-main-postgres-real ....... 0.071 |======= henny-ribeye-2950x-vs-i73930k-postgres-real . 0.257 |========================== PostgreSQL 15 Scaling Factor: 1 - Clients: 100 - Mode: Read Only TPS > Higher Is Better henny-ribeye-2950x-main-postgres-real ....... 755661 |========================= henny-ribeye-2950x-vs-i73930k-postgres-real . 196139 |====== PostgreSQL 15 Scaling Factor: 1 - Clients: 100 - Mode: Read Only - Average Latency ms < Lower Is Better henny-ribeye-2950x-main-postgres-real ....... 0.132 |======= henny-ribeye-2950x-vs-i73930k-postgres-real . 0.510 |========================== PostgreSQL 15 Scaling Factor: 1 - Clients: 50 - Mode: Read Write TPS > Higher Is Better henny-ribeye-2950x-main-postgres-real ....... 796 |============= henny-ribeye-2950x-vs-i73930k-postgres-real . 1614 |=========================== PostgreSQL 15 Scaling Factor: 1 - Clients: 50 - Mode: Read Write - Average Latency ms < Lower Is Better henny-ribeye-2950x-main-postgres-real ....... 62.86 |========================== henny-ribeye-2950x-vs-i73930k-postgres-real . 30.97 |============= PostgreSQL 15 Scaling Factor: 1 - Clients: 500 - Mode: Read Only TPS > Higher Is Better henny-ribeye-2950x-main-postgres-real ....... 649287 |========================= henny-ribeye-2950x-vs-i73930k-postgres-real . 192560 |======= PostgreSQL 15 Scaling Factor: 1 - Clients: 500 - Mode: Read Only - Average Latency ms < Lower Is Better henny-ribeye-2950x-main-postgres-real ....... 0.770 |======== henny-ribeye-2950x-vs-i73930k-postgres-real . 2.597 |========================== PostgreSQL 15 Scaling Factor: 100 - Clients: 1 - Mode: Read Only TPS > Higher Is Better henny-ribeye-2950x-main-postgres-real ....... 44001 |========================== henny-ribeye-2950x-vs-i73930k-postgres-real . 28550 |================= PostgreSQL 15 Scaling Factor: 100 - Clients: 1 - Mode: Read Only - Average Latency ms < Lower Is Better henny-ribeye-2950x-main-postgres-real ....... 0.023 |================= henny-ribeye-2950x-vs-i73930k-postgres-real . 0.035 |========================== PostgreSQL 15 Scaling Factor: 1 - Clients: 100 - Mode: Read Write TPS > Higher Is Better henny-ribeye-2950x-main-postgres-real ....... 797 |================= henny-ribeye-2950x-vs-i73930k-postgres-real . 1256 |=========================== PostgreSQL 15 Scaling Factor: 1 - Clients: 100 - Mode: Read Write - Average Latency ms < Lower Is Better henny-ribeye-2950x-main-postgres-real ....... 125.55 |========================= henny-ribeye-2950x-vs-i73930k-postgres-real . 79.59 |================ PostgreSQL 15 Scaling Factor: 1 - Clients: 500 - Mode: Read Write TPS > Higher Is Better henny-ribeye-2950x-main-postgres-real ....... 625 |============================ henny-ribeye-2950x-vs-i73930k-postgres-real . 405 |================== PostgreSQL 15 Scaling Factor: 1 - Clients: 500 - Mode: Read Write - Average Latency ms < Lower Is Better henny-ribeye-2950x-main-postgres-real ....... 802.75 |=============== henny-ribeye-2950x-vs-i73930k-postgres-real . 1278.51 |======================== PostgreSQL 15 Scaling Factor: 100 - Clients: 1 - Mode: Read Write TPS > Higher Is Better henny-ribeye-2950x-main-postgres-real ....... 447 |==== henny-ribeye-2950x-vs-i73930k-postgres-real . 3094 |=========================== PostgreSQL 15 Scaling Factor: 100 - Clients: 1 - Mode: Read Write - Average Latency ms < Lower Is Better henny-ribeye-2950x-main-postgres-real ....... 2.236 |========================== henny-ribeye-2950x-vs-i73930k-postgres-real . 0.323 |==== PostgreSQL 15 Scaling Factor: 100 - Clients: 50 - Mode: Read Only TPS > Higher Is Better henny-ribeye-2950x-main-postgres-real ....... 661538 |========================= henny-ribeye-2950x-vs-i73930k-postgres-real . 187186 |======= PostgreSQL 15 Scaling Factor: 100 - Clients: 50 - Mode: Read Only - Average Latency ms < Lower Is Better henny-ribeye-2950x-main-postgres-real ....... 0.075 |======= henny-ribeye-2950x-vs-i73930k-postgres-real . 0.267 |========================== PostgreSQL 15 Scaling Factor: 1000 - Clients: 1 - Mode: Read Only TPS > Higher Is Better henny-ribeye-2950x-main-postgres-real ....... 30046 |========================== henny-ribeye-2950x-vs-i73930k-postgres-real . 8496 |======= PostgreSQL 15 Scaling Factor: 1000 - Clients: 1 - Mode: Read Only - Average Latency ms < Lower Is Better henny-ribeye-2950x-main-postgres-real ....... 0.033 |======= henny-ribeye-2950x-vs-i73930k-postgres-real . 0.118 |========================== PostgreSQL 15 Scaling Factor: 100 - Clients: 100 - Mode: Read Only TPS > Higher Is Better henny-ribeye-2950x-main-postgres-real ....... 696765 |========================= henny-ribeye-2950x-vs-i73930k-postgres-real . 186859 |======= PostgreSQL 15 Scaling Factor: 100 - Clients: 100 - Mode: Read Only - Average Latency ms < Lower Is Better henny-ribeye-2950x-main-postgres-real ....... 0.144 |======= henny-ribeye-2950x-vs-i73930k-postgres-real . 0.535 |========================== PostgreSQL 15 Scaling Factor: 100 - Clients: 50 - Mode: Read Write TPS > Higher Is Better henny-ribeye-2950x-main-postgres-real ....... 4508 |===== henny-ribeye-2950x-vs-i73930k-postgres-real . 22811 |========================== PostgreSQL 15 Scaling Factor: 100 - Clients: 50 - Mode: Read Write - Average Latency ms < Lower Is Better henny-ribeye-2950x-main-postgres-real ....... 11.104 |========================= henny-ribeye-2950x-vs-i73930k-postgres-real . 2.192 |===== PostgreSQL 15 Scaling Factor: 100 - Clients: 500 - Mode: Read Only TPS > Higher Is Better henny-ribeye-2950x-main-postgres-real ....... 620790 |========================= henny-ribeye-2950x-vs-i73930k-postgres-real . 184644 |======= PostgreSQL 15 Scaling Factor: 100 - Clients: 500 - Mode: Read Only - Average Latency ms < Lower Is Better henny-ribeye-2950x-main-postgres-real ....... 0.805 |======== henny-ribeye-2950x-vs-i73930k-postgres-real . 2.708 |========================== PostgreSQL 15 Scaling Factor: 1000 - Clients: 1 - Mode: Read Write TPS > Higher Is Better henny-ribeye-2950x-main-postgres-real ....... 280 |==== henny-ribeye-2950x-vs-i73930k-postgres-real . 2146 |=========================== PostgreSQL 15 Scaling Factor: 1000 - Clients: 1 - Mode: Read Write - Average Latency ms < Lower Is Better henny-ribeye-2950x-main-postgres-real ....... 3.573 |========================== henny-ribeye-2950x-vs-i73930k-postgres-real . 0.466 |=== PostgreSQL 15 Scaling Factor: 1000 - Clients: 50 - Mode: Read Only TPS > Higher Is Better henny-ribeye-2950x-main-postgres-real ....... 469264 |========================= henny-ribeye-2950x-vs-i73930k-postgres-real . 118572 |====== PostgreSQL 15 Scaling Factor: 1000 - Clients: 50 - Mode: Read Only - Average Latency ms < Lower Is Better henny-ribeye-2950x-main-postgres-real ....... 0.107 |======= henny-ribeye-2950x-vs-i73930k-postgres-real . 0.422 |========================== PostgreSQL 15 Scaling Factor: 100 - Clients: 100 - Mode: Read Write TPS > Higher Is Better henny-ribeye-2950x-main-postgres-real ....... 5759 |======= henny-ribeye-2950x-vs-i73930k-postgres-real . 22135 |========================== PostgreSQL 15 Scaling Factor: 100 - Clients: 100 - Mode: Read Write - Average Latency ms < Lower Is Better henny-ribeye-2950x-main-postgres-real ....... 17.386 |========================= henny-ribeye-2950x-vs-i73930k-postgres-real . 4.520 |====== PostgreSQL 15 Scaling Factor: 100 - Clients: 500 - Mode: Read Write TPS > Higher Is Better henny-ribeye-2950x-main-postgres-real ....... 6950 |=========== henny-ribeye-2950x-vs-i73930k-postgres-real . 15874 |========================== PostgreSQL 15 Scaling Factor: 100 - Clients: 500 - Mode: Read Write - Average Latency ms < Lower Is Better henny-ribeye-2950x-main-postgres-real ....... 71.94 |========================== henny-ribeye-2950x-vs-i73930k-postgres-real . 31.50 |=========== PostgreSQL 15 Scaling Factor: 1000 - Clients: 100 - Mode: Read Only TPS > Higher Is Better henny-ribeye-2950x-main-postgres-real ....... 482340 |========================= henny-ribeye-2950x-vs-i73930k-postgres-real . 112039 |====== PostgreSQL 15 Scaling Factor: 1000 - Clients: 100 - Mode: Read Only - Average Latency ms < Lower Is Better henny-ribeye-2950x-main-postgres-real ....... 0.207 |====== henny-ribeye-2950x-vs-i73930k-postgres-real . 0.893 |========================== PostgreSQL 15 Scaling Factor: 1000 - Clients: 50 - Mode: Read Write TPS > Higher Is Better henny-ribeye-2950x-main-postgres-real ....... 3494 |===== henny-ribeye-2950x-vs-i73930k-postgres-real . 18725 |========================== PostgreSQL 15 Scaling Factor: 1000 - Clients: 50 - Mode: Read Write - Average Latency ms < Lower Is Better henny-ribeye-2950x-main-postgres-real ....... 14.311 |========================= henny-ribeye-2950x-vs-i73930k-postgres-real . 2.674 |===== PostgreSQL 15 Scaling Factor: 1000 - Clients: 500 - Mode: Read Only TPS > Higher Is Better henny-ribeye-2950x-main-postgres-real ....... 258347 |========================= henny-ribeye-2950x-vs-i73930k-postgres-real . 76354 |======= PostgreSQL 15 Scaling Factor: 1000 - Clients: 500 - Mode: Read Only - Average Latency ms < Lower Is Better henny-ribeye-2950x-main-postgres-real ....... 1.935 |======== henny-ribeye-2950x-vs-i73930k-postgres-real . 6.549 |========================== PostgreSQL 15 Scaling Factor: 1000 - Clients: 100 - Mode: Read Write TPS > Higher Is Better henny-ribeye-2950x-main-postgres-real ....... 5610 |======== henny-ribeye-2950x-vs-i73930k-postgres-real . 19421 |========================== PostgreSQL 15 Scaling Factor: 1000 - Clients: 100 - Mode: Read Write - Average Latency ms < Lower Is Better henny-ribeye-2950x-main-postgres-real ....... 17.827 |========================= henny-ribeye-2950x-vs-i73930k-postgres-real . 5.149 |======= PostgreSQL 15 Scaling Factor: 1000 - Clients: 500 - Mode: Read Write TPS > Higher Is Better henny-ribeye-2950x-main-postgres-real ....... 8418 |================ henny-ribeye-2950x-vs-i73930k-postgres-real . 13685 |========================== PostgreSQL 15 Scaling Factor: 1000 - Clients: 500 - Mode: Read Write - Average Latency ms < Lower Is Better henny-ribeye-2950x-main-postgres-real ....... 59.40 |========================== henny-ribeye-2950x-vs-i73930k-postgres-real . 36.55 |================