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.

HTML result view exported from: https://openbenchmarking.org/result/2301084-NE-2301082NE05&rdt.

henny-ribeye-2950x-main-postgresProcessorMotherboardChipsetMemoryDiskGraphicsAudioMonitorNetworkOSKernelDesktopDisplay ServerDisplay DriverOpenGLCompilerFile-SystemScreen Resolutionhenny-ribeye-2950x-main-postgreshenny-ribeye-2950x-main-postgres-realhenny-ribeye-2950x-vs-i73930k-postgres-realAMD Ryzen Threadripper 2950X 16-Core @ 3.50GHz (16 Cores / 32 Threads)ASRock X399M Taichi (P3.80 BIOS)AMD 17h32GB2048GB INTEL SSDPEKNW020T8 + 1000GB Samsung SSD 970 EVO 1TB + 1024GB INTEL SSDPEKNU010TZMSI NVIDIA GeForce RTX 2080 8GBRealtek ALC1220LC49G95T2 x Intel I211 + Intel Dual Band-AC 3168NGWUbuntu 18.044.15.0-201-lowlatency (x86_64)GNOME Shell 3.28.4X Server 1.19.6NVIDIA 415.274.6.0GCC 7.5.0 + Clang 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 ALC892Intel 82579VUbuntu 22.045.15.0-57-lowlatency (x86_64)GCC 11.3.0 + LLVM 14.0.01024x768OpenBenchmarking.orgKernel Details- Transparent Huge Pages: madviseEnvironment Details- 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"Compiler Details- henny-ribeye-2950x-main-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-2950x-main-postgres-real: --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-2950x-vs-i73930k-postgres-real: --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-main-postgres: Scaling Governor: acpi-cpufreq ondemand (Boost: Enabled) - CPU Microcode: 0x800820b- henny-ribeye-2950x-main-postgres-real: Scaling Governor: acpi-cpufreq performance (Boost: Enabled) - CPU Microcode: 0x800820b- henny-ribeye-2950x-vs-i73930k-postgres-real: Scaling Governor: intel_cpufreq schedutil - CPU Microcode: 0x71aSecurity Details- henny-ribeye-2950x-main-postgres: itlb_multihit: Not affected + l1tf: Not affected + mds: Not affected + meltdown: Not affected + mmio_stale_data: 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 STIBP: disabled RSB filling + srbds: Not affected + tsx_async_abort: Not affected - henny-ribeye-2950x-main-postgres-real: itlb_multihit: Not affected + l1tf: Not affected + mds: Not affected + meltdown: Not affected + mmio_stale_data: 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 STIBP: disabled RSB filling + srbds: Not affected + tsx_async_abort: Not affected - henny-ribeye-2950x-vs-i73930k-postgres-real: 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-main-postgrespgbench: 1 - 1 - Read Onlypgbench: 1 - 1 - Read Only - Average Latencypgbench: 1 - 1 - Read Writepgbench: 1 - 1 - Read Write - Average Latencypgbench: 1 - 50 - Read Onlypgbench: 1 - 50 - Read Only - Average Latencypgbench: 1 - 100 - Read Onlypgbench: 1 - 100 - Read Only - Average Latencypgbench: 1 - 50 - Read Writepgbench: 1 - 50 - Read Write - Average Latencypgbench: 1 - 500 - Read Onlypgbench: 1 - 500 - Read Only - Average Latencypgbench: 100 - 1 - Read Onlypgbench: 100 - 1 - Read Only - Average Latencypgbench: 1 - 100 - Read Writepgbench: 1 - 100 - Read Write - Average Latencypgbench: 1 - 500 - Read Writepgbench: 1 - 500 - Read Write - Average Latencypgbench: 100 - 1 - Read Writepgbench: 100 - 1 - Read Write - Average Latencypgbench: 100 - 50 - Read Onlypgbench: 100 - 50 - Read Only - Average Latencypgbench: 1000 - 1 - Read Onlypgbench: 1000 - 1 - Read Only - Average Latencypgbench: 100 - 100 - Read Onlypgbench: 100 - 100 - Read Only - Average Latencypgbench: 100 - 50 - Read Writepgbench: 100 - 50 - Read Write - Average Latencypgbench: 100 - 500 - Read Onlypgbench: 100 - 500 - Read Only - Average Latencypgbench: 1000 - 1 - Read Writepgbench: 1000 - 1 - Read Write - Average Latencypgbench: 1000 - 50 - Read Onlypgbench: 1000 - 50 - Read Only - Average Latencypgbench: 100 - 100 - Read Writepgbench: 100 - 100 - Read Write - Average Latencypgbench: 100 - 500 - Read Writepgbench: 100 - 500 - Read Write - Average Latencypgbench: 1000 - 100 - Read Onlypgbench: 1000 - 100 - Read Only - Average Latencypgbench: 1000 - 50 - Read Writepgbench: 1000 - 50 - Read Write - Average Latencypgbench: 1000 - 500 - Read Onlypgbench: 1000 - 500 - Read Only - Average Latencypgbench: 1000 - 100 - Read Writepgbench: 1000 - 100 - Read Write - Average Latencypgbench: 1000 - 500 - Read Writepgbench: 1000 - 500 - Read Write - Average Latencyhenny-ribeye-2950x-main-postgreshenny-ribeye-2950x-main-postgres-realhenny-ribeye-2950x-vs-i73930k-postgres-real482430.0218071.2397080920.0717556610.13279662.8586492870.770440010.023797125.549625802.7534472.2366615380.075300460.0336967650.144450811.1046207900.8052803.5734692640.107575917.386695071.9444823400.207349414.3112583471.935561017.827841859.401299350.03333640.2971947670.2571961390.510161430.9721925602.597285500.035125679.5934051278.51030940.3231871860.26784960.1181868590.535228112.1921846442.70821460.4661185720.422221354.5201587431.4981120390.893187252.674763546.549194215.1491368536.549OpenBenchmarking.org

