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&gru .
henny-ribeye-2950x-main-postgres Processor Motherboard Chipset Memory Disk Graphics Audio Monitor Network OS Kernel Desktop Display Server Display Driver OpenGL Compiler File-System Screen Resolution henny-ribeye-2950x-main-postgres henny-ribeye-2950x-main-postgres-real henny-ribeye-2950x-vs-i73930k-postgres-real AMD Ryzen Threadripper 2950X 16-Core @ 3.50GHz (16 Cores / 32 Threads) ASRock X399M Taichi (P3.80 BIOS) AMD 17h 32GB 2048GB INTEL SSDPEKNW020T8 + 1000GB Samsung SSD 970 EVO 1TB + 1024GB INTEL SSDPEKNU010TZ MSI NVIDIA GeForce RTX 2080 8GB Realtek ALC1220 LC49G95T 2 x Intel I211 + Intel Dual Band-AC 3168NGW Ubuntu 18.04 4.15.0-201-lowlatency (x86_64) GNOME Shell 3.28.4 X Server 1.19.6 NVIDIA 415.27 4.6.0 GCC 7.5.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 Intel 82579V Ubuntu 22.04 5.15.0-57-lowlatency (x86_64) GCC 11.3.0 + LLVM 14.0.0 1024x768 OpenBenchmarking.org Kernel Details - Transparent Huge Pages: madvise Environment 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: 0x71a Security 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-postgres pgbench: 1 - 1 - Read Only pgbench: 1 - 1 - Read Write pgbench: 1 - 50 - Read Only pgbench: 1 - 100 - Read Only pgbench: 1 - 50 - Read Write pgbench: 1 - 500 - Read Only pgbench: 100 - 1 - Read Only pgbench: 1 - 100 - Read Write pgbench: 1 - 500 - Read Write pgbench: 100 - 1 - Read Write pgbench: 100 - 50 - Read Only pgbench: 1000 - 1 - Read Only pgbench: 100 - 100 - Read Only pgbench: 100 - 50 - Read Write pgbench: 100 - 500 - Read Only pgbench: 1000 - 1 - Read Write pgbench: 1000 - 50 - Read Only pgbench: 100 - 100 - Read Write pgbench: 100 - 500 - Read Write pgbench: 1000 - 100 - Read Only pgbench: 1000 - 50 - Read Write pgbench: 1000 - 500 - Read Only pgbench: 1000 - 100 - Read Write pgbench: 1000 - 500 - Read Write pgbench: 1 - 1 - Read Only - Average Latency pgbench: 1 - 1 - Read Write - Average Latency pgbench: 1 - 50 - Read Only - Average Latency pgbench: 1 - 100 - Read Only - Average Latency pgbench: 1 - 50 - Read Write - Average Latency pgbench: 1 - 500 - Read Only - Average Latency pgbench: 100 - 1 - Read Only - Average Latency pgbench: 1 - 100 - Read Write - Average Latency pgbench: 1 - 500 - Read Write - Average Latency pgbench: 100 - 1 - Read Write - Average Latency pgbench: 100 - 50 - Read Only - Average Latency pgbench: 1000 - 1 - Read Only - Average Latency pgbench: 100 - 100 - Read Only - Average Latency pgbench: 100 - 50 - Read Write - Average Latency pgbench: 100 - 500 - Read Only - Average Latency pgbench: 1000 - 1 - Read Write - Average Latency pgbench: 1000 - 50 - Read Only - Average Latency pgbench: 100 - 100 - Read Write - Average Latency pgbench: 100 - 500 - Read Write - Average Latency pgbench: 1000 - 100 - Read Only - Average Latency pgbench: 1000 - 50 - Read Write - Average Latency pgbench: 1000 - 500 - Read Only - Average Latency pgbench: 1000 - 100 - Read Write - Average Latency pgbench: 1000 - 500 - Read Write - Average Latency henny-ribeye-2950x-main-postgres henny-ribeye-2950x-main-postgres-real henny-ribeye-2950x-vs-i73930k-postgres-real 48243 807 708092 755661 796 649287 44001 797 625 447 661538 30046 696765 4508 620790 280 469264 5759 6950 482340 3494 258347 5610 8418 0.021 1.239 0.071 0.132 62.858 0.770 0.023 125.549 802.753 2.236 0.075 0.033 0.144 11.104 0.805 3.573 0.107 17.386 71.944 0.207 14.311 1.935 17.827 59.401 29935 3364 194767 196139 1614 192560 28550 1256 405 3094 187186 8496 186859 22811 184644 2146 118572 22135 15874 112039 18725 76354 19421 13685 0.033 0.297 0.257 0.510 30.972 2.597 0.035 79.593 1278.510 0.323 0.267 0.118 0.535 2.192 2.708 0.466 0.422 4.520 31.498 0.893 2.674 6.549 5.149 36.549 OpenBenchmarking.org
PostgreSQL Scaling Factor: 1 - Clients: 1 - Mode: Read Only OpenBenchmarking.org TPS, More Is Better PostgreSQL 15 Scaling Factor: 1 - Clients: 1 - Mode: Read Only henny-ribeye-2950x-main-postgres-real henny-ribeye-2950x-vs-i73930k-postgres-real 10K 20K 30K 40K 50K SE +/- 231.82, N = 3 SE +/- 88.41, N = 3 48243 29935 -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: 1 - Mode: Read Write OpenBenchmarking.org TPS, More Is Better PostgreSQL 15 Scaling Factor: 1 - Clients: 1 - Mode: Read Write henny-ribeye-2950x-main-postgres-real henny-ribeye-2950x-vs-i73930k-postgres-real 700 1400 2100 2800 3500 SE +/- 3.54, N = 3 SE +/- 20.00, N = 3 807 3364 -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: 50 - Mode: Read Only OpenBenchmarking.org TPS, More Is Better PostgreSQL 15 Scaling Factor: 1 - Clients: 50 - Mode: Read Only henny-ribeye-2950x-main-postgres-real henny-ribeye-2950x-vs-i73930k-postgres-real 150K 300K 450K 600K 750K SE +/- 1248.37, N = 3 SE +/- 802.81, N = 3 708092 194767 -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: 100 - Mode: Read Only OpenBenchmarking.org TPS, More Is Better PostgreSQL 15 Scaling Factor: 1 - Clients: 100 - Mode: Read Only henny-ribeye-2950x-main-postgres-real henny-ribeye-2950x-vs-i73930k-postgres-real 160K 320K 480K 640K 800K SE +/- 3319.28, N = 3 SE +/- 342.15, N = 3 755661 196139 -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: 50 - Mode: Read Write OpenBenchmarking.org TPS, More Is Better PostgreSQL 15 Scaling Factor: 1 - Clients: 50 - Mode: Read Write henny-ribeye-2950x-main-postgres-real henny-ribeye-2950x-vs-i73930k-postgres-real 300 600 900 1200 1500 SE +/- 7.27, N = 3 SE +/- 3.94, N = 3 796 1614 -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 OpenBenchmarking.org TPS, More Is Better PostgreSQL 15 Scaling Factor: 1 - Clients: 500 - Mode: Read Only henny-ribeye-2950x-main-postgres-real henny-ribeye-2950x-vs-i73930k-postgres-real 140K 280K 420K 560K 700K SE +/- 2167.35, N = 3 SE +/- 1061.90, N = 3 649287 192560 -lpthread -lrt -ldl 1. (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.org TPS, More Is Better PostgreSQL 15 Scaling Factor: 100 - Clients: 1 - Mode: Read Only henny-ribeye-2950x-main-postgres-real henny-ribeye-2950x-vs-i73930k-postgres-real 9K 18K 27K 36K 45K SE +/- 48.06, N = 3 SE +/- 213.88, N = 3 44001 28550 -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: 100 - Mode: Read Write OpenBenchmarking.org TPS, More Is Better PostgreSQL 15 Scaling Factor: 1 - Clients: 100 - Mode: Read Write henny-ribeye-2950x-main-postgres-real henny-ribeye-2950x-vs-i73930k-postgres-real 300 600 900 1200 1500 SE +/- 1.44, N = 3 SE +/- 7.16, N = 3 797 1256 -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 Write OpenBenchmarking.org TPS, More Is Better PostgreSQL 15 Scaling Factor: 1 - Clients: 500 - Mode: Read Write henny-ribeye-2950x-main-postgres-real henny-ribeye-2950x-vs-i73930k-postgres-real 130 260 390 520 650 SE +/- 9.62, N = 12 SE +/- 27.98, N = 9 625 405 -lpthread -lrt -ldl 1. (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.org TPS, More Is Better PostgreSQL 15 Scaling Factor: 100 - Clients: 1 - Mode: Read Write henny-ribeye-2950x-main-postgres-real henny-ribeye-2950x-vs-i73930k-postgres-real 700 1400 2100 2800 3500 SE +/- 4.37, N = 3 SE +/- 20.94, N = 3 447 3094 -lpthread -lrt -ldl 1. (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.org TPS, More Is Better PostgreSQL 15 Scaling Factor: 100 - Clients: 50 - Mode: Read Only henny-ribeye-2950x-main-postgres-real henny-ribeye-2950x-vs-i73930k-postgres-real 140K 280K 420K 560K 700K SE +/- 2997.94, N = 3 SE +/- 261.66, N = 3 661538 187186 -lpthread -lrt -ldl 1. (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.org TPS, More Is Better PostgreSQL 15 Scaling Factor: 1000 - Clients: 1 - Mode: Read Only henny-ribeye-2950x-main-postgres-real henny-ribeye-2950x-vs-i73930k-postgres-real 6K 12K 18K 24K 30K SE +/- 869.78, N = 9 SE +/- 105.07, N = 3 30046 8496 -lpthread -lrt -ldl 1. (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.org TPS, More Is Better PostgreSQL 15 Scaling Factor: 100 - Clients: 100 - Mode: Read Only henny-ribeye-2950x-main-postgres-real henny-ribeye-2950x-vs-i73930k-postgres-real 150K 300K 450K 600K 750K SE +/- 3023.40, N = 3 SE +/- 435.81, N = 3 696765 186859 -lpthread -lrt -ldl 1. (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.org TPS, More Is Better PostgreSQL 15 Scaling Factor: 100 - Clients: 50 - Mode: Read Write henny-ribeye-2950x-main-postgres-real henny-ribeye-2950x-vs-i73930k-postgres-real 5K 10K 15K 20K 25K SE +/- 43.75, N = 12 SE +/- 97.11, N = 3 4508 22811 -lpthread -lrt -ldl 1. (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.org TPS, More Is Better PostgreSQL 15 Scaling Factor: 100 - Clients: 500 - Mode: Read Only henny-ribeye-2950x-main-postgres-real henny-ribeye-2950x-vs-i73930k-postgres-real 130K 260K 390K 520K 650K SE +/- 1795.20, N = 3 SE +/- 891.97, N = 3 620790 184644 -lpthread -lrt -ldl 1. (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.org TPS, More Is Better PostgreSQL 15 Scaling Factor: 1000 - Clients: 1 - Mode: Read Write henny-ribeye-2950x-main-postgres-real henny-ribeye-2950x-vs-i73930k-postgres-real 500 1000 1500 2000 2500 SE +/- 0.86, N = 3 SE +/- 1.78, N = 3 280 2146 -lpthread -lrt -ldl 1. (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.org TPS, More Is Better PostgreSQL 15 Scaling Factor: 1000 - Clients: 50 - Mode: Read Only henny-ribeye-2950x-main-postgres-real henny-ribeye-2950x-vs-i73930k-postgres-real 100K 200K 300K 400K 500K SE +/- 734.31, N = 3 SE +/- 146.60, N = 3 469264 118572 -lpthread -lrt -ldl 1. (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.org TPS, More Is Better PostgreSQL 15 Scaling Factor: 100 - Clients: 100 - Mode: Read Write henny-ribeye-2950x-main-postgres-real henny-ribeye-2950x-vs-i73930k-postgres-real 5K 10K 15K 20K 25K SE +/- 61.76, N = 12 SE +/- 210.47, N = 6 5759 22135 -lpthread -lrt -ldl 1. (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.org TPS, More Is Better PostgreSQL 15 Scaling Factor: 100 - Clients: 500 - Mode: Read Write henny-ribeye-2950x-main-postgres-real henny-ribeye-2950x-vs-i73930k-postgres-real 3K 6K 9K 12K 15K SE +/- 18.93, N = 3 SE +/- 49.31, N = 3 6950 15874 -lpthread -lrt -ldl 1. (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.org TPS, More Is Better PostgreSQL 15 Scaling Factor: 1000 - Clients: 100 - Mode: Read Only henny-ribeye-2950x-main-postgres-real henny-ribeye-2950x-vs-i73930k-postgres-real 100K 200K 300K 400K 500K SE +/- 6897.43, N = 3 SE +/- 317.74, N = 3 482340 112039 -lpthread -lrt -ldl 1. (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.org TPS, More Is Better PostgreSQL 15 Scaling Factor: 1000 - Clients: 50 - Mode: Read Write henny-ribeye-2950x-main-postgres-real henny-ribeye-2950x-vs-i73930k-postgres-real 4K 8K 12K 16K 20K SE +/- 15.78, N = 3 SE +/- 241.47, N = 9 3494 18725 -lpthread -lrt -ldl 1. (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.org TPS, More Is Better PostgreSQL 15 Scaling Factor: 1000 - Clients: 500 - Mode: Read Only henny-ribeye-2950x-main-postgres-real henny-ribeye-2950x-vs-i73930k-postgres-real 60K 120K 180K 240K 300K SE +/- 642.74, N = 3 SE +/- 593.17, N = 3 258347 76354 -lpthread -lrt -ldl 1. (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.org TPS, More Is Better PostgreSQL 15 Scaling Factor: 1000 - Clients: 100 - Mode: Read Write henny-ribeye-2950x-main-postgres-real henny-ribeye-2950x-vs-i73930k-postgres-real 4K 8K 12K 16K 20K SE +/- 35.99, N = 3 SE +/- 138.72, N = 3 5610 19421 -lpthread -lrt -ldl 1. (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.org TPS, More Is Better PostgreSQL 15 Scaling Factor: 1000 - Clients: 500 - Mode: Read Write henny-ribeye-2950x-main-postgres-real henny-ribeye-2950x-vs-i73930k-postgres-real 3K 6K 9K 12K 15K SE +/- 46.45, N = 3 SE +/- 167.76, N = 3 8418 13685 -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: 1 - Mode: Read Only - Average Latency OpenBenchmarking.org ms, Fewer Is Better PostgreSQL 15 Scaling Factor: 1 - Clients: 1 - Mode: Read Only - Average Latency henny-ribeye-2950x-main-postgres-real henny-ribeye-2950x-vs-i73930k-postgres-real 0.0074 0.0148 0.0222 0.0296 0.037 SE +/- 0.000, N = 3 SE +/- 0.000, N = 3 0.021 0.033 -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: 1 - Mode: Read Write - Average Latency OpenBenchmarking.org ms, Fewer Is Better PostgreSQL 15 Scaling Factor: 1 - Clients: 1 - Mode: Read Write - Average Latency henny-ribeye-2950x-main-postgres-real henny-ribeye-2950x-vs-i73930k-postgres-real 0.2788 0.5576 0.8364 1.1152 1.394 SE +/- 0.006, N = 3 SE +/- 0.002, N = 3 1.239 0.297 -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: 50 - Mode: Read Only - Average Latency OpenBenchmarking.org ms, Fewer Is Better PostgreSQL 15 Scaling Factor: 1 - Clients: 50 - Mode: Read Only - Average Latency henny-ribeye-2950x-main-postgres-real henny-ribeye-2950x-vs-i73930k-postgres-real 0.0578 0.1156 0.1734 0.2312 0.289 SE +/- 0.000, N = 3 SE +/- 0.001, N = 3 0.071 0.257 -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: 100 - Mode: Read Only - Average Latency OpenBenchmarking.org ms, Fewer Is Better PostgreSQL 15 Scaling Factor: 1 - Clients: 100 - Mode: Read Only - Average Latency henny-ribeye-2950x-main-postgres-real henny-ribeye-2950x-vs-i73930k-postgres-real 0.1148 0.2296 0.3444 0.4592 0.574 SE +/- 0.001, N = 3 SE +/- 0.001, N = 3 0.132 0.510 -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: 50 - Mode: Read Write - Average Latency OpenBenchmarking.org ms, Fewer Is Better PostgreSQL 15 Scaling Factor: 1 - Clients: 50 - Mode: Read Write - Average Latency henny-ribeye-2950x-main-postgres-real henny-ribeye-2950x-vs-i73930k-postgres-real 14 28 42 56 70 SE +/- 0.57, N = 3 SE +/- 0.08, N = 3 62.86 30.97 -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-2950x-main-postgres-real henny-ribeye-2950x-vs-i73930k-postgres-real 0.5843 1.1686 1.7529 2.3372 2.9215 SE +/- 0.003, N = 3 SE +/- 0.014, N = 3 0.770 2.597 -lpthread -lrt -ldl 1. (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.org ms, Fewer Is Better PostgreSQL 15 Scaling Factor: 100 - Clients: 1 - Mode: Read Only - Average Latency henny-ribeye-2950x-main-postgres-real henny-ribeye-2950x-vs-i73930k-postgres-real 0.0079 0.0158 0.0237 0.0316 0.0395 SE +/- 0.000, N = 3 SE +/- 0.000, N = 3 0.023 0.035 -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: 100 - Mode: Read Write - Average Latency OpenBenchmarking.org ms, Fewer Is Better PostgreSQL 15 Scaling Factor: 1 - Clients: 100 - Mode: Read Write - Average Latency henny-ribeye-2950x-main-postgres-real henny-ribeye-2950x-vs-i73930k-postgres-real 30 60 90 120 150 SE +/- 0.23, N = 3 SE +/- 0.45, N = 3 125.55 79.59 -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 Write - Average Latency OpenBenchmarking.org ms, Fewer Is Better PostgreSQL 15 Scaling Factor: 1 - Clients: 500 - Mode: Read Write - Average Latency henny-ribeye-2950x-main-postgres-real henny-ribeye-2950x-vs-i73930k-postgres-real 300 600 900 1200 1500 SE +/- 12.50, N = 12 SE +/- 83.33, N = 9 802.75 1278.51 -lpthread -lrt -ldl 1. (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.org ms, Fewer Is Better PostgreSQL 15 Scaling Factor: 100 - Clients: 1 - Mode: Read Write - Average Latency henny-ribeye-2950x-main-postgres-real henny-ribeye-2950x-vs-i73930k-postgres-real 0.5031 1.0062 1.5093 2.0124 2.5155 SE +/- 0.022, N = 3 SE +/- 0.002, N = 3 2.236 0.323 -lpthread -lrt -ldl 1. (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.org ms, Fewer Is Better PostgreSQL 15 Scaling Factor: 100 - Clients: 50 - Mode: Read Only - Average Latency henny-ribeye-2950x-main-postgres-real henny-ribeye-2950x-vs-i73930k-postgres-real 0.0601 0.1202 0.1803 0.2404 0.3005 SE +/- 0.000, N = 3 SE +/- 0.000, N = 3 0.075 0.267 -lpthread -lrt -ldl 1. (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.org ms, Fewer Is Better PostgreSQL 15 Scaling Factor: 1000 - Clients: 1 - Mode: Read Only - Average Latency henny-ribeye-2950x-main-postgres-real henny-ribeye-2950x-vs-i73930k-postgres-real 0.0266 0.0532 0.0798 0.1064 0.133 SE +/- 0.001, N = 9 SE +/- 0.002, N = 3 0.033 0.118 -lpthread -lrt -ldl 1. (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.org ms, Fewer Is Better PostgreSQL 15 Scaling Factor: 100 - Clients: 100 - Mode: Read Only - Average Latency henny-ribeye-2950x-main-postgres-real henny-ribeye-2950x-vs-i73930k-postgres-real 0.1204 0.2408 0.3612 0.4816 0.602 SE +/- 0.001, N = 3 SE +/- 0.001, N = 3 0.144 0.535 -lpthread -lrt -ldl 1. (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.org ms, Fewer Is Better PostgreSQL 15 Scaling Factor: 100 - Clients: 50 - Mode: Read Write - Average Latency henny-ribeye-2950x-main-postgres-real henny-ribeye-2950x-vs-i73930k-postgres-real 3 6 9 12 15 SE +/- 0.107, N = 12 SE +/- 0.009, N = 3 11.104 2.192 -lpthread -lrt -ldl 1. (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.org ms, Fewer Is Better PostgreSQL 15 Scaling Factor: 100 - Clients: 500 - Mode: Read Only - Average Latency henny-ribeye-2950x-main-postgres-real henny-ribeye-2950x-vs-i73930k-postgres-real 0.6093 1.2186 1.8279 2.4372 3.0465 SE +/- 0.002, N = 3 SE +/- 0.013, N = 3 0.805 2.708 -lpthread -lrt -ldl 1. (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.org ms, Fewer Is Better PostgreSQL 15 Scaling Factor: 1000 - Clients: 1 - Mode: Read Write - Average Latency henny-ribeye-2950x-main-postgres-real henny-ribeye-2950x-vs-i73930k-postgres-real 0.8039 1.6078 2.4117 3.2156 4.0195 SE +/- 0.011, N = 3 SE +/- 0.001, N = 3 3.573 0.466 -lpthread -lrt -ldl 1. (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.org ms, Fewer Is Better PostgreSQL 15 Scaling Factor: 1000 - Clients: 50 - Mode: Read Only - Average Latency henny-ribeye-2950x-main-postgres-real henny-ribeye-2950x-vs-i73930k-postgres-real 0.095 0.19 0.285 0.38 0.475 SE +/- 0.000, N = 3 SE +/- 0.001, N = 3 0.107 0.422 -lpthread -lrt -ldl 1. (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.org ms, Fewer Is Better PostgreSQL 15 Scaling Factor: 100 - Clients: 100 - Mode: Read Write - Average Latency henny-ribeye-2950x-main-postgres-real henny-ribeye-2950x-vs-i73930k-postgres-real 4 8 12 16 20 SE +/- 0.186, N = 12 SE +/- 0.045, N = 6 17.386 4.520 -lpthread -lrt -ldl 1. (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.org ms, Fewer Is Better PostgreSQL 15 Scaling Factor: 100 - Clients: 500 - Mode: Read Write - Average Latency henny-ribeye-2950x-main-postgres-real henny-ribeye-2950x-vs-i73930k-postgres-real 16 32 48 64 80 SE +/- 0.20, N = 3 SE +/- 0.10, N = 3 71.94 31.50 -lpthread -lrt -ldl 1. (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.org ms, Fewer Is Better PostgreSQL 15 Scaling Factor: 1000 - Clients: 100 - Mode: Read Only - Average Latency henny-ribeye-2950x-main-postgres-real henny-ribeye-2950x-vs-i73930k-postgres-real 0.2009 0.4018 0.6027 0.8036 1.0045 SE +/- 0.003, N = 3 SE +/- 0.002, N = 3 0.207 0.893 -lpthread -lrt -ldl 1. (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.org ms, Fewer Is Better PostgreSQL 15 Scaling Factor: 1000 - Clients: 50 - Mode: Read Write - Average Latency henny-ribeye-2950x-main-postgres-real henny-ribeye-2950x-vs-i73930k-postgres-real 4 8 12 16 20 SE +/- 0.064, N = 3 SE +/- 0.035, N = 9 14.311 2.674 -lpthread -lrt -ldl 1. (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.org ms, Fewer Is Better PostgreSQL 15 Scaling Factor: 1000 - Clients: 500 - Mode: Read Only - Average Latency henny-ribeye-2950x-main-postgres-real henny-ribeye-2950x-vs-i73930k-postgres-real 2 4 6 8 10 SE +/- 0.005, N = 3 SE +/- 0.051, N = 3 1.935 6.549 -lpthread -lrt -ldl 1. (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.org ms, Fewer Is Better PostgreSQL 15 Scaling Factor: 1000 - Clients: 100 - Mode: Read Write - Average Latency henny-ribeye-2950x-main-postgres-real henny-ribeye-2950x-vs-i73930k-postgres-real 4 8 12 16 20 SE +/- 0.115, N = 3 SE +/- 0.037, N = 3 17.827 5.149 -lpthread -lrt -ldl 1. (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.org ms, Fewer Is Better PostgreSQL 15 Scaling Factor: 1000 - Clients: 500 - Mode: Read Write - Average Latency henny-ribeye-2950x-main-postgres-real henny-ribeye-2950x-vs-i73930k-postgres-real 13 26 39 52 65 SE +/- 0.33, N = 3 SE +/- 0.45, N = 3 59.40 36.55 -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