henny-ribeye-2950x-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.
HTML result view exported from: https://openbenchmarking.org/result/2301070-NE-2301072KH29&rdt&grr .
henny-ribeye-2950x-postgres Processor Motherboard Chipset Memory Disk Graphics Audio Network Monitor OS Kernel Desktop Display Driver OpenGL Compiler File-System Screen Resolution henny-ribeye-2950x-postgres henny-ribeye-i73930k-postgres henny-ribeye-i73930k-vs-2950x-mini-postgres AMD Ryzen Threadripper 2950X 16-Core @ 3.50GHz (32 Cores) ASRock X399M Taichi AMD Family 17h 32768MB 92GB MSI NVIDIA GeForce RTX 2080 8192MB (1515/7000MHz) Realtek ALC1220 Intel I211 Gigabit Connection + Intel Dual Band Wireless-AC 3168NGW Ubuntu 18.04 4.15.0-201-lowlatency (x86_64) GNOME Shell 3.28.4 NVIDIA 415.27 4.6.0 Clang 6.0.0-1ubuntu2 + LLVM 6.0.0 + CUDA 9.1 ext4 5120x1440 Intel Core i7-3930K @ 5.70GHz (6 Cores / 12 Threads) ASUS SABERTOOTH X79 (4608 BIOS) Intel Xeon E5/Core 16GB 400GB INTEL SSDPEDMW400G4 + 256GB Samsung SSD 840 Sapphire AMD Radeon R7 370 R9 270X/370X Realtek ALC892 XZ350CU Intel 82579V Ubuntu 22.04 5.15.0-57-lowlatency (x86_64) GCC 11.3.0 + LLVM 14.0.0 1024x768 OpenBenchmarking.org Compiler Details - henny-ribeye-2950x-postgres: --build=x86_64-linux-gnu --disable-vtable-verify --disable-werror --enable-bootstrap --enable-checking=release --enable-clocale=gnu --enable-default-pie --enable-gnu-unique-object --enable-languages=c,ada,c++,go,brig,d,fortran,objc,obj-c++ --enable-libmpx --enable-libstdcxx-debug --enable-libstdcxx-time=yes --enable-multiarch --enable-multilib --enable-nls --enable-objc-gc=auto --enable-offload-targets=nvptx-none --enable-plugin --enable-shared --enable-threads=posix --host=x86_64-linux-gnu --program-prefix=x86_64-linux-gnu- --target=x86_64-linux-gnu --with-abi=m64 --with-arch-32=i686 --with-default-libstdcxx-abi=new --with-gcc-major-version-only --with-multilib-list=m32,m64,mx32 --with-target-system-zlib --with-tune=generic --without-cuda-driver -v - henny-ribeye-i73930k-postgres: --build=x86_64-linux-gnu --disable-vtable-verify --disable-werror --enable-bootstrap --enable-cet --enable-checking=release --enable-clocale=gnu --enable-default-pie --enable-gnu-unique-object --enable-languages=c,ada,c++,go,brig,d,fortran,objc,obj-c++,m2 --enable-libphobos-checking=release --enable-libstdcxx-debug --enable-libstdcxx-time=yes --enable-link-serialization=2 --enable-multiarch --enable-multilib --enable-nls --enable-objc-gc=auto --enable-offload-targets=nvptx-none=/build/gcc-11-xKiWfi/gcc-11-11.3.0/debian/tmp-nvptx/usr,amdgcn-amdhsa=/build/gcc-11-xKiWfi/gcc-11-11.3.0/debian/tmp-gcn/usr --enable-plugin --enable-shared --enable-threads=posix --host=x86_64-linux-gnu --program-prefix=x86_64-linux-gnu- --target=x86_64-linux-gnu --with-abi=m64 --with-arch-32=i686 --with-build-config=bootstrap-lto-lean --with-default-libstdcxx-abi=new --with-gcc-major-version-only --with-multilib-list=m32,m64,mx32 --with-target-system-zlib=auto --with-tune=generic --without-cuda-driver -v - henny-ribeye-i73930k-vs-2950x-mini-postgres: --build=x86_64-linux-gnu --disable-vtable-verify --disable-werror --enable-bootstrap --enable-cet --enable-checking=release --enable-clocale=gnu --enable-default-pie --enable-gnu-unique-object --enable-languages=c,ada,c++,go,brig,d,fortran,objc,obj-c++,m2 --enable-libphobos-checking=release --enable-libstdcxx-debug --enable-libstdcxx-time=yes --enable-link-serialization=2 --enable-multiarch --enable-multilib --enable-nls --enable-objc-gc=auto --enable-offload-targets=nvptx-none=/build/gcc-11-xKiWfi/gcc-11-11.3.0/debian/tmp-nvptx/usr,amdgcn-amdhsa=/build/gcc-11-xKiWfi/gcc-11-11.3.0/debian/tmp-gcn/usr --enable-plugin --enable-shared --enable-threads=posix --host=x86_64-linux-gnu --program-prefix=x86_64-linux-gnu- --target=x86_64-linux-gnu --with-abi=m64 --with-arch-32=i686 --with-build-config=bootstrap-lto-lean --with-default-libstdcxx-abi=new --with-gcc-major-version-only --with-multilib-list=m32,m64,mx32 --with-target-system-zlib=auto --with-tune=generic --without-cuda-driver -v Processor Details - henny-ribeye-2950x-postgres: Scaling Governor: acpi-cpufreq ondemand - henny-ribeye-i73930k-postgres: Scaling Governor: intel_cpufreq schedutil - CPU Microcode: 0x71a - henny-ribeye-i73930k-vs-2950x-mini-postgres: Scaling Governor: intel_cpufreq schedutil - CPU Microcode: 0x71a System Details - henny-ribeye-2950x-postgres: Anisotropic Filtering: 16x. Kernel Details - henny-ribeye-i73930k-postgres, henny-ribeye-i73930k-vs-2950x-mini-postgres: Transparent Huge Pages: madvise Environment Details - henny-ribeye-i73930k-postgres, henny-ribeye-i73930k-vs-2950x-mini-postgres: CXXFLAGS="-march=native -mtune=native -pipe -O2" ARCHFLAGS="-arch x86_64" CFLAGS="-march=native -mtune=native -pipe -O2" CPPFLAGS="-march=native -mtune=native -pipe -O2" Security Details - henny-ribeye-i73930k-postgres, henny-ribeye-i73930k-vs-2950x-mini-postgres: itlb_multihit: KVM: Mitigation of VMX disabled + l1tf: Mitigation of PTE Inversion; VMX: conditional cache flushes SMT vulnerable + mds: Mitigation of Clear buffers; SMT vulnerable + meltdown: Mitigation of PTI + mmio_stale_data: Unknown: No mitigations + retbleed: Not affected + spec_store_bypass: Mitigation of SSB disabled via prctl and seccomp + spectre_v1: Mitigation of usercopy/swapgs barriers and __user pointer sanitization + spectre_v2: Mitigation of Retpolines IBPB: conditional IBRS_FW STIBP: conditional RSB filling PBRSB-eIBRS: Not affected + srbds: Not affected + tsx_async_abort: Not affected
henny-ribeye-2950x-postgres pgbench: 1 - 500 - Read Write - Average Latency pgbench: 1 - 500 - Read Write pgbench: 1 - 500 - Read Only - Average Latency pgbench: 1 - 500 - Read Only henny-ribeye-2950x-postgres henny-ribeye-i73930k-postgres henny-ribeye-i73930k-vs-2950x-mini-postgres 535 660958 1291.510 387 2.590 193021 OpenBenchmarking.org
PostgreSQL Scaling Factor: 1 - Clients: 500 - Mode: Read Write - Average Latency OpenBenchmarking.org ms, Fewer Is Better PostgreSQL 15 Scaling Factor: 1 - Clients: 500 - Mode: Read Write - Average Latency henny-ribeye-i73930k-vs-2950x-mini-postgres 300 600 900 1200 1500 SE +/- 16.30, N = 3 1291.51 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -march=native -mtune=native -pipe -O2 -lpgcommon -lpgport -lpq -lm
PostgreSQL Scaling Factor: 1 - Clients: 500 - Mode: Read Write OpenBenchmarking.org TPS, More Is Better PostgreSQL 15 Scaling Factor: 1 - Clients: 500 - Mode: Read Write henny-ribeye-2950x-postgres henny-ribeye-i73930k-vs-2950x-mini-postgres 120 240 360 480 600 SE +/- 10.71, N = 6 SE +/- 4.94, N = 3 535 387 -lpthread -lrt -ldl 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -march=native -mtune=native -pipe -O2 -lpgcommon -lpgport -lpq -lm
PostgreSQL Scaling Factor: 1 - Clients: 500 - Mode: Read Only - Average Latency OpenBenchmarking.org ms, Fewer Is Better PostgreSQL 15 Scaling Factor: 1 - Clients: 500 - Mode: Read Only - Average Latency henny-ribeye-i73930k-vs-2950x-mini-postgres 0.5828 1.1656 1.7484 2.3312 2.914 SE +/- 0.007, N = 3 2.590 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -march=native -mtune=native -pipe -O2 -lpgcommon -lpgport -lpq -lm
PostgreSQL Scaling Factor: 1 - Clients: 500 - Mode: Read Only OpenBenchmarking.org TPS, More Is Better PostgreSQL 15 Scaling Factor: 1 - Clients: 500 - Mode: Read Only henny-ribeye-2950x-postgres henny-ribeye-i73930k-vs-2950x-mini-postgres 140K 280K 420K 560K 700K SE +/- 353.73, N = 3 SE +/- 526.08, N = 3 660958 193021 -lpthread -lrt -ldl 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -march=native -mtune=native -pipe -O2 -lpgcommon -lpgport -lpq -lm
Phoronix Test Suite v10.8.5