PostgreSQL

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

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 15Scaling Factor: 1 - Clients: 1 - Mode: Read Onlyhenny-ribeye-2950x-main-postgres-realhenny-ribeye-2950x-vs-i73930k-postgres-real10K20K30K40K50KSE +/- 231.82, N = 3SE +/- 88.41, N = 34824329935-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: 1 - Mode: Read Only - Average Latency

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 15Scaling Factor: 1 - Clients: 1 - Mode: Read Only - Average Latencyhenny-ribeye-2950x-main-postgres-realhenny-ribeye-2950x-vs-i73930k-postgres-real0.00740.01480.02220.02960.037SE +/- 0.000, N = 3SE +/- 0.000, N = 30.0210.033-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: 1 - Mode: Read Write

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 15Scaling Factor: 1 - Clients: 1 - Mode: Read Writehenny-ribeye-2950x-main-postgres-realhenny-ribeye-2950x-vs-i73930k-postgres-real7001400210028003500SE +/- 3.54, N = 3SE +/- 20.00, N = 38073364-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: 1 - Mode: Read Write - Average Latency

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 15Scaling Factor: 1 - Clients: 1 - Mode: Read Write - Average Latencyhenny-ribeye-2950x-main-postgres-realhenny-ribeye-2950x-vs-i73930k-postgres-real0.27880.55760.83641.11521.394SE +/- 0.006, N = 3SE +/- 0.002, N = 31.2390.297-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: 50 - Mode: Read Only

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 15Scaling Factor: 1 - Clients: 50 - Mode: Read Onlyhenny-ribeye-2950x-main-postgres-realhenny-ribeye-2950x-vs-i73930k-postgres-real150K300K450K600K750KSE +/- 1248.37, N = 3SE +/- 802.81, N = 3708092194767-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: 50 - Mode: Read Only - Average Latency

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 15Scaling Factor: 1 - Clients: 50 - Mode: Read Only - Average Latencyhenny-ribeye-2950x-main-postgres-realhenny-ribeye-2950x-vs-i73930k-postgres-real0.05780.11560.17340.23120.289SE +/- 0.000, N = 3SE +/- 0.001, N = 30.0710.257-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: 100 - Mode: Read Only

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 15Scaling Factor: 1 - Clients: 100 - Mode: Read Onlyhenny-ribeye-2950x-main-postgres-realhenny-ribeye-2950x-vs-i73930k-postgres-real160K320K480K640K800KSE +/- 3319.28, N = 3SE +/- 342.15, N = 3755661196139-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: 100 - Mode: Read Only - Average Latency

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 15Scaling Factor: 1 - Clients: 100 - Mode: Read Only - Average Latencyhenny-ribeye-2950x-main-postgres-realhenny-ribeye-2950x-vs-i73930k-postgres-real0.11480.22960.34440.45920.574SE +/- 0.001, N = 3SE +/- 0.001, N = 30.1320.510-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: 50 - Mode: Read Write

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 15Scaling Factor: 1 - Clients: 50 - Mode: Read Writehenny-ribeye-2950x-main-postgres-realhenny-ribeye-2950x-vs-i73930k-postgres-real30060090012001500SE +/- 7.27, N = 3SE +/- 3.94, N = 37961614-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: 50 - Mode: Read Write - Average Latency

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 15Scaling Factor: 1 - Clients: 50 - Mode: Read Write - Average Latencyhenny-ribeye-2950x-main-postgres-realhenny-ribeye-2950x-vs-i73930k-postgres-real1428425670SE +/- 0.57, N = 3SE +/- 0.08, N = 362.8630.97-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

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 15Scaling Factor: 1 - Clients: 500 - Mode: Read Onlyhenny-ribeye-2950x-main-postgres-realhenny-ribeye-2950x-vs-i73930k-postgres-real140K280K420K560K700KSE +/- 2167.35, N = 3SE +/- 1061.90, N = 3649287192560-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-2950x-main-postgres-realhenny-ribeye-2950x-vs-i73930k-postgres-real0.58431.16861.75292.33722.9215SE +/- 0.003, N = 3SE +/- 0.014, N = 30.7702.597-lpthread -lrt -ldl1. (CC) gcc options: -fno-strict-aliasing -fwrapv -march=native -mtune=native -pipe -O2 -lpgcommon -lpgport -lpq -lm

