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&grw.

henny-ribeye-2950x-postgresProcessorMotherboardChipsetMemoryDiskGraphicsAudioNetworkMonitorOSKernelDesktopDisplay DriverOpenGLCompilerFile-SystemScreen Resolutionhenny-ribeye-2950x-postgreshenny-ribeye-i73930k-postgreshenny-ribeye-i73930k-vs-2950x-mini-postgresAMD Ryzen Threadripper 2950X 16-Core @ 3.50GHz (32 Cores)ASRock X399M TaichiAMD Family 17h32768MB92GBMSI NVIDIA GeForce RTX 2080 8192MB (1515/7000MHz)Realtek ALC1220Intel I211 Gigabit Connection + Intel Dual Band Wireless-AC 3168NGWUbuntu 18.044.15.0-201-lowlatency (x86_64)GNOME Shell 3.28.4NVIDIA 415.274.6.0Clang 6.0.0-1ubuntu2 + LLVM 6.0.0 + CUDA 9.1ext45120x1440Intel Core i7-3930K @ 5.70GHz (6 Cores / 12 Threads)ASUS SABERTOOTH X79 (4608 BIOS)Intel Xeon E5/Core16GB400GB INTEL SSDPEDMW400G4 + 256GB Samsung SSD 840Sapphire AMD Radeon R7 370 R9 270X/370XRealtek ALC892XZ350CUIntel 82579VUbuntu 22.045.15.0-57-lowlatency (x86_64)GCC 11.3.0 + LLVM 14.0.01024x768OpenBenchmarking.orgCompiler 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: 0x71aSystem Details- henny-ribeye-2950x-postgres: Anisotropic Filtering: 16x.Kernel Details- henny-ribeye-i73930k-postgres, henny-ribeye-i73930k-vs-2950x-mini-postgres: Transparent Huge Pages: madviseEnvironment 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-postgrespgbench: 1 - 500 - Read Onlypgbench: 1 - 500 - Read Writepgbench: 1 - 500 - Read Only - Average Latencypgbench: 1 - 500 - Read Write - Average Latencyhenny-ribeye-2950x-postgreshenny-ribeye-i73930k-postgreshenny-ribeye-i73930k-vs-2950x-mini-postgres6609585351930213872.5901291.510OpenBenchmarking.org

PostgreSQL

Scaling Factor: 1 - Clients: 500 - Mode: Read Only

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 15Scaling Factor: 1 - Clients: 500 - Mode: Read Onlyhenny-ribeye-2950x-postgreshenny-ribeye-i73930k-vs-2950x-mini-postgres140K280K420K560K700KSE +/- 353.73, N = 3SE +/- 526.08, N = 3660958193021-lpthread -lrt -ldl1. (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.orgTPS, More Is BetterPostgreSQL 15Scaling Factor: 1 - Clients: 500 - Mode: Read Writehenny-ribeye-2950x-postgreshenny-ribeye-i73930k-vs-2950x-mini-postgres120240360480600SE +/- 10.71, N = 6SE +/- 4.94, N = 3535387-lpthread -lrt -ldl1. (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.orgms, Fewer Is BetterPostgreSQL 15Scaling Factor: 1 - Clients: 500 - Mode: Read Only - Average Latencyhenny-ribeye-i73930k-vs-2950x-mini-postgres0.58281.16561.74842.33122.914SE +/- 0.007, N = 32.5901. (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 - Average Latency

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 15Scaling Factor: 1 - Clients: 500 - Mode: Read Write - Average Latencyhenny-ribeye-i73930k-vs-2950x-mini-postgres30060090012001500SE +/- 16.30, N = 31291.511. (CC) gcc options: -fno-strict-aliasing -fwrapv -march=native -mtune=native -pipe -O2 -lpgcommon -lpgport -lpq -lm


Phoronix Test Suite v10.8.5