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&sro&grs .
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: 1000 - 1 - Read Write - Average Latency pgbench: 1000 - 1 - Read Write pgbench: 100 - 1 - Read Write - Average Latency pgbench: 100 - 1 - Read Write pgbench: 1000 - 50 - Read Write pgbench: 1000 - 50 - Read Write - Average Latency pgbench: 100 - 50 - Read Write - Average Latency pgbench: 100 - 50 - Read Write pgbench: 1000 - 100 - Read Only - Average Latency pgbench: 1000 - 100 - Read Only pgbench: 1 - 1 - Read Write - Average Latency pgbench: 1 - 1 - Read Write pgbench: 1000 - 50 - Read Only pgbench: 1000 - 50 - Read Only - Average Latency pgbench: 1 - 100 - Read Only - Average Latency pgbench: 1 - 100 - Read Only pgbench: 100 - 100 - Read Write - Average Latency pgbench: 100 - 100 - Read Write pgbench: 100 - 100 - Read Only pgbench: 100 - 100 - Read Only - Average Latency pgbench: 1 - 50 - Read Only pgbench: 1 - 50 - Read Only - Average Latency pgbench: 100 - 50 - Read Only - Average Latency pgbench: 100 - 50 - Read Only pgbench: 1000 - 100 - Read Write - Average Latency pgbench: 1000 - 100 - Read Write pgbench: 1000 - 500 - Read Only - Average Latency pgbench: 1000 - 500 - Read Only pgbench: 1 - 500 - Read Only - Average Latency pgbench: 1 - 500 - Read Only pgbench: 100 - 500 - Read Only - Average Latency pgbench: 100 - 500 - Read Only pgbench: 100 - 500 - Read Write - Average Latency pgbench: 100 - 500 - Read Write pgbench: 1 - 50 - Read Write - Average Latency pgbench: 1 - 50 - Read Write pgbench: 1000 - 500 - Read Write pgbench: 1000 - 500 - Read Write - Average Latency pgbench: 1 - 1 - Read Only pgbench: 1 - 100 - Read Write - Average Latency pgbench: 1 - 100 - Read Write pgbench: 1 - 1 - Read Only - Average Latency pgbench: 100 - 1 - Read Only pgbench: 100 - 1 - Read Only - Average Latency pgbench: 1000 - 1 - Read Only - Average Latency pgbench: 1000 - 1 - Read Only pgbench: 1 - 500 - Read Write - Average Latency pgbench: 1 - 500 - Read Write henny-ribeye-2950x-main-postgres henny-ribeye-2950x-main-postgres-real henny-ribeye-2950x-vs-i73930k-postgres-real 3.573 280 2.236 447 3494 14.311 11.104 4508 0.207 482340 1.239 807 469264 0.107 0.132 755661 17.386 5759 696765 0.144 708092 0.071 0.075 661538 17.827 5610 1.935 258347 0.770 649287 0.805 620790 71.944 6950 62.858 796 8418 59.401 48243 125.549 797 0.021 44001 0.023 0.033 30046 802.753 625 0.466 2146 0.323 3094 18725 2.674 2.192 22811 0.893 112039 0.297 3364 118572 0.422 0.510 196139 4.520 22135 186859 0.535 194767 0.257 0.267 187186 5.149 19421 6.549 76354 2.597 192560 2.708 184644 31.498 15874 30.972 1614 13685 36.549 29935 79.593 1256 0.033 28550 0.035 0.118 8496 1278.510 405 OpenBenchmarking.org
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: 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: 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: 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: 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: 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: 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: 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: 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: 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: 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: 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: 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: 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: 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: 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: 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: 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: 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: 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: 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: 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: 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: 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: 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: 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 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: 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: 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: 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: 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: 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: 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: 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: 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: 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: 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: 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
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: 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: 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: 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: 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: 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: 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: 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: 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: 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
Phoronix Test Suite v10.8.5