PostgreSQL

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

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 15Scaling Factor: 100 - Clients: 1 - Mode: Read Onlyhenny-ribeye-2950x-main-postgres-realhenny-ribeye-2950x-vs-i73930k-postgres-real9K18K27K36K45KSE +/- 48.06, N = 3SE +/- 213.88, N = 34400128550-lpthread -lrt -ldl1. (CC) gcc options: -fno-strict-aliasing -fwrapv -march=native -mtune=native -pipe -O2 -lpgcommon -lpgport -lpq -lm

PostgreSQL

Scaling Factor: 100 - Clients: 1 - Mode: Read Only - Average Latency

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 15Scaling Factor: 100 - Clients: 1 - Mode: Read Only - Average Latencyhenny-ribeye-2950x-main-postgres-realhenny-ribeye-2950x-vs-i73930k-postgres-real0.00790.01580.02370.03160.0395SE +/- 0.000, N = 3SE +/- 0.000, N = 30.0230.035-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: 100 - Mode: Read Write

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 15Scaling Factor: 1 - Clients: 100 - Mode: Read Writehenny-ribeye-2950x-main-postgres-realhenny-ribeye-2950x-vs-i73930k-postgres-real30060090012001500SE +/- 1.44, N = 3SE +/- 7.16, N = 37971256-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: 100 - Mode: Read Write - Average Latency

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 15Scaling Factor: 1 - Clients: 100 - Mode: Read Write - Average Latencyhenny-ribeye-2950x-main-postgres-realhenny-ribeye-2950x-vs-i73930k-postgres-real306090120150SE +/- 0.23, N = 3SE +/- 0.45, N = 3125.5579.59-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-main-postgres-realhenny-ribeye-2950x-vs-i73930k-postgres-real130260390520650SE +/- 9.62, N = 12SE +/- 27.98, N = 9625405-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 - Average Latency

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 15Scaling Factor: 1 - Clients: 500 - Mode: Read Write - Average Latencyhenny-ribeye-2950x-main-postgres-realhenny-ribeye-2950x-vs-i73930k-postgres-real30060090012001500SE +/- 12.50, N = 12SE +/- 83.33, N = 9802.751278.51-lpthread -lrt -ldl1. (CC) gcc options: -fno-strict-aliasing -fwrapv -march=native -mtune=native -pipe -O2 -lpgcommon -lpgport -lpq -lm

PostgreSQL

Scaling Factor: 100 - Clients: 1 - Mode: Read Write

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 15Scaling Factor: 100 - Clients: 1 - Mode: Read Writehenny-ribeye-2950x-main-postgres-realhenny-ribeye-2950x-vs-i73930k-postgres-real7001400210028003500SE +/- 4.37, N = 3SE +/- 20.94, N = 34473094-lpthread -lrt -ldl1. (CC) gcc options: -fno-strict-aliasing -fwrapv -march=native -mtune=native -pipe -O2 -lpgcommon -lpgport -lpq -lm

