Test-Node-1-all-test-mode Processor: 2 x Intel Xeon Silver 4110 (16 Cores / 32 Threads), Motherboard: Quanta Cloud QuantaPlex T42S-2U (LBG-1G) MB (Lewisburg-1G) (3A12.Q302 BIOS), Chipset: Intel Sky Lake-E DMI3 Registers, Memory: 8 x 32GB DDR4-2400MT/s, Disk: 6 x 960GB SAMSUNG MZ7KM960, Graphics: ASPEED, Network: 2 x Intel X722 for 10GBASE-T + 2 x Intel 82599ES 10-Gigabit SFI/SFP+
OS: Ubuntu 22.04, Kernel: 5.15.0-78-generic (x86_64), Vulkan: 1.3.255, Compiler: GCC 11.4.0, File-System: ext4, Screen Resolution: 1024x768
Kernel Notes: Transparent Huge Pages: madviseCompiler Notes: --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-XeT9lY/gcc-11-11.4.0/debian/tmp-nvptx/usr,amdgcn-amdhsa=/build/gcc-11-XeT9lY/gcc-11-11.4.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 -vProcessor Notes: CPU Microcode: 0x2007006Security Notes: 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: Mitigation of Clear buffers; SMT vulnerable + retbleed: Mitigation of IBRS + 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 IBRS IBPB: conditional STIBP: conditional RSB filling PBRSB-eIBRS: Not affected + srbds: Not affected + tsx_async_abort: Mitigation of Clear buffers; SMT vulnerable
OpenBenchmarking.org ms, Fewer Is Better PostgreSQL 15 Scaling Factor: 1 - Clients: 1 - Mode: Read Only - Average Latency Test-Node-1-all-test-mode 0.0164 0.0328 0.0492 0.0656 0.082 SE +/- 0.001, N = 12 0.073 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
OpenBenchmarking.org TPS, More Is Better PostgreSQL 15 Scaling Factor: 1 - Clients: 1 - Mode: Read Write Test-Node-1-all-test-mode 200 400 600 800 1000 SE +/- 3.90, N = 3 892 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
OpenBenchmarking.org ms, Fewer Is Better PostgreSQL 15 Scaling Factor: 1 - Clients: 1 - Mode: Read Write - Average Latency Test-Node-1-all-test-mode 0.2522 0.5044 0.7566 1.0088 1.261 SE +/- 0.005, N = 3 1.121 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
OpenBenchmarking.org TPS, More Is Better PostgreSQL 15 Scaling Factor: 1 - Clients: 50 - Mode: Read Only Test-Node-1-all-test-mode 110K 220K 330K 440K 550K SE +/- 2632.28, N = 3 528376 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
OpenBenchmarking.org ms, Fewer Is Better PostgreSQL 15 Scaling Factor: 1 - Clients: 50 - Mode: Read Only - Average Latency Test-Node-1-all-test-mode 0.0214 0.0428 0.0642 0.0856 0.107 SE +/- 0.000, N = 3 0.095 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
OpenBenchmarking.org TPS, More Is Better PostgreSQL 15 Scaling Factor: 1 - Clients: 100 - Mode: Read Only Test-Node-1-all-test-mode 110K 220K 330K 440K 550K SE +/- 790.18, N = 3 534493 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
OpenBenchmarking.org ms, Fewer Is Better PostgreSQL 15 Scaling Factor: 1 - Clients: 100 - Mode: Read Only - Average Latency Test-Node-1-all-test-mode 0.0421 0.0842 0.1263 0.1684 0.2105 SE +/- 0.000, N = 3 0.187 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
OpenBenchmarking.org TPS, More Is Better PostgreSQL 15 Scaling Factor: 1 - Clients: 250 - Mode: Read Only Test-Node-1-all-test-mode 120K 240K 360K 480K 600K SE +/- 2235.72, N = 3 544500 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
OpenBenchmarking.org ms, Fewer Is Better PostgreSQL 15 Scaling Factor: 1 - Clients: 250 - Mode: Read Only - Average Latency Test-Node-1-all-test-mode 0.1033 0.2066 0.3099 0.4132 0.5165 SE +/- 0.002, N = 3 0.459 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
OpenBenchmarking.org TPS, More Is Better PostgreSQL 15 Scaling Factor: 1 - Clients: 50 - Mode: Read Write Test-Node-1-all-test-mode 200 400 600 800 1000 SE +/- 0.13, N = 3 797 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
OpenBenchmarking.org ms, Fewer Is Better PostgreSQL 15 Scaling Factor: 1 - Clients: 50 - Mode: Read Write - Average Latency Test-Node-1-all-test-mode 14 28 42 56 70 SE +/- 0.01, N = 3 62.74 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
OpenBenchmarking.org TPS, More Is Better PostgreSQL 15 Scaling Factor: 1 - Clients: 500 - Mode: Read Only Test-Node-1-all-test-mode 120K 240K 360K 480K 600K SE +/- 749.56, N = 3 538380 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
OpenBenchmarking.org ms, Fewer Is Better PostgreSQL 15 Scaling Factor: 1 - Clients: 500 - Mode: Read Only - Average Latency Test-Node-1-all-test-mode 0.209 0.418 0.627 0.836 1.045 SE +/- 0.001, N = 3 0.929 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
OpenBenchmarking.org TPS, More Is Better PostgreSQL 15 Scaling Factor: 1 - Clients: 800 - Mode: Read Only Test-Node-1-all-test-mode 110K 220K 330K 440K 550K SE +/- 2659.13, N = 3 518001 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
OpenBenchmarking.org ms, Fewer Is Better PostgreSQL 15 Scaling Factor: 1 - Clients: 800 - Mode: Read Only - Average Latency Test-Node-1-all-test-mode 0.3476 0.6952 1.0428 1.3904 1.738 SE +/- 0.008, N = 3 1.545 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
OpenBenchmarking.org TPS, More Is Better PostgreSQL 15 Scaling Factor: 100 - Clients: 1 - Mode: Read Only Test-Node-1-all-test-mode 3K 6K 9K 12K 15K SE +/- 86.32, N = 3 13079 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
OpenBenchmarking.org ms, Fewer Is Better PostgreSQL 15 Scaling Factor: 100 - Clients: 1 - Mode: Read Only - Average Latency Test-Node-1-all-test-mode 0.0171 0.0342 0.0513 0.0684 0.0855 SE +/- 0.000, N = 3 0.076 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
OpenBenchmarking.org TPS, More Is Better PostgreSQL 15 Scaling Factor: 1 - Clients: 100 - Mode: Read Write Test-Node-1-all-test-mode 150 300 450 600 750 SE +/- 5.60, N = 3 692 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
OpenBenchmarking.org ms, Fewer Is Better PostgreSQL 15 Scaling Factor: 1 - Clients: 100 - Mode: Read Write - Average Latency Test-Node-1-all-test-mode 30 60 90 120 150 SE +/- 1.18, N = 3 144.47 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
OpenBenchmarking.org TPS, More Is Better PostgreSQL 15 Scaling Factor: 1 - Clients: 1000 - Mode: Read Only Test-Node-1-all-test-mode 100K 200K 300K 400K 500K SE +/- 5049.70, N = 12 473985 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
OpenBenchmarking.org ms, Fewer Is Better PostgreSQL 15 Scaling Factor: 1 - Clients: 1000 - Mode: Read Only - Average Latency Test-Node-1-all-test-mode 0.4752 0.9504 1.4256 1.9008 2.376 SE +/- 0.022, N = 12 2.112 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
OpenBenchmarking.org TPS, More Is Better PostgreSQL 15 Scaling Factor: 1 - Clients: 250 - Mode: Read Write Test-Node-1-all-test-mode 90 180 270 360 450 SE +/- 4.27, N = 3 427 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
OpenBenchmarking.org ms, Fewer Is Better PostgreSQL 15 Scaling Factor: 1 - Clients: 250 - Mode: Read Write - Average Latency Test-Node-1-all-test-mode 130 260 390 520 650 SE +/- 5.79, N = 3 585.24 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
OpenBenchmarking.org TPS, More Is Better PostgreSQL 15 Scaling Factor: 1 - Clients: 500 - Mode: Read Write Test-Node-1-all-test-mode 50 100 150 200 250 SE +/- 8.15, N = 12 217 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
OpenBenchmarking.org ms, Fewer Is Better PostgreSQL 15 Scaling Factor: 1 - Clients: 500 - Mode: Read Write - Average Latency Test-Node-1-all-test-mode 500 1000 1500 2000 2500 SE +/- 78.75, N = 12 2333.64 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
Scaling Factor: 1 - Clients: 5000 - Mode: Read Only
Test-Node-1-all-test-mode: The test run did not produce a result. E: pgbench: error: need at least 5003 open files, but system limit is 1024
OpenBenchmarking.org TPS, More Is Better PostgreSQL 15 Scaling Factor: 1 - Clients: 800 - Mode: Read Write Test-Node-1-all-test-mode 50 100 150 200 250 SE +/- 3.81, N = 12 213 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
OpenBenchmarking.org ms, Fewer Is Better PostgreSQL 15 Scaling Factor: 1 - Clients: 800 - Mode: Read Write - Average Latency Test-Node-1-all-test-mode 800 1600 2400 3200 4000 SE +/- 69.08, N = 12 3774.32 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
OpenBenchmarking.org TPS, More Is Better PostgreSQL 15 Scaling Factor: 100 - Clients: 1 - Mode: Read Write Test-Node-1-all-test-mode 160 320 480 640 800 SE +/- 7.19, N = 3 734 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
OpenBenchmarking.org ms, Fewer Is Better PostgreSQL 15 Scaling Factor: 100 - Clients: 1 - Mode: Read Write - Average Latency Test-Node-1-all-test-mode 0.3067 0.6134 0.9201 1.2268 1.5335 SE +/- 0.014, N = 3 1.363 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
OpenBenchmarking.org TPS, More Is Better PostgreSQL 15 Scaling Factor: 100 - Clients: 50 - Mode: Read Only Test-Node-1-all-test-mode 110K 220K 330K 440K 550K SE +/- 1728.06, N = 3 495920 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
OpenBenchmarking.org ms, Fewer Is Better PostgreSQL 15 Scaling Factor: 100 - Clients: 50 - Mode: Read Only - Average Latency Test-Node-1-all-test-mode 0.0227 0.0454 0.0681 0.0908 0.1135 SE +/- 0.000, N = 3 0.101 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
OpenBenchmarking.org TPS, More Is Better PostgreSQL 15 Scaling Factor: 1000 - Clients: 1 - Mode: Read Only Test-Node-1-all-test-mode 3K 6K 9K 12K 15K SE +/- 101.75, N = 3 11762 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
OpenBenchmarking.org ms, Fewer Is Better PostgreSQL 15 Scaling Factor: 1000 - Clients: 1 - Mode: Read Only - Average Latency Test-Node-1-all-test-mode 0.0191 0.0382 0.0573 0.0764 0.0955 SE +/- 0.001, N = 3 0.085 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
OpenBenchmarking.org TPS, More Is Better PostgreSQL 15 Scaling Factor: 1 - Clients: 1000 - Mode: Read Write Test-Node-1-all-test-mode 40 80 120 160 200 SE +/- 1.75, N = 4 160 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
OpenBenchmarking.org ms, Fewer Is Better PostgreSQL 15 Scaling Factor: 1 - Clients: 1000 - Mode: Read Write - Average Latency Test-Node-1-all-test-mode 1300 2600 3900 5200 6500 SE +/- 68.80, N = 4 6247.05 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
Scaling Factor: 1 - Clients: 5000 - Mode: Read Write
Test-Node-1-all-test-mode: The test run did not produce a result. E: pgbench: error: need at least 5003 open files, but system limit is 1024
OpenBenchmarking.org TPS, More Is Better PostgreSQL 15 Scaling Factor: 100 - Clients: 100 - Mode: Read Only Test-Node-1-all-test-mode 100K 200K 300K 400K 500K SE +/- 1822.29, N = 3 486680 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
OpenBenchmarking.org ms, Fewer Is Better PostgreSQL 15 Scaling Factor: 100 - Clients: 100 - Mode: Read Only - Average Latency Test-Node-1-all-test-mode 0.0461 0.0922 0.1383 0.1844 0.2305 SE +/- 0.001, N = 3 0.205 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
OpenBenchmarking.org TPS, More Is Better PostgreSQL 15 Scaling Factor: 100 - Clients: 250 - Mode: Read Only Test-Node-1-all-test-mode 100K 200K 300K 400K 500K SE +/- 2830.83, N = 3 488441 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
OpenBenchmarking.org ms, Fewer Is Better PostgreSQL 15 Scaling Factor: 100 - Clients: 250 - Mode: Read Only - Average Latency Test-Node-1-all-test-mode 0.1152 0.2304 0.3456 0.4608 0.576 SE +/- 0.003, N = 3 0.512 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
OpenBenchmarking.org TPS, More Is Better PostgreSQL 15 Scaling Factor: 100 - Clients: 50 - Mode: Read Write Test-Node-1-all-test-mode 2K 4K 6K 8K 10K SE +/- 13.13, N = 3 11324 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
OpenBenchmarking.org ms, Fewer Is Better PostgreSQL 15 Scaling Factor: 100 - Clients: 50 - Mode: Read Write - Average Latency Test-Node-1-all-test-mode 0.9934 1.9868 2.9802 3.9736 4.967 SE +/- 0.005, N = 3 4.415 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
OpenBenchmarking.org TPS, More Is Better PostgreSQL 15 Scaling Factor: 100 - Clients: 500 - Mode: Read Only Test-Node-1-all-test-mode 100K 200K 300K 400K 500K SE +/- 1542.96, N = 3 467377 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
OpenBenchmarking.org ms, Fewer Is Better PostgreSQL 15 Scaling Factor: 100 - Clients: 500 - Mode: Read Only - Average Latency Test-Node-1-all-test-mode 0.2408 0.4816 0.7224 0.9632 1.204 SE +/- 0.003, N = 3 1.070 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
OpenBenchmarking.org TPS, More Is Better PostgreSQL 15 Scaling Factor: 100 - Clients: 800 - Mode: Read Only Test-Node-1-all-test-mode 100K 200K 300K 400K 500K SE +/- 3742.40, N = 8 447710 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
OpenBenchmarking.org ms, Fewer Is Better PostgreSQL 15 Scaling Factor: 100 - Clients: 800 - Mode: Read Only - Average Latency Test-Node-1-all-test-mode 0.4023 0.8046 1.2069 1.6092 2.0115 SE +/- 0.015, N = 8 1.788 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
OpenBenchmarking.org TPS, More Is Better PostgreSQL 15 Scaling Factor: 1000 - Clients: 1 - Mode: Read Write Test-Node-1-all-test-mode 150 300 450 600 750 SE +/- 2.58, N = 3 711 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
OpenBenchmarking.org ms, Fewer Is Better PostgreSQL 15 Scaling Factor: 1000 - Clients: 1 - Mode: Read Write - Average Latency Test-Node-1-all-test-mode 0.3166 0.6332 0.9498 1.2664 1.583 SE +/- 0.005, N = 3 1.407 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
OpenBenchmarking.org TPS, More Is Better PostgreSQL 15 Scaling Factor: 1000 - Clients: 50 - Mode: Read Only Test-Node-1-all-test-mode 80K 160K 240K 320K 400K SE +/- 2377.34, N = 3 361378 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
OpenBenchmarking.org ms, Fewer Is Better PostgreSQL 15 Scaling Factor: 1000 - Clients: 50 - Mode: Read Only - Average Latency Test-Node-1-all-test-mode 0.0311 0.0622 0.0933 0.1244 0.1555 SE +/- 0.001, N = 3 0.138 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
OpenBenchmarking.org TPS, More Is Better PostgreSQL 15 Scaling Factor: 10000 - Clients: 1 - Mode: Read Only Test-Node-1-all-test-mode 2K 4K 6K 8K 10K SE +/- 417.30, N = 9 10836 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
OpenBenchmarking.org ms, Fewer Is Better PostgreSQL 15 Scaling Factor: 10000 - Clients: 1 - Mode: Read Only - Average Latency Test-Node-1-all-test-mode 0.0212 0.0424 0.0636 0.0848 0.106 SE +/- 0.005, N = 9 0.094 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
OpenBenchmarking.org TPS, More Is Better PostgreSQL 15 Scaling Factor: 25000 - Clients: 1 - Mode: Read Only Test-Node-1-all-test-mode 900 1800 2700 3600 4500 SE +/- 41.11, N = 3 4292 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
OpenBenchmarking.org ms, Fewer Is Better PostgreSQL 15 Scaling Factor: 25000 - Clients: 1 - Mode: Read Only - Average Latency Test-Node-1-all-test-mode 0.0524 0.1048 0.1572 0.2096 0.262 SE +/- 0.002, N = 3 0.233 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
OpenBenchmarking.org TPS, More Is Better PostgreSQL 15 Scaling Factor: 100 - Clients: 100 - Mode: Read Write Test-Node-1-all-test-mode 3K 6K 9K 12K 15K SE +/- 29.05, N = 3 16220 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
OpenBenchmarking.org ms, Fewer Is Better PostgreSQL 15 Scaling Factor: 100 - Clients: 100 - Mode: Read Write - Average Latency Test-Node-1-all-test-mode 2 4 6 8 10 SE +/- 0.011, N = 3 6.165 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
OpenBenchmarking.org TPS, More Is Better PostgreSQL 15 Scaling Factor: 100 - Clients: 1000 - Mode: Read Only Test-Node-1-all-test-mode 90K 180K 270K 360K 450K SE +/- 5017.87, N = 3 410369 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
OpenBenchmarking.org ms, Fewer Is Better PostgreSQL 15 Scaling Factor: 100 - Clients: 1000 - Mode: Read Only - Average Latency Test-Node-1-all-test-mode 0.5486 1.0972 1.6458 2.1944 2.743 SE +/- 0.029, N = 3 2.438 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
OpenBenchmarking.org TPS, More Is Better PostgreSQL 15 Scaling Factor: 100 - Clients: 250 - Mode: Read Write Test-Node-1-all-test-mode 5K 10K 15K 20K 25K SE +/- 8.07, N = 3 22591 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
OpenBenchmarking.org ms, Fewer Is Better PostgreSQL 15 Scaling Factor: 100 - Clients: 250 - Mode: Read Write - Average Latency Test-Node-1-all-test-mode 3 6 9 12 15 SE +/- 0.00, N = 3 11.07 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
OpenBenchmarking.org TPS, More Is Better PostgreSQL 15 Scaling Factor: 100 - Clients: 500 - Mode: Read Write Test-Node-1-all-test-mode 5K 10K 15K 20K 25K SE +/- 25.67, N = 3 22818 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
OpenBenchmarking.org ms, Fewer Is Better PostgreSQL 15 Scaling Factor: 100 - Clients: 500 - Mode: Read Write - Average Latency Test-Node-1-all-test-mode 5 10 15 20 25 SE +/- 0.02, N = 3 21.91 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
Scaling Factor: 100 - Clients: 5000 - Mode: Read Only
Test-Node-1-all-test-mode: The test run did not produce a result. E: pgbench: error: need at least 5003 open files, but system limit is 1024
OpenBenchmarking.org TPS, More Is Better PostgreSQL 15 Scaling Factor: 100 - Clients: 800 - Mode: Read Write Test-Node-1-all-test-mode 4K 8K 12K 16K 20K SE +/- 29.82, N = 3 19011 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
OpenBenchmarking.org ms, Fewer Is Better PostgreSQL 15 Scaling Factor: 100 - Clients: 800 - Mode: Read Write - Average Latency Test-Node-1-all-test-mode 10 20 30 40 50 SE +/- 0.07, N = 3 42.08 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
OpenBenchmarking.org TPS, More Is Better PostgreSQL 15 Scaling Factor: 1000 - Clients: 100 - Mode: Read Only Test-Node-1-all-test-mode 70K 140K 210K 280K 350K SE +/- 312.00, N = 3 346397 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
OpenBenchmarking.org ms, Fewer Is Better PostgreSQL 15 Scaling Factor: 1000 - Clients: 100 - Mode: Read Only - Average Latency Test-Node-1-all-test-mode 0.065 0.13 0.195 0.26 0.325 SE +/- 0.000, N = 3 0.289 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
OpenBenchmarking.org TPS, More Is Better PostgreSQL 15 Scaling Factor: 1000 - Clients: 250 - Mode: Read Only Test-Node-1-all-test-mode 70K 140K 210K 280K 350K SE +/- 553.78, N = 3 312964 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
OpenBenchmarking.org ms, Fewer Is Better PostgreSQL 15 Scaling Factor: 1000 - Clients: 250 - Mode: Read Only - Average Latency Test-Node-1-all-test-mode 0.1798 0.3596 0.5394 0.7192 0.899 SE +/- 0.001, N = 3 0.799 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
OpenBenchmarking.org TPS, More Is Better PostgreSQL 15 Scaling Factor: 1000 - Clients: 50 - Mode: Read Write Test-Node-1-all-test-mode 2K 4K 6K 8K 10K SE +/- 9.45, N = 3 8776 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
OpenBenchmarking.org ms, Fewer Is Better PostgreSQL 15 Scaling Factor: 1000 - Clients: 50 - Mode: Read Write - Average Latency Test-Node-1-all-test-mode 1.2818 2.5636 3.8454 5.1272 6.409 SE +/- 0.006, N = 3 5.697 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
OpenBenchmarking.org TPS, More Is Better PostgreSQL 15 Scaling Factor: 1000 - Clients: 500 - Mode: Read Only Test-Node-1-all-test-mode 60K 120K 180K 240K 300K SE +/- 848.56, N = 3 280134 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
OpenBenchmarking.org ms, Fewer Is Better PostgreSQL 15 Scaling Factor: 1000 - Clients: 500 - Mode: Read Only - Average Latency Test-Node-1-all-test-mode 0.4016 0.8032 1.2048 1.6064 2.008 SE +/- 0.006, N = 3 1.785 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
OpenBenchmarking.org TPS, More Is Better PostgreSQL 15 Scaling Factor: 1000 - Clients: 800 - Mode: Read Only Test-Node-1-all-test-mode 50K 100K 150K 200K 250K SE +/- 390.62, N = 3 255337 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
OpenBenchmarking.org ms, Fewer Is Better PostgreSQL 15 Scaling Factor: 1000 - Clients: 800 - Mode: Read Only - Average Latency Test-Node-1-all-test-mode 0.7049 1.4098 2.1147 2.8196 3.5245 SE +/- 0.005, N = 3 3.133 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
OpenBenchmarking.org TPS, More Is Better PostgreSQL 15 Scaling Factor: 10000 - Clients: 1 - Mode: Read Write Test-Node-1-all-test-mode 140 280 420 560 700 SE +/- 5.56, N = 3 657 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
OpenBenchmarking.org ms, Fewer Is Better PostgreSQL 15 Scaling Factor: 10000 - Clients: 1 - Mode: Read Write - Average Latency Test-Node-1-all-test-mode 0.3422 0.6844 1.0266 1.3688 1.711 SE +/- 0.013, N = 3 1.521 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
OpenBenchmarking.org TPS, More Is Better PostgreSQL 15 Scaling Factor: 10000 - Clients: 50 - Mode: Read Only Test-Node-1-all-test-mode 70K 140K 210K 280K 350K SE +/- 4104.12, N = 3 312321 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
OpenBenchmarking.org ms, Fewer Is Better PostgreSQL 15 Scaling Factor: 10000 - Clients: 50 - Mode: Read Only - Average Latency Test-Node-1-all-test-mode 0.036 0.072 0.108 0.144 0.18 SE +/- 0.002, N = 3 0.160 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
OpenBenchmarking.org TPS, More Is Better PostgreSQL 15 Scaling Factor: 25000 - Clients: 1 - Mode: Read Write Test-Node-1-all-test-mode 130 260 390 520 650 SE +/- 2.30, N = 3 601 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
OpenBenchmarking.org ms, Fewer Is Better PostgreSQL 15 Scaling Factor: 25000 - Clients: 1 - Mode: Read Write - Average Latency Test-Node-1-all-test-mode 0.3742 0.7484 1.1226 1.4968 1.871 SE +/- 0.006, N = 3 1.663 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
OpenBenchmarking.org TPS, More Is Better PostgreSQL 15 Scaling Factor: 25000 - Clients: 50 - Mode: Read Only Test-Node-1-all-test-mode 50K 100K 150K 200K 250K SE +/- 703.39, N = 3 214946 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
OpenBenchmarking.org ms, Fewer Is Better PostgreSQL 15 Scaling Factor: 25000 - Clients: 50 - Mode: Read Only - Average Latency Test-Node-1-all-test-mode 0.0524 0.1048 0.1572 0.2096 0.262 SE +/- 0.001, N = 3 0.233 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
OpenBenchmarking.org TPS, More Is Better PostgreSQL 15 Scaling Factor: 100 - Clients: 1000 - Mode: Read Write Test-Node-1-all-test-mode 3K 6K 9K 12K 15K SE +/- 55.39, N = 3 16232 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
OpenBenchmarking.org ms, Fewer Is Better PostgreSQL 15 Scaling Factor: 100 - Clients: 1000 - Mode: Read Write - Average Latency Test-Node-1-all-test-mode 14 28 42 56 70 SE +/- 0.21, N = 3 61.61 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
Scaling Factor: 100 - Clients: 5000 - Mode: Read Write
Test-Node-1-all-test-mode: The test run did not produce a result. E: pgbench: error: need at least 5003 open files, but system limit is 1024
OpenBenchmarking.org TPS, More Is Better PostgreSQL 15 Scaling Factor: 1000 - Clients: 100 - Mode: Read Write Test-Node-1-all-test-mode 2K 4K 6K 8K 10K SE +/- 18.04, N = 3 11491 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
OpenBenchmarking.org ms, Fewer Is Better PostgreSQL 15 Scaling Factor: 1000 - Clients: 100 - Mode: Read Write - Average Latency Test-Node-1-all-test-mode 2 4 6 8 10 SE +/- 0.014, N = 3 8.703 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
OpenBenchmarking.org TPS, More Is Better PostgreSQL 15 Scaling Factor: 1000 - Clients: 1000 - Mode: Read Only Test-Node-1-all-test-mode 50K 100K 150K 200K 250K SE +/- 1766.92, N = 3 244009 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
OpenBenchmarking.org ms, Fewer Is Better PostgreSQL 15 Scaling Factor: 1000 - Clients: 1000 - Mode: Read Only - Average Latency Test-Node-1-all-test-mode 0.9223 1.8446 2.7669 3.6892 4.6115 SE +/- 0.030, N = 3 4.099 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
OpenBenchmarking.org TPS, More Is Better PostgreSQL 15 Scaling Factor: 1000 - Clients: 250 - Mode: Read Write Test-Node-1-all-test-mode 2K 4K 6K 8K 10K SE +/- 55.00, N = 3 11355 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
OpenBenchmarking.org ms, Fewer Is Better PostgreSQL 15 Scaling Factor: 1000 - Clients: 250 - Mode: Read Write - Average Latency Test-Node-1-all-test-mode 5 10 15 20 25 SE +/- 0.11, N = 3 22.02 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
OpenBenchmarking.org TPS, More Is Better PostgreSQL 15 Scaling Factor: 1000 - Clients: 500 - Mode: Read Write Test-Node-1-all-test-mode 2K 4K 6K 8K 10K SE +/- 4.43, N = 3 11591 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
OpenBenchmarking.org ms, Fewer Is Better PostgreSQL 15 Scaling Factor: 1000 - Clients: 500 - Mode: Read Write - Average Latency Test-Node-1-all-test-mode 10 20 30 40 50 SE +/- 0.02, N = 3 43.14 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
Scaling Factor: 1000 - Clients: 5000 - Mode: Read Only
Test-Node-1-all-test-mode: The test run did not produce a result. E: pgbench: error: need at least 5003 open files, but system limit is 1024
OpenBenchmarking.org TPS, More Is Better PostgreSQL 15 Scaling Factor: 1000 - Clients: 800 - Mode: Read Write Test-Node-1-all-test-mode 2K 4K 6K 8K 10K SE +/- 39.50, N = 3 11099 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
OpenBenchmarking.org ms, Fewer Is Better PostgreSQL 15 Scaling Factor: 1000 - Clients: 800 - Mode: Read Write - Average Latency Test-Node-1-all-test-mode 16 32 48 64 80 SE +/- 0.26, N = 3 72.08 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
OpenBenchmarking.org TPS, More Is Better PostgreSQL 15 Scaling Factor: 10000 - Clients: 100 - Mode: Read Only Test-Node-1-all-test-mode 60K 120K 180K 240K 300K SE +/- 2262.68, N = 3 266577 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
OpenBenchmarking.org ms, Fewer Is Better PostgreSQL 15 Scaling Factor: 10000 - Clients: 100 - Mode: Read Only - Average Latency Test-Node-1-all-test-mode 0.0844 0.1688 0.2532 0.3376 0.422 SE +/- 0.003, N = 3 0.375 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
OpenBenchmarking.org TPS, More Is Better PostgreSQL 15 Scaling Factor: 10000 - Clients: 250 - Mode: Read Only Test-Node-1-all-test-mode 50K 100K 150K 200K 250K SE +/- 2639.97, N = 9 235161 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
OpenBenchmarking.org ms, Fewer Is Better PostgreSQL 15 Scaling Factor: 10000 - Clients: 250 - Mode: Read Only - Average Latency Test-Node-1-all-test-mode 0.2394 0.4788 0.7182 0.9576 1.197 SE +/- 0.012, N = 9 1.064 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
OpenBenchmarking.org TPS, More Is Better PostgreSQL 15 Scaling Factor: 10000 - Clients: 50 - Mode: Read Write Test-Node-1-all-test-mode 1600 3200 4800 6400 8000 SE +/- 204.27, N = 6 7320 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
OpenBenchmarking.org ms, Fewer Is Better PostgreSQL 15 Scaling Factor: 10000 - Clients: 50 - Mode: Read Write - Average Latency Test-Node-1-all-test-mode 2 4 6 8 10 SE +/- 0.196, N = 6 6.858 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
OpenBenchmarking.org TPS, More Is Better PostgreSQL 15 Scaling Factor: 10000 - Clients: 500 - Mode: Read Only Test-Node-1-all-test-mode 40K 80K 120K 160K 200K SE +/- 3262.54, N = 9 200548 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
OpenBenchmarking.org ms, Fewer Is Better PostgreSQL 15 Scaling Factor: 10000 - Clients: 500 - Mode: Read Only - Average Latency Test-Node-1-all-test-mode 0.5621 1.1242 1.6863 2.2484 2.8105 SE +/- 0.041, N = 9 2.498 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
OpenBenchmarking.org TPS, More Is Better PostgreSQL 15 Scaling Factor: 10000 - Clients: 800 - Mode: Read Only Test-Node-1-all-test-mode 40K 80K 120K 160K 200K SE +/- 4323.67, N = 9 183844 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
OpenBenchmarking.org ms, Fewer Is Better PostgreSQL 15 Scaling Factor: 10000 - Clients: 800 - Mode: Read Only - Average Latency Test-Node-1-all-test-mode 0.9835 1.967 2.9505 3.934 4.9175 SE +/- 0.104, N = 9 4.371 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
OpenBenchmarking.org TPS, More Is Better PostgreSQL 15 Scaling Factor: 25000 - Clients: 100 - Mode: Read Only Test-Node-1-all-test-mode 50K 100K 150K 200K 250K SE +/- 189.42, N = 3 226765 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
OpenBenchmarking.org ms, Fewer Is Better PostgreSQL 15 Scaling Factor: 25000 - Clients: 100 - Mode: Read Only - Average Latency Test-Node-1-all-test-mode 0.0992 0.1984 0.2976 0.3968 0.496 SE +/- 0.001, N = 3 0.441 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
OpenBenchmarking.org TPS, More Is Better PostgreSQL 15 Scaling Factor: 25000 - Clients: 250 - Mode: Read Only Test-Node-1-all-test-mode 40K 80K 120K 160K 200K SE +/- 177.48, N = 3 199456 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
OpenBenchmarking.org ms, Fewer Is Better PostgreSQL 15 Scaling Factor: 25000 - Clients: 250 - Mode: Read Only - Average Latency Test-Node-1-all-test-mode 0.2822 0.5644 0.8466 1.1288 1.411 SE +/- 0.001, N = 3 1.254 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
OpenBenchmarking.org TPS, More Is Better PostgreSQL 15 Scaling Factor: 25000 - Clients: 50 - Mode: Read Write Test-Node-1-all-test-mode 1100 2200 3300 4400 5500 SE +/- 82.74, N = 3 5136 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
OpenBenchmarking.org ms, Fewer Is Better PostgreSQL 15 Scaling Factor: 25000 - Clients: 50 - Mode: Read Write - Average Latency Test-Node-1-all-test-mode 3 6 9 12 15 SE +/- 0.157, N = 3 9.739 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
OpenBenchmarking.org TPS, More Is Better PostgreSQL 15 Scaling Factor: 25000 - Clients: 500 - Mode: Read Only Test-Node-1-all-test-mode 40K 80K 120K 160K 200K SE +/- 2400.15, N = 3 169641 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
OpenBenchmarking.org ms, Fewer Is Better PostgreSQL 15 Scaling Factor: 25000 - Clients: 500 - Mode: Read Only - Average Latency Test-Node-1-all-test-mode 0.6635 1.327 1.9905 2.654 3.3175 SE +/- 0.042, N = 3 2.949 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
OpenBenchmarking.org TPS, More Is Better PostgreSQL 15 Scaling Factor: 25000 - Clients: 800 - Mode: Read Only Test-Node-1-all-test-mode 30K 60K 90K 120K 150K SE +/- 807.89, N = 3 156955 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
OpenBenchmarking.org ms, Fewer Is Better PostgreSQL 15 Scaling Factor: 25000 - Clients: 800 - Mode: Read Only - Average Latency Test-Node-1-all-test-mode 1.1468 2.2936 3.4404 4.5872 5.734 SE +/- 0.026, N = 3 5.097 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
OpenBenchmarking.org TPS, More Is Better PostgreSQL 15 Scaling Factor: 1000 - Clients: 1000 - Mode: Read Write Test-Node-1-all-test-mode 2K 4K 6K 8K 10K SE +/- 20.27, N = 3 10986 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
OpenBenchmarking.org ms, Fewer Is Better PostgreSQL 15 Scaling Factor: 1000 - Clients: 1000 - Mode: Read Write - Average Latency Test-Node-1-all-test-mode 20 40 60 80 100 SE +/- 0.17, N = 3 91.02 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
Scaling Factor: 1000 - Clients: 5000 - Mode: Read Write
Test-Node-1-all-test-mode: The test run did not produce a result. E: pgbench: error: need at least 5003 open files, but system limit is 1024
OpenBenchmarking.org TPS, More Is Better PostgreSQL 15 Scaling Factor: 10000 - Clients: 100 - Mode: Read Write Test-Node-1-all-test-mode 1400 2800 4200 5600 7000 SE +/- 85.54, N = 3 6677 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
OpenBenchmarking.org ms, Fewer Is Better PostgreSQL 15 Scaling Factor: 10000 - Clients: 100 - Mode: Read Write - Average Latency Test-Node-1-all-test-mode 4 8 12 16 20 SE +/- 0.19, N = 3 14.98 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
OpenBenchmarking.org TPS, More Is Better PostgreSQL 15 Scaling Factor: 10000 - Clients: 1000 - Mode: Read Only Test-Node-1-all-test-mode 40K 80K 120K 160K 200K SE +/- 4407.65, N = 9 168648 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
OpenBenchmarking.org ms, Fewer Is Better PostgreSQL 15 Scaling Factor: 10000 - Clients: 1000 - Mode: Read Only - Average Latency Test-Node-1-all-test-mode 1.3412 2.6824 4.0236 5.3648 6.706 SE +/- 0.152, N = 9 5.961 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
OpenBenchmarking.org TPS, More Is Better PostgreSQL 15 Scaling Factor: 10000 - Clients: 250 - Mode: Read Write Test-Node-1-all-test-mode 2K 4K 6K 8K 10K SE +/- 88.91, N = 3 9516 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
OpenBenchmarking.org ms, Fewer Is Better PostgreSQL 15 Scaling Factor: 10000 - Clients: 250 - Mode: Read Write - Average Latency Test-Node-1-all-test-mode 6 12 18 24 30 SE +/- 0.24, N = 3 26.28 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
OpenBenchmarking.org TPS, More Is Better PostgreSQL 15 Scaling Factor: 10000 - Clients: 500 - Mode: Read Write Test-Node-1-all-test-mode 2K 4K 6K 8K 10K SE +/- 64.39, N = 3 9611 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
OpenBenchmarking.org ms, Fewer Is Better PostgreSQL 15 Scaling Factor: 10000 - Clients: 500 - Mode: Read Write - Average Latency Test-Node-1-all-test-mode 12 24 36 48 60 SE +/- 0.35, N = 3 52.03 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
Scaling Factor: 10000 - Clients: 5000 - Mode: Read Only
Test-Node-1-all-test-mode: The test run did not produce a result. E: pgbench: error: need at least 5003 open files, but system limit is 1024
OpenBenchmarking.org TPS, More Is Better PostgreSQL 15 Scaling Factor: 10000 - Clients: 800 - Mode: Read Write Test-Node-1-all-test-mode 2K 4K 6K 8K 10K SE +/- 42.13, N = 3 9455 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
OpenBenchmarking.org ms, Fewer Is Better PostgreSQL 15 Scaling Factor: 10000 - Clients: 800 - Mode: Read Write - Average Latency Test-Node-1-all-test-mode 20 40 60 80 100 SE +/- 0.38, N = 3 84.62 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
OpenBenchmarking.org TPS, More Is Better PostgreSQL 15 Scaling Factor: 25000 - Clients: 100 - Mode: Read Write Test-Node-1-all-test-mode 1300 2600 3900 5200 6500 SE +/- 55.39, N = 3 6104 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
OpenBenchmarking.org ms, Fewer Is Better PostgreSQL 15 Scaling Factor: 25000 - Clients: 100 - Mode: Read Write - Average Latency Test-Node-1-all-test-mode 4 8 12 16 20 SE +/- 0.15, N = 3 16.38 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
OpenBenchmarking.org TPS, More Is Better PostgreSQL 15 Scaling Factor: 25000 - Clients: 1000 - Mode: Read Only Test-Node-1-all-test-mode 30K 60K 90K 120K 150K SE +/- 2123.43, N = 3 148062 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
OpenBenchmarking.org ms, Fewer Is Better PostgreSQL 15 Scaling Factor: 25000 - Clients: 1000 - Mode: Read Only - Average Latency Test-Node-1-all-test-mode 2 4 6 8 10 SE +/- 0.098, N = 3 6.757 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
OpenBenchmarking.org TPS, More Is Better PostgreSQL 15 Scaling Factor: 25000 - Clients: 250 - Mode: Read Write Test-Node-1-all-test-mode 2K 4K 6K 8K 10K SE +/- 97.82, N = 3 8712 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
OpenBenchmarking.org ms, Fewer Is Better PostgreSQL 15 Scaling Factor: 25000 - Clients: 250 - Mode: Read Write - Average Latency Test-Node-1-all-test-mode 7 14 21 28 35 SE +/- 0.32, N = 3 28.71 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
OpenBenchmarking.org TPS, More Is Better PostgreSQL 15 Scaling Factor: 25000 - Clients: 500 - Mode: Read Write Test-Node-1-all-test-mode 2K 4K 6K 8K 10K SE +/- 13.59, N = 3 9232 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
OpenBenchmarking.org ms, Fewer Is Better PostgreSQL 15 Scaling Factor: 25000 - Clients: 500 - Mode: Read Write - Average Latency Test-Node-1-all-test-mode 12 24 36 48 60 SE +/- 0.08, N = 3 54.16 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
Scaling Factor: 25000 - Clients: 5000 - Mode: Read Only
Test-Node-1-all-test-mode: The test run did not produce a result. E: pgbench: error: need at least 5003 open files, but system limit is 1024
OpenBenchmarking.org TPS, More Is Better PostgreSQL 15 Scaling Factor: 25000 - Clients: 800 - Mode: Read Write Test-Node-1-all-test-mode 2K 4K 6K 8K 10K SE +/- 13.74, N = 3 9152 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
OpenBenchmarking.org ms, Fewer Is Better PostgreSQL 15 Scaling Factor: 25000 - Clients: 800 - Mode: Read Write - Average Latency Test-Node-1-all-test-mode 20 40 60 80 100 SE +/- 0.13, N = 3 87.42 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
OpenBenchmarking.org TPS, More Is Better PostgreSQL 15 Scaling Factor: 10000 - Clients: 1000 - Mode: Read Write Test-Node-1-all-test-mode 2K 4K 6K 8K 10K SE +/- 56.80, N = 3 9242 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
OpenBenchmarking.org ms, Fewer Is Better PostgreSQL 15 Scaling Factor: 10000 - Clients: 1000 - Mode: Read Write - Average Latency Test-Node-1-all-test-mode 20 40 60 80 100 SE +/- 0.66, N = 3 108.21 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
Scaling Factor: 10000 - Clients: 5000 - Mode: Read Write
Test-Node-1-all-test-mode: The test run did not produce a result. E: pgbench: error: need at least 5003 open files, but system limit is 1024
OpenBenchmarking.org TPS, More Is Better PostgreSQL 15 Scaling Factor: 25000 - Clients: 1000 - Mode: Read Write Test-Node-1-all-test-mode 2K 4K 6K 8K 10K SE +/- 47.58, N = 3 8880 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
OpenBenchmarking.org ms, Fewer Is Better PostgreSQL 15 Scaling Factor: 25000 - Clients: 1000 - Mode: Read Write - Average Latency Test-Node-1-all-test-mode 30 60 90 120 150 SE +/- 0.61, N = 3 112.63 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
Scaling Factor: 25000 - Clients: 5000 - Mode: Read Write
Test-Node-1-all-test-mode: The test run did not produce a result. E: pgbench: error: need at least 5003 open files, but system limit is 1024
Test-Node-1-all-test-mode Processor: 2 x Intel Xeon Silver 4110 (16 Cores / 32 Threads), Motherboard: Quanta Cloud QuantaPlex T42S-2U (LBG-1G) MB (Lewisburg-1G) (3A12.Q302 BIOS), Chipset: Intel Sky Lake-E DMI3 Registers, Memory: 8 x 32GB DDR4-2400MT/s, Disk: 6 x 960GB SAMSUNG MZ7KM960, Graphics: ASPEED, Network: 2 x Intel X722 for 10GBASE-T + 2 x Intel 82599ES 10-Gigabit SFI/SFP+
OS: Ubuntu 22.04, Kernel: 5.15.0-78-generic (x86_64), Vulkan: 1.3.255, Compiler: GCC 11.4.0, File-System: ext4, Screen Resolution: 1024x768
Kernel Notes: Transparent Huge Pages: madviseCompiler Notes: --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-XeT9lY/gcc-11-11.4.0/debian/tmp-nvptx/usr,amdgcn-amdhsa=/build/gcc-11-XeT9lY/gcc-11-11.4.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 -vProcessor Notes: CPU Microcode: 0x2007006Security Notes: 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: Mitigation of Clear buffers; SMT vulnerable + retbleed: Mitigation of IBRS + 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 IBRS IBPB: conditional STIBP: conditional RSB filling PBRSB-eIBRS: Not affected + srbds: Not affected + tsx_async_abort: Mitigation of Clear buffers; SMT vulnerable
Testing initiated at 26 April 2024 23:15 by user ikbalpermana.