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