PostgreSQL

Scaling Factor: 100 - Clients: 1 - Mode: Read Write - Average Latency

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 15Scaling Factor: 100 - Clients: 1 - Mode: Read Write - Average Latencyhenny-ribeye-2950x-main-postgres-realhenny-ribeye-2950x-vs-i73930k-postgres-real0.50311.00621.50932.01242.5155SE +/- 0.022, N = 3SE +/- 0.002, N = 32.2360.323-lpthread -lrt -ldl1. (CC) gcc options: -fno-strict-aliasing -fwrapv -march=native -mtune=native -pipe -O2 -lpgcommon -lpgport -lpq -lm

PostgreSQL

Scaling Factor: 100 - Clients: 50 - Mode: Read Only

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 15Scaling Factor: 100 - Clients: 50 - Mode: Read Onlyhenny-ribeye-2950x-main-postgres-realhenny-ribeye-2950x-vs-i73930k-postgres-real140K280K420K560K700KSE +/- 2997.94, N = 3SE +/- 261.66, N = 3661538187186-lpthread -lrt -ldl1. (CC) gcc options: -fno-strict-aliasing -fwrapv -march=native -mtune=native -pipe -O2 -lpgcommon -lpgport -lpq -lm

PostgreSQL

Scaling Factor: 100 - Clients: 50 - Mode: Read Only - Average Latency

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 15Scaling Factor: 100 - Clients: 50 - Mode: Read Only - Average Latencyhenny-ribeye-2950x-main-postgres-realhenny-ribeye-2950x-vs-i73930k-postgres-real0.06010.12020.18030.24040.3005SE +/- 0.000, N = 3SE +/- 0.000, N = 30.0750.267-lpthread -lrt -ldl1. (CC) gcc options: -fno-strict-aliasing -fwrapv -march=native -mtune=native -pipe -O2 -lpgcommon -lpgport -lpq -lm

PostgreSQL

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

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 15Scaling Factor: 1000 - Clients: 1 - Mode: Read Onlyhenny-ribeye-2950x-main-postgres-realhenny-ribeye-2950x-vs-i73930k-postgres-real6K12K18K24K30KSE +/- 869.78, N = 9SE +/- 105.07, N = 3300468496-lpthread -lrt -ldl1. (CC) gcc options: -fno-strict-aliasing -fwrapv -march=native -mtune=native -pipe -O2 -lpgcommon -lpgport -lpq -lm

PostgreSQL

Scaling Factor: 1000 - Clients: 1 - Mode: Read Only - Average Latency

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 15Scaling Factor: 1000 - Clients: 1 - Mode: Read Only - Average Latencyhenny-ribeye-2950x-main-postgres-realhenny-ribeye-2950x-vs-i73930k-postgres-real0.02660.05320.07980.10640.133SE +/- 0.001, N = 9SE +/- 0.002, N = 30.0330.118-lpthread -lrt -ldl1. (CC) gcc options: -fno-strict-aliasing -fwrapv -march=native -mtune=native -pipe -O2 -lpgcommon -lpgport -lpq -lm

PostgreSQL

Scaling Factor: 100 - Clients: 100 - Mode: Read Only

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 15Scaling Factor: 100 - Clients: 100 - Mode: Read Onlyhenny-ribeye-2950x-main-postgres-realhenny-ribeye-2950x-vs-i73930k-postgres-real150K300K450K600K750KSE +/- 3023.40, N = 3SE +/- 435.81, N = 3696765186859-lpthread -lrt -ldl1. (CC) gcc options: -fno-strict-aliasing -fwrapv -march=native -mtune=native -pipe -O2 -lpgcommon -lpgport -lpq -lm

PostgreSQL

Scaling Factor: 100 - Clients: 100 - Mode: Read Only - Average Latency

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 15Scaling Factor: 100 - Clients: 100 - Mode: Read Only - Average Latencyhenny-ribeye-2950x-main-postgres-realhenny-ribeye-2950x-vs-i73930k-postgres-real0.12040.24080.36120.48160.602SE +/- 0.001, N = 3SE +/- 0.001, N = 30.1440.535-lpthread -lrt -ldl1. (CC) gcc options: -fno-strict-aliasing -fwrapv -march=native -mtune=native -pipe -O2 -lpgcommon -lpgport -lpq -lm

PostgreSQL

