henny-ribeye-2950x-main-postgres AMD Ryzen Threadripper 2950X 16-Core testing with a ASRock X399M Taichi (P3.80 BIOS) and MSI NVIDIA GeForce RTX 2080 8GB, with 32GB DDR4-2400 and SSD 1024GB INTEL SSDPEKNU010TZ, on Ubuntu 18.04 via the Phoronix Test Suite.
HTML result view exported from: https://openbenchmarking.org/result/2301082-NE-HENNYRIBE80&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 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 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 - --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 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 Security Details - 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 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 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 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 10K 20K 30K 40K 50K SE +/- 231.82, N = 3 48243 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -march=native -mtune=native -pipe -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -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 0.0047 0.0094 0.0141 0.0188 0.0235 SE +/- 0.000, N = 3 0.021 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -march=native -mtune=native -pipe -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -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 200 400 600 800 1000 SE +/- 3.54, N = 3 807 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -march=native -mtune=native -pipe -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -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 0.2788 0.5576 0.8364 1.1152 1.394 SE +/- 0.006, N = 3 1.239 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -march=native -mtune=native -pipe -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -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 150K 300K 450K 600K 750K SE +/- 1248.37, N = 3 708092 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -march=native -mtune=native -pipe -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -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 0.016 0.032 0.048 0.064 0.08 SE +/- 0.000, N = 3 0.071 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -march=native -mtune=native -pipe -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -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 160K 320K 480K 640K 800K SE +/- 3319.28, N = 3 755661 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -march=native -mtune=native -pipe -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -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 0.0297 0.0594 0.0891 0.1188 0.1485 SE +/- 0.001, N = 3 0.132 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -march=native -mtune=native -pipe -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -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 200 400 600 800 1000 SE +/- 7.27, N = 3 796 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -march=native -mtune=native -pipe -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -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 14 28 42 56 70 SE +/- 0.57, N = 3 62.86 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -march=native -mtune=native -pipe -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -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 140K 280K 420K 560K 700K SE +/- 2167.35, N = 3 649287 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -march=native -mtune=native -pipe -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -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 0.1733 0.3466 0.5199 0.6932 0.8665 SE +/- 0.003, N = 3 0.770 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -march=native -mtune=native -pipe -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -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 9K 18K 27K 36K 45K SE +/- 48.06, N = 3 44001 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -march=native -mtune=native -pipe -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -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 0.0052 0.0104 0.0156 0.0208 0.026 SE +/- 0.000, N = 3 0.023 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -march=native -mtune=native -pipe -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -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 200 400 600 800 1000 SE +/- 1.44, N = 3 797 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -march=native -mtune=native -pipe -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -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 30 60 90 120 150 SE +/- 0.23, N = 3 125.55 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -march=native -mtune=native -pipe -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -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 130 260 390 520 650 SE +/- 9.62, N = 12 625 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -march=native -mtune=native -pipe -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -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 200 400 600 800 1000 SE +/- 12.50, N = 12 802.75 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -march=native -mtune=native -pipe -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -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 100 200 300 400 500 SE +/- 4.37, N = 3 447 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -march=native -mtune=native -pipe -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -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 0.5031 1.0062 1.5093 2.0124 2.5155 SE +/- 0.022, N = 3 2.236 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -march=native -mtune=native -pipe -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -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 140K 280K 420K 560K 700K SE +/- 2997.94, N = 3 661538 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -march=native -mtune=native -pipe -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -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 0.0169 0.0338 0.0507 0.0676 0.0845 SE +/- 0.000, N = 3 0.075 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -march=native -mtune=native -pipe -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -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 6K 12K 18K 24K 30K SE +/- 869.78, N = 9 30046 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -march=native -mtune=native -pipe -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -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 0.0074 0.0148 0.0222 0.0296 0.037 SE +/- 0.001, N = 9 0.033 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -march=native -mtune=native -pipe -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -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 150K 300K 450K 600K 750K SE +/- 3023.40, N = 3 696765 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -march=native -mtune=native -pipe -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -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 0.0324 0.0648 0.0972 0.1296 0.162 SE +/- 0.001, N = 3 0.144 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -march=native -mtune=native -pipe -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -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 1000 2000 3000 4000 5000 SE +/- 43.75, N = 12 4508 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -march=native -mtune=native -pipe -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -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 3 6 9 12 15 SE +/- 0.11, N = 12 11.10 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -march=native -mtune=native -pipe -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -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 130K 260K 390K 520K 650K SE +/- 1795.20, N = 3 620790 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -march=native -mtune=native -pipe -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -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 0.1811 0.3622 0.5433 0.7244 0.9055 SE +/- 0.002, N = 3 0.805 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -march=native -mtune=native -pipe -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -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 60 120 180 240 300 SE +/- 0.86, N = 3 280 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -march=native -mtune=native -pipe -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
PostgreSQL Scaling Factor: 1000 - Clients: 1 - Mode: Read Write - Average Latency OpenBenchmarking.org ms, Fewer Is Better PostgreSQL 15 Scaling Factor: 1000 - Clients: 1 - Mode: Read Write - Average Latency henny-ribeye-2950x-main-postgres-real 0.8039 1.6078 2.4117 3.2156 4.0195 SE +/- 0.011, N = 3 3.573 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -march=native -mtune=native -pipe -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -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 100K 200K 300K 400K 500K SE +/- 734.31, N = 3 469264 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -march=native -mtune=native -pipe -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -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 0.0241 0.0482 0.0723 0.0964 0.1205 SE +/- 0.000, N = 3 0.107 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -march=native -mtune=native -pipe -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -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 1200 2400 3600 4800 6000 SE +/- 61.76, N = 12 5759 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -march=native -mtune=native -pipe -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -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 4 8 12 16 20 SE +/- 0.19, N = 12 17.39 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -march=native -mtune=native -pipe -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -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 1500 3000 4500 6000 7500 SE +/- 18.93, N = 3 6950 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -march=native -mtune=native -pipe -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -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 16 32 48 64 80 SE +/- 0.20, N = 3 71.94 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -march=native -mtune=native -pipe -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -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 100K 200K 300K 400K 500K SE +/- 6897.43, N = 3 482340 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -march=native -mtune=native -pipe -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -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 0.0466 0.0932 0.1398 0.1864 0.233 SE +/- 0.003, N = 3 0.207 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -march=native -mtune=native -pipe -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -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 700 1400 2100 2800 3500 SE +/- 15.78, N = 3 3494 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -march=native -mtune=native -pipe -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -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 4 8 12 16 20 SE +/- 0.06, N = 3 14.31 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -march=native -mtune=native -pipe -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -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 60K 120K 180K 240K 300K SE +/- 642.74, N = 3 258347 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -march=native -mtune=native -pipe -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -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 0.4354 0.8708 1.3062 1.7416 2.177 SE +/- 0.005, N = 3 1.935 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -march=native -mtune=native -pipe -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -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 1200 2400 3600 4800 6000 SE +/- 35.99, N = 3 5610 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -march=native -mtune=native -pipe -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -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 4 8 12 16 20 SE +/- 0.11, N = 3 17.83 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -march=native -mtune=native -pipe -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -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 2K 4K 6K 8K 10K SE +/- 46.45, N = 3 8418 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -march=native -mtune=native -pipe -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -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 13 26 39 52 65 SE +/- 0.33, N = 3 59.40 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -march=native -mtune=native -pipe -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
Phoronix Test Suite v10.8.4