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&sor&grt .
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 Only - Average Latency pgbench: 1 - 1 - Read Write pgbench: 1 - 1 - Read Write - Average Latency pgbench: 1 - 50 - Read Only pgbench: 1 - 50 - Read Only - Average Latency pgbench: 1 - 100 - Read Only pgbench: 1 - 100 - Read Only - Average Latency pgbench: 1 - 50 - Read Write pgbench: 1 - 50 - Read Write - Average Latency pgbench: 1 - 500 - Read Only pgbench: 1 - 500 - Read Only - Average Latency pgbench: 100 - 1 - Read Only pgbench: 100 - 1 - Read Only - Average Latency pgbench: 1 - 100 - Read Write pgbench: 1 - 100 - Read Write - Average Latency pgbench: 1 - 500 - Read Write pgbench: 1 - 500 - Read Write - Average Latency pgbench: 100 - 1 - Read Write pgbench: 100 - 1 - Read Write - Average Latency pgbench: 100 - 50 - Read Only pgbench: 100 - 50 - Read Only - Average Latency pgbench: 1000 - 1 - Read Only pgbench: 1000 - 1 - Read Only - Average Latency pgbench: 100 - 100 - Read Only pgbench: 100 - 100 - Read Only - Average Latency pgbench: 100 - 50 - Read Write pgbench: 100 - 50 - Read Write - Average Latency pgbench: 100 - 500 - Read Only pgbench: 100 - 500 - Read Only - Average Latency pgbench: 1000 - 1 - Read Write pgbench: 1000 - 1 - Read Write - Average Latency pgbench: 1000 - 50 - Read Only pgbench: 1000 - 50 - Read Only - Average Latency pgbench: 100 - 100 - Read Write pgbench: 100 - 100 - Read Write - Average Latency pgbench: 100 - 500 - Read Write pgbench: 100 - 500 - Read Write - Average Latency pgbench: 1000 - 100 - Read Only pgbench: 1000 - 100 - Read Only - Average Latency pgbench: 1000 - 50 - Read Write pgbench: 1000 - 50 - Read Write - Average Latency pgbench: 1000 - 500 - Read Only pgbench: 1000 - 500 - Read Only - Average Latency pgbench: 1000 - 100 - Read Write pgbench: 1000 - 100 - Read Write - Average Latency pgbench: 1000 - 500 - Read Write 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 0.021 807 1.239 708092 0.071 755661 0.132 796 62.858 649287 0.770 44001 0.023 797 125.549 625 802.753 447 2.236 661538 0.075 30046 0.033 696765 0.144 4508 11.104 620790 0.805 280 3.573 469264 0.107 5759 17.386 6950 71.944 482340 0.207 3494 14.311 258347 1.935 5610 17.827 8418 59.401 29935 0.033 3364 0.297 194767 0.257 196139 0.510 1614 30.972 192560 2.597 28550 0.035 1256 79.593 405 1278.510 3094 0.323 187186 0.267 8496 0.118 186859 0.535 22811 2.192 184644 2.708 2146 0.466 118572 0.422 22135 4.520 15874 31.498 112039 0.893 18725 2.674 76354 6.549 19421 5.149 13685 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 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 OpenBenchmarking.org TPS, More Is Better PostgreSQL 15 Scaling Factor: 1 - Clients: 1 - Mode: Read Write henny-ribeye-2950x-vs-i73930k-postgres-real henny-ribeye-2950x-main-postgres-real 700 1400 2100 2800 3500 SE +/- 20.00, N = 3 SE +/- 3.54, N = 3 3364 807 -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-vs-i73930k-postgres-real henny-ribeye-2950x-main-postgres-real 0.2788 0.5576 0.8364 1.1152 1.394 SE +/- 0.002, N = 3 SE +/- 0.006, N = 3 0.297 1.239 -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: 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: 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 OpenBenchmarking.org TPS, More Is Better PostgreSQL 15 Scaling Factor: 1 - Clients: 50 - Mode: Read Write henny-ribeye-2950x-vs-i73930k-postgres-real henny-ribeye-2950x-main-postgres-real 300 600 900 1200 1500 SE +/- 3.94, N = 3 SE +/- 7.27, N = 3 1614 796 -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-vs-i73930k-postgres-real henny-ribeye-2950x-main-postgres-real 14 28 42 56 70 SE +/- 0.08, N = 3 SE +/- 0.57, N = 3 30.97 62.86 -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: 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 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: 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-vs-i73930k-postgres-real henny-ribeye-2950x-main-postgres-real 300 600 900 1200 1500 SE +/- 7.16, N = 3 SE +/- 1.44, N = 3 1256 797 -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-vs-i73930k-postgres-real henny-ribeye-2950x-main-postgres-real 30 60 90 120 150 SE +/- 0.45, N = 3 SE +/- 0.23, N = 3 79.59 125.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: 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: 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 OpenBenchmarking.org TPS, More Is Better PostgreSQL 15 Scaling Factor: 100 - Clients: 1 - Mode: Read Write henny-ribeye-2950x-vs-i73930k-postgres-real henny-ribeye-2950x-main-postgres-real 700 1400 2100 2800 3500 SE +/- 20.94, N = 3 SE +/- 4.37, N = 3 3094 447 -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-vs-i73930k-postgres-real henny-ribeye-2950x-main-postgres-real 0.5031 1.0062 1.5093 2.0124 2.5155 SE +/- 0.002, N = 3 SE +/- 0.022, N = 3 0.323 2.236 -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: 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 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: 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 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: 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-vs-i73930k-postgres-real henny-ribeye-2950x-main-postgres-real 5K 10K 15K 20K 25K SE +/- 97.11, N = 3 SE +/- 43.75, N = 12 22811 4508 -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-vs-i73930k-postgres-real henny-ribeye-2950x-main-postgres-real 3 6 9 12 15 SE +/- 0.009, N = 3 SE +/- 0.107, N = 12 2.192 11.104 -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 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 OpenBenchmarking.org TPS, More Is Better PostgreSQL 15 Scaling Factor: 1000 - Clients: 1 - Mode: Read Write henny-ribeye-2950x-vs-i73930k-postgres-real henny-ribeye-2950x-main-postgres-real 500 1000 1500 2000 2500 SE +/- 1.78, N = 3 SE +/- 0.86, N = 3 2146 280 -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-vs-i73930k-postgres-real henny-ribeye-2950x-main-postgres-real 0.8039 1.6078 2.4117 3.2156 4.0195 SE +/- 0.001, N = 3 SE +/- 0.011, N = 3 0.466 3.573 -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: 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-vs-i73930k-postgres-real henny-ribeye-2950x-main-postgres-real 5K 10K 15K 20K 25K SE +/- 210.47, N = 6 SE +/- 61.76, N = 12 22135 5759 -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-vs-i73930k-postgres-real henny-ribeye-2950x-main-postgres-real 4 8 12 16 20 SE +/- 0.045, N = 6 SE +/- 0.186, N = 12 4.520 17.386 -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-vs-i73930k-postgres-real henny-ribeye-2950x-main-postgres-real 3K 6K 9K 12K 15K SE +/- 49.31, N = 3 SE +/- 18.93, N = 3 15874 6950 -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-vs-i73930k-postgres-real henny-ribeye-2950x-main-postgres-real 16 32 48 64 80 SE +/- 0.10, N = 3 SE +/- 0.20, N = 3 31.50 71.94 -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: 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 OpenBenchmarking.org TPS, More Is Better PostgreSQL 15 Scaling Factor: 1000 - Clients: 50 - Mode: Read Write henny-ribeye-2950x-vs-i73930k-postgres-real henny-ribeye-2950x-main-postgres-real 4K 8K 12K 16K 20K SE +/- 241.47, N = 9 SE +/- 15.78, N = 3 18725 3494 -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-vs-i73930k-postgres-real henny-ribeye-2950x-main-postgres-real 4 8 12 16 20 SE +/- 0.035, N = 9 SE +/- 0.064, N = 3 2.674 14.311 -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: 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 OpenBenchmarking.org TPS, More Is Better PostgreSQL 15 Scaling Factor: 1000 - Clients: 100 - Mode: Read Write henny-ribeye-2950x-vs-i73930k-postgres-real henny-ribeye-2950x-main-postgres-real 4K 8K 12K 16K 20K SE +/- 138.72, N = 3 SE +/- 35.99, N = 3 19421 5610 -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-vs-i73930k-postgres-real henny-ribeye-2950x-main-postgres-real 4 8 12 16 20 SE +/- 0.037, N = 3 SE +/- 0.115, N = 3 5.149 17.827 -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-vs-i73930k-postgres-real henny-ribeye-2950x-main-postgres-real 3K 6K 9K 12K 15K SE +/- 167.76, N = 3 SE +/- 46.45, N = 3 13685 8418 -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-vs-i73930k-postgres-real henny-ribeye-2950x-main-postgres-real 13 26 39 52 65 SE +/- 0.45, N = 3 SE +/- 0.33, N = 3 36.55 59.40 -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