Scaling Factor: 100 - Clients: 50 - Mode: Read Write

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 15Scaling Factor: 100 - Clients: 50 - Mode: Read Writehenny-ribeye-2950x-main-postgres-realhenny-ribeye-2950x-vs-i73930k-postgres-real5K10K15K20K25KSE +/- 43.75, N = 12SE +/- 97.11, N = 3450822811-lpthread -lrt -ldl1. (CC) gcc options: -fno-strict-aliasing -fwrapv -march=native -mtune=native -pipe -O2 -lpgcommon -lpgport -lpq -lm

PostgreSQL

Scaling Factor: 100 - Clients: 50 - Mode: Read Write - Average Latency

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 15Scaling Factor: 100 - Clients: 50 - Mode: Read Write - Average Latencyhenny-ribeye-2950x-main-postgres-realhenny-ribeye-2950x-vs-i73930k-postgres-real3691215SE +/- 0.107, N = 12SE +/- 0.009, N = 311.1042.192-lpthread -lrt -ldl1. (CC) gcc options: -fno-strict-aliasing -fwrapv -march=native -mtune=native -pipe -O2 -lpgcommon -lpgport -lpq -lm

PostgreSQL

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

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 15Scaling Factor: 100 - Clients: 500 - Mode: Read Onlyhenny-ribeye-2950x-main-postgres-realhenny-ribeye-2950x-vs-i73930k-postgres-real130K260K390K520K650KSE +/- 1795.20, N = 3SE +/- 891.97, N = 3620790184644-lpthread -lrt -ldl1. (CC) gcc options: -fno-strict-aliasing -fwrapv -march=native -mtune=native -pipe -O2 -lpgcommon -lpgport -lpq -lm

PostgreSQL

Scaling Factor: 100 - Clients: 500 - Mode: Read Only - Average Latency

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 15Scaling Factor: 100 - Clients: 500 - Mode: Read Only - Average Latencyhenny-ribeye-2950x-main-postgres-realhenny-ribeye-2950x-vs-i73930k-postgres-real0.60931.21861.82792.43723.0465SE +/- 0.002, N = 3SE +/- 0.013, N = 30.8052.708-lpthread -lrt -ldl1. (CC) gcc options: -fno-strict-aliasing -fwrapv -march=native -mtune=native -pipe -O2 -lpgcommon -lpgport -lpq -lm

PostgreSQL

Scaling Factor: 1000 - Clients: 1 - Mode: Read Write

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 15Scaling Factor: 1000 - Clients: 1 - Mode: Read Writehenny-ribeye-2950x-main-postgres-realhenny-ribeye-2950x-vs-i73930k-postgres-real5001000150020002500SE +/- 0.86, N = 3SE +/- 1.78, N = 32802146-lpthread -lrt -ldl1. (CC) gcc options: -fno-strict-aliasing -fwrapv -march=native -mtune=native -pipe -O2 -lpgcommon -lpgport -lpq -lm

PostgreSQL

Scaling Factor: 1000 - Clients: 1 - Mode: Read Write - Average Latency

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 15Scaling Factor: 1000 - Clients: 1 - Mode: Read Write - Average Latencyhenny-ribeye-2950x-main-postgres-realhenny-ribeye-2950x-vs-i73930k-postgres-real0.80391.60782.41173.21564.0195SE +/- 0.011, N = 3SE +/- 0.001, N = 33.5730.466-lpthread -lrt -ldl1. (CC) gcc options: -fno-strict-aliasing -fwrapv -march=native -mtune=native -pipe -O2 -lpgcommon -lpgport -lpq -lm

PostgreSQL

Scaling Factor: 1000 - Clients: 50 - Mode: Read Only

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 15Scaling Factor: 1000 - Clients: 50 - Mode: Read Onlyhenny-ribeye-2950x-main-postgres-realhenny-ribeye-2950x-vs-i73930k-postgres-real100K200K300K400K500KSE +/- 734.31, N = 3SE +/- 146.60, N = 3469264118572-lpthread -lrt -ldl1. (CC) gcc options: -fno-strict-aliasing -fwrapv -march=native -mtune=native -pipe -O2 -lpgcommon -lpgport -lpq -lm

PostgreSQL

Scaling Factor: 1000 - Clients: 50 - Mode: Read Only - Average Latency

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 15Scaling Factor: 1000 - Clients: 50 - Mode: Read Only - Average Latencyhenny-ribeye-2950x-main-postgres-realhenny-ribeye-2950x-vs-i73930k-postgres-real0.0950.190.2850.380.475SE +/- 0.000, N = 3SE +/- 0.001, N = 30.1070.422-lpthread -lrt -ldl1. (CC) gcc options: -fno-strict-aliasing -fwrapv -march=native -mtune=native -pipe -O2 -lpgcommon -lpgport -lpq -lm

PostgreSQL

Scaling Factor: 100 - Clients: 100 - Mode: Read Write

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 15Scaling Factor: 100 - Clients: 100 - Mode: Read Writehenny-ribeye-2950x-main-postgres-realhenny-ribeye-2950x-vs-i73930k-postgres-real5K10K15K20K25KSE +/- 61.76, N = 12SE +/- 210.47, N = 6575922135-lpthread -lrt -ldl1. (CC) gcc options: -fno-strict-aliasing -fwrapv -march=native -mtune=native -pipe -O2 -lpgcommon -lpgport -lpq -lm

PostgreSQL

Scaling Factor: 100 - Clients: 100 - Mode: Read Write - Average Latency

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 15Scaling Factor: 100 - Clients: 100 - Mode: Read Write - Average Latencyhenny-ribeye-2950x-main-postgres-realhenny-ribeye-2950x-vs-i73930k-postgres-real48121620SE +/- 0.186, N = 12SE +/- 0.045, N = 617.3864.520-lpthread -lrt -ldl1. (CC) gcc options: -fno-strict-aliasing -fwrapv -march=native -mtune=native -pipe -O2 -lpgcommon -lpgport -lpq -lm

PostgreSQL

Scaling Factor: 100 - Clients: 500 - Mode: Read Write

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 15Scaling Factor: 100 - Clients: 500 - Mode: Read Writehenny-ribeye-2950x-main-postgres-realhenny-ribeye-2950x-vs-i73930k-postgres-real3K6K9K12K15KSE +/- 18.93, N = 3SE +/- 49.31, N = 3695015874-lpthread -lrt -ldl1. (CC) gcc options: -fno-strict-aliasing -fwrapv -march=native -mtune=native -pipe -O2 -lpgcommon -lpgport -lpq -lm

PostgreSQL

Scaling Factor: 100 - Clients: 500 - Mode: Read Write - Average Latency

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 15Scaling Factor: 100 - Clients: 500 - Mode: Read Write - Average Latencyhenny-ribeye-2950x-main-postgres-realhenny-ribeye-2950x-vs-i73930k-postgres-real1632486480SE +/- 0.20, N = 3SE +/- 0.10, N = 371.9431.50-lpthread -lrt -ldl1. (CC) gcc options: -fno-strict-aliasing -fwrapv -march=native -mtune=native -pipe -O2 -lpgcommon -lpgport -lpq -lm

PostgreSQL

Scaling Factor: 1000 - Clients: 100 - Mode: Read Only

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 15Scaling Factor: 1000 - Clients: 100 - Mode: Read Onlyhenny-ribeye-2950x-main-postgres-realhenny-ribeye-2950x-vs-i73930k-postgres-real100K200K300K400K500KSE +/- 6897.43, N = 3SE +/- 317.74, N = 3482340112039-lpthread -lrt -ldl1. (CC) gcc options: -fno-strict-aliasing -fwrapv -march=native -mtune=native -pipe -O2 -lpgcommon -lpgport -lpq -lm

PostgreSQL

Scaling Factor: 1000 - Clients: 100 - Mode: Read Only - Average Latency

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 15Scaling Factor: 1000 - Clients: 100 - Mode: Read Only - Average Latencyhenny-ribeye-2950x-main-postgres-realhenny-ribeye-2950x-vs-i73930k-postgres-real0.20090.40180.60270.80361.0045SE +/- 0.003, N = 3SE +/- 0.002, N = 30.2070.893-lpthread -lrt -ldl1. (CC) gcc options: -fno-strict-aliasing -fwrapv -march=native -mtune=native -pipe -O2 -lpgcommon -lpgport -lpq -lm

PostgreSQL

Scaling Factor: 1000 - Clients: 50 - Mode: Read Write

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 15Scaling Factor: 1000 - Clients: 50 - Mode: Read Writehenny-ribeye-2950x-main-postgres-realhenny-ribeye-2950x-vs-i73930k-postgres-real4K8K12K16K20KSE +/- 15.78, N = 3SE +/- 241.47, N = 9349418725-lpthread -lrt -ldl1. (CC) gcc options: -fno-strict-aliasing -fwrapv -march=native -mtune=native -pipe -O2 -lpgcommon -lpgport -lpq -lm

PostgreSQL

Scaling Factor: 1000 - Clients: 50 - Mode: Read Write - Average Latency

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 15Scaling Factor: 1000 - Clients: 50 - Mode: Read Write - Average Latencyhenny-ribeye-2950x-main-postgres-realhenny-ribeye-2950x-vs-i73930k-postgres-real48121620SE +/- 0.064, N = 3SE +/- 0.035, N = 914.3112.674-lpthread -lrt -ldl1. (CC) gcc options: -fno-strict-aliasing -fwrapv -march=native -mtune=native -pipe -O2 -lpgcommon -lpgport -lpq -lm

PostgreSQL

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

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 15Scaling Factor: 1000 - Clients: 500 - Mode: Read Onlyhenny-ribeye-2950x-main-postgres-realhenny-ribeye-2950x-vs-i73930k-postgres-real60K120K180K240K300KSE +/- 642.74, N = 3SE +/- 593.17, N = 325834776354-lpthread -lrt -ldl1. (CC) gcc options: -fno-strict-aliasing -fwrapv -march=native -mtune=native -pipe -O2 -lpgcommon -lpgport -lpq -lm

PostgreSQL

Scaling Factor: 1000 - Clients: 500 - Mode: Read Only - Average Latency

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 15Scaling Factor: 1000 - Clients: 500 - Mode: Read Only - Average Latencyhenny-ribeye-2950x-main-postgres-realhenny-ribeye-2950x-vs-i73930k-postgres-real246810SE +/- 0.005, N = 3SE +/- 0.051, N = 31.9356.549-lpthread -lrt -ldl1. (CC) gcc options: -fno-strict-aliasing -fwrapv -march=native -mtune=native -pipe -O2 -lpgcommon -lpgport -lpq -lm

PostgreSQL

Scaling Factor: 1000 - Clients: 100 - Mode: Read Write

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 15Scaling Factor: 1000 - Clients: 100 - Mode: Read Writehenny-ribeye-2950x-main-postgres-realhenny-ribeye-2950x-vs-i73930k-postgres-real4K8K12K16K20KSE +/- 35.99, N = 3SE +/- 138.72, N = 3561019421-lpthread -lrt -ldl1. (CC) gcc options: -fno-strict-aliasing -fwrapv -march=native -mtune=native -pipe -O2 -lpgcommon -lpgport -lpq -lm

PostgreSQL

Scaling Factor: 1000 - Clients: 100 - Mode: Read Write - Average Latency

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 15Scaling Factor: 1000 - Clients: 100 - Mode: Read Write - Average Latencyhenny-ribeye-2950x-main-postgres-realhenny-ribeye-2950x-vs-i73930k-postgres-real48121620SE +/- 0.115, N = 3SE +/- 0.037, N = 317.8275.149-lpthread -lrt -ldl1. (CC) gcc options: -fno-strict-aliasing -fwrapv -march=native -mtune=native -pipe -O2 -lpgcommon -lpgport -lpq -lm

PostgreSQL

Scaling Factor: 1000 - Clients: 500 - Mode: Read Write

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 15Scaling Factor: 1000 - Clients: 500 - Mode: Read Writehenny-ribeye-2950x-main-postgres-realhenny-ribeye-2950x-vs-i73930k-postgres-real3K6K9K12K15KSE +/- 46.45, N = 3SE +/- 167.76, N = 3841813685-lpthread -lrt -ldl1. (CC) gcc options: -fno-strict-aliasing -fwrapv -march=native -mtune=native -pipe -O2 -lpgcommon -lpgport -lpq -lm

PostgreSQL

Scaling Factor: 1000 - Clients: 500 - Mode: Read Write - Average Latency

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 15Scaling Factor: 1000 - Clients: 500 - Mode: Read Write - Average Latencyhenny-ribeye-2950x-main-postgres-realhenny-ribeye-2950x-vs-i73930k-postgres-real1326395265SE +/- 0.33, N = 3SE +/- 0.45, N = 359.4036.55-lpthread -lrt -ldl1. (CC) gcc options: -fno-strict-aliasing -fwrapv -march=native -mtune=native -pipe -O2 -lpgcommon -lpgport -lpq -lm


Phoronix Test Suite v10.8.4