Test-Node-1-all-test-mode

Test-Node-1-all-test-mode

Compare your own system(s) to this result file with the Phoronix Test Suite by running the command: phoronix-test-suite benchmark 2405024-IKBA-TESTNOD18
Jump To Table - Results

Statistics

Remove Outliers Before Calculating Averages

Graph Settings

Prefer Vertical Bar Graphs

Multi-Way Comparison

Condense Multi-Option Tests Into Single Result Graphs

Table

Show Detailed System Result Table

Run Management

Result
Identifier
Performance Per
Dollar
Date
Run
  Test
  Duration
Test-Node-1-all-test-mode
April 26
 
Only show results matching title/arguments (delimit multiple options with a comma):
Do not show results matching title/arguments (delimit multiple options with a comma):


Test-Node-1-all-test-modeOpenBenchmarking.orgPhoronix Test Suite2 x Intel Xeon Silver 4110 (16 Cores / 32 Threads)Quanta Cloud QuantaPlex T42S-2U (LBG-1G) MB (Lewisburg-1G) (3A12.Q302 BIOS)Intel Sky Lake-E DMI3 Registers8 x 32GB DDR4-2400MT/s6 x 960GB SAMSUNG MZ7KM960ASPEED2 x Intel X722 for 10GBASE-T + 2 x Intel 82599ES 10-Gigabit SFI/SFP+Ubuntu 22.045.15.0-78-generic (x86_64)1.3.255GCC 11.4.0ext41024x768ProcessorMotherboardChipsetMemoryDiskGraphicsNetworkOSKernelVulkanCompilerFile-SystemScreen ResolutionTest-Node-1-all-test-mode BenchmarksSystem Logs- Transparent Huge Pages: madvise- --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 -v - CPU Microcode: 0x2007006- 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

Test-Node-1-all-test-modepgbench: 1 - 1 - Read Onlypgbench: 1 - 1 - Read Only - Average Latencypgbench: 1 - 1 - Read Writepgbench: 1 - 1 - Read Write - Average Latencypgbench: 1 - 50 - Read Onlypgbench: 1 - 50 - Read Only - Average Latencypgbench: 1 - 100 - Read Onlypgbench: 1 - 100 - Read Only - Average Latencypgbench: 1 - 250 - Read Onlypgbench: 1 - 250 - Read Only - Average Latencypgbench: 1 - 50 - Read Writepgbench: 1 - 50 - Read Write - Average Latencypgbench: 1 - 500 - Read Onlypgbench: 1 - 500 - Read Only - Average Latencypgbench: 1 - 800 - Read Onlypgbench: 1 - 800 - Read Only - Average Latencypgbench: 100 - 1 - Read Onlypgbench: 100 - 1 - Read Only - Average Latencypgbench: 1 - 100 - Read Writepgbench: 1 - 100 - Read Write - Average Latencypgbench: 1 - 1000 - Read Onlypgbench: 1 - 1000 - Read Only - Average Latencypgbench: 1 - 250 - Read Writepgbench: 1 - 250 - Read Write - Average Latencypgbench: 1 - 500 - Read Writepgbench: 1 - 500 - Read Write - Average Latencypgbench: 1 - 800 - Read Writepgbench: 1 - 800 - Read Write - Average Latencypgbench: 100 - 1 - Read Writepgbench: 100 - 1 - Read Write - Average Latencypgbench: 100 - 50 - Read Onlypgbench: 100 - 50 - Read Only - Average Latencypgbench: 1000 - 1 - Read Onlypgbench: 1000 - 1 - Read Only - Average Latencypgbench: 1 - 1000 - Read Writepgbench: 1 - 1000 - Read Write - Average Latencypgbench: 100 - 100 - Read Onlypgbench: 100 - 100 - Read Only - Average Latencypgbench: 100 - 250 - Read Onlypgbench: 100 - 250 - Read Only - Average Latencypgbench: 100 - 50 - Read Writepgbench: 100 - 50 - Read Write - Average Latencypgbench: 100 - 500 - Read Onlypgbench: 100 - 500 - Read Only - Average Latencypgbench: 100 - 800 - Read Onlypgbench: 100 - 800 - Read Only - Average Latencypgbench: 1000 - 1 - Read Writepgbench: 1000 - 1 - Read Write - Average Latencypgbench: 1000 - 50 - Read Onlypgbench: 1000 - 50 - Read Only - Average Latencypgbench: 10000 - 1 - Read Onlypgbench: 10000 - 1 - Read Only - Average Latencypgbench: 25000 - 1 - Read Onlypgbench: 25000 - 1 - Read Only - Average Latencypgbench: 100 - 100 - Read Writepgbench: 100 - 100 - Read Write - Average Latencypgbench: 100 - 1000 - Read Onlypgbench: 100 - 1000 - Read Only - Average Latencypgbench: 100 - 250 - Read Writepgbench: 100 - 250 - Read Write - Average Latencypgbench: 100 - 500 - Read Writepgbench: 100 - 500 - Read Write - Average Latencypgbench: 100 - 800 - Read Writepgbench: 100 - 800 - Read Write - Average Latencypgbench: 1000 - 100 - Read Onlypgbench: 1000 - 100 - Read Only - Average Latencypgbench: 1000 - 250 - Read Onlypgbench: 1000 - 250 - Read Only - Average Latencypgbench: 1000 - 50 - Read Writepgbench: 1000 - 50 - Read Write - Average Latencypgbench: 1000 - 500 - Read Onlypgbench: 1000 - 500 - Read Only - Average Latencypgbench: 1000 - 800 - Read Onlypgbench: 1000 - 800 - Read Only - Average Latencypgbench: 10000 - 1 - Read Writepgbench: 10000 - 1 - Read Write - Average Latencypgbench: 10000 - 50 - Read Onlypgbench: 10000 - 50 - Read Only - Average Latencypgbench: 25000 - 1 - Read Writepgbench: 25000 - 1 - Read Write - Average Latencypgbench: 25000 - 50 - Read Onlypgbench: 25000 - 50 - Read Only - Average Latencypgbench: 100 - 1000 - Read Writepgbench: 100 - 1000 - Read Write - Average Latencypgbench: 1000 - 100 - Read Writepgbench: 1000 - 100 - Read Write - Average Latencypgbench: 1000 - 1000 - Read Onlypgbench: 1000 - 1000 - Read Only - Average Latencypgbench: 1000 - 250 - Read Writepgbench: 1000 - 250 - Read Write - Average Latencypgbench: 1000 - 500 - Read Writepgbench: 1000 - 500 - Read Write - Average Latencypgbench: 1000 - 800 - Read Writepgbench: 1000 - 800 - Read Write - Average Latencypgbench: 10000 - 100 - Read Onlypgbench: 10000 - 100 - Read Only - Average Latencypgbench: 10000 - 250 - Read Onlypgbench: 10000 - 250 - Read Only - Average Latencypgbench: 10000 - 50 - Read Writepgbench: 10000 - 50 - Read Write - Average Latencypgbench: 10000 - 500 - Read Onlypgbench: 10000 - 500 - Read Only - Average Latencypgbench: 10000 - 800 - Read Onlypgbench: 10000 - 800 - Read Only - Average Latencypgbench: 25000 - 100 - Read Onlypgbench: 25000 - 100 - Read Only - Average Latencypgbench: 25000 - 250 - Read Onlypgbench: 25000 - 250 - Read Only - Average Latencypgbench: 25000 - 50 - Read Writepgbench: 25000 - 50 - Read Write - Average Latencypgbench: 25000 - 500 - Read Onlypgbench: 25000 - 500 - Read Only - Average Latencypgbench: 25000 - 800 - Read Onlypgbench: 25000 - 800 - Read Only - Average Latencypgbench: 1000 - 1000 - Read Writepgbench: 1000 - 1000 - Read Write - Average Latencypgbench: 10000 - 100 - Read Writepgbench: 10000 - 100 - Read Write - Average Latencypgbench: 10000 - 1000 - Read Onlypgbench: 10000 - 1000 - Read Only - Average Latencypgbench: 10000 - 250 - Read Writepgbench: 10000 - 250 - Read Write - Average Latencypgbench: 10000 - 500 - Read Writepgbench: 10000 - 500 - Read Write - Average Latencypgbench: 10000 - 800 - Read Writepgbench: 10000 - 800 - Read Write - Average Latencypgbench: 25000 - 100 - Read Writepgbench: 25000 - 100 - Read Write - Average Latencypgbench: 25000 - 1000 - Read Onlypgbench: 25000 - 1000 - Read Only - Average Latencypgbench: 25000 - 250 - Read Writepgbench: 25000 - 250 - Read Write - Average Latencypgbench: 25000 - 500 - Read Writepgbench: 25000 - 500 - Read Write - Average Latencypgbench: 25000 - 800 - Read Writepgbench: 25000 - 800 - Read Write - Average Latencypgbench: 10000 - 1000 - Read Writepgbench: 10000 - 1000 - Read Write - Average Latencypgbench: 25000 - 1000 - Read Writepgbench: 25000 - 1000 - Read Write - Average Latencypgbench: 25000 - 5000 - Read WriteTest-Node-1-all-test-mode138120.0738921.1215283760.0955344930.1875445000.45979762.7425383800.9295180011.545130790.076692144.4734739852.112427585.2442172333.6432133774.3207341.3634959200.101117620.0851606247.0454866800.2054884410.512113244.4154673771.0704477101.7887111.4073613780.138108360.09442920.233162206.1654103692.4382259111.0672281821.9121901142.0803463970.2893129640.79987765.6972801341.7852553373.1336571.5213123210.1606011.6632149460.2331623261.608114918.7032440094.0991135522.0171159143.1371109972.0812665770.3752351611.06473206.8582005482.4981838444.3712267650.4411994561.25451369.7391696412.9491569555.0971098691.024667714.9821686485.961951626.275961152.030945584.616610416.3841480626.757871228.705923254.158915287.4169242108.2058880112.625OpenBenchmarking.org

PostgreSQL

This is a benchmark of PostgreSQL using the integrated pgbench for facilitating the database benchmarks. Learn more via the OpenBenchmarking.org test page.

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 15Scaling Factor: 1 - Clients: 1 - Mode: Read OnlyTest-Node-1-all-test-mode3K6K9K12K15KSE +/- 175.41, N = 12138121. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 15Scaling Factor: 1 - Clients: 1 - Mode: Read Only - Average LatencyTest-Node-1-all-test-mode0.01640.03280.04920.06560.082SE +/- 0.001, N = 120.0731. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 15Scaling Factor: 1 - Clients: 1 - Mode: Read WriteTest-Node-1-all-test-mode2004006008001000SE +/- 3.90, N = 38921. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 15Scaling Factor: 1 - Clients: 1 - Mode: Read Write - Average LatencyTest-Node-1-all-test-mode0.25220.50440.75661.00881.261SE +/- 0.005, N = 31.1211. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 15Scaling Factor: 1 - Clients: 50 - Mode: Read OnlyTest-Node-1-all-test-mode110K220K330K440K550KSE +/- 2632.28, N = 35283761. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 15Scaling Factor: 1 - Clients: 50 - Mode: Read Only - Average LatencyTest-Node-1-all-test-mode0.02140.04280.06420.08560.107SE +/- 0.000, N = 30.0951. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 15Scaling Factor: 1 - Clients: 100 - Mode: Read OnlyTest-Node-1-all-test-mode110K220K330K440K550KSE +/- 790.18, N = 35344931. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 15Scaling Factor: 1 - Clients: 100 - Mode: Read Only - Average LatencyTest-Node-1-all-test-mode0.04210.08420.12630.16840.2105SE +/- 0.000, N = 30.1871. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 15Scaling Factor: 1 - Clients: 250 - Mode: Read OnlyTest-Node-1-all-test-mode120K240K360K480K600KSE +/- 2235.72, N = 35445001. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 15Scaling Factor: 1 - Clients: 250 - Mode: Read Only - Average LatencyTest-Node-1-all-test-mode0.10330.20660.30990.41320.5165SE +/- 0.002, N = 30.4591. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 15Scaling Factor: 1 - Clients: 50 - Mode: Read WriteTest-Node-1-all-test-mode2004006008001000SE +/- 0.13, N = 37971. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 15Scaling Factor: 1 - Clients: 50 - Mode: Read Write - Average LatencyTest-Node-1-all-test-mode1428425670SE +/- 0.01, N = 362.741. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 15Scaling Factor: 1 - Clients: 500 - Mode: Read OnlyTest-Node-1-all-test-mode120K240K360K480K600KSE +/- 749.56, N = 35383801. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 15Scaling Factor: 1 - Clients: 500 - Mode: Read Only - Average LatencyTest-Node-1-all-test-mode0.2090.4180.6270.8361.045SE +/- 0.001, N = 30.9291. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 15Scaling Factor: 1 - Clients: 800 - Mode: Read OnlyTest-Node-1-all-test-mode110K220K330K440K550KSE +/- 2659.13, N = 35180011. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 15Scaling Factor: 1 - Clients: 800 - Mode: Read Only - Average LatencyTest-Node-1-all-test-mode0.34760.69521.04281.39041.738SE +/- 0.008, N = 31.5451. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 15Scaling Factor: 100 - Clients: 1 - Mode: Read OnlyTest-Node-1-all-test-mode3K6K9K12K15KSE +/- 86.32, N = 3130791. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 15Scaling Factor: 100 - Clients: 1 - Mode: Read Only - Average LatencyTest-Node-1-all-test-mode0.01710.03420.05130.06840.0855SE +/- 0.000, N = 30.0761. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 15Scaling Factor: 1 - Clients: 100 - Mode: Read WriteTest-Node-1-all-test-mode150300450600750SE +/- 5.60, N = 36921. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 15Scaling Factor: 1 - Clients: 100 - Mode: Read Write - Average LatencyTest-Node-1-all-test-mode306090120150SE +/- 1.18, N = 3144.471. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 15Scaling Factor: 1 - Clients: 1000 - Mode: Read OnlyTest-Node-1-all-test-mode100K200K300K400K500KSE +/- 5049.70, N = 124739851. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 15Scaling Factor: 1 - Clients: 1000 - Mode: Read Only - Average LatencyTest-Node-1-all-test-mode0.47520.95041.42561.90082.376SE +/- 0.022, N = 122.1121. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 15Scaling Factor: 1 - Clients: 250 - Mode: Read WriteTest-Node-1-all-test-mode90180270360450SE +/- 4.27, N = 34271. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 15Scaling Factor: 1 - Clients: 250 - Mode: Read Write - Average LatencyTest-Node-1-all-test-mode130260390520650SE +/- 5.79, N = 3585.241. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 15Scaling Factor: 1 - Clients: 500 - Mode: Read WriteTest-Node-1-all-test-mode50100150200250SE +/- 8.15, N = 122171. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 15Scaling Factor: 1 - Clients: 500 - Mode: Read Write - Average LatencyTest-Node-1-all-test-mode5001000150020002500SE +/- 78.75, N = 122333.641. (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.orgTPS, More Is BetterPostgreSQL 15Scaling Factor: 1 - Clients: 800 - Mode: Read WriteTest-Node-1-all-test-mode50100150200250SE +/- 3.81, N = 122131. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 15Scaling Factor: 1 - Clients: 800 - Mode: Read Write - Average LatencyTest-Node-1-all-test-mode8001600240032004000SE +/- 69.08, N = 123774.321. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 15Scaling Factor: 100 - Clients: 1 - Mode: Read WriteTest-Node-1-all-test-mode160320480640800SE +/- 7.19, N = 37341. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 15Scaling Factor: 100 - Clients: 1 - Mode: Read Write - Average LatencyTest-Node-1-all-test-mode0.30670.61340.92011.22681.5335SE +/- 0.014, N = 31.3631. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 15Scaling Factor: 100 - Clients: 50 - Mode: Read OnlyTest-Node-1-all-test-mode110K220K330K440K550KSE +/- 1728.06, N = 34959201. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 15Scaling Factor: 100 - Clients: 50 - Mode: Read Only - Average LatencyTest-Node-1-all-test-mode0.02270.04540.06810.09080.1135SE +/- 0.000, N = 30.1011. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 15Scaling Factor: 1000 - Clients: 1 - Mode: Read OnlyTest-Node-1-all-test-mode3K6K9K12K15KSE +/- 101.75, N = 3117621. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 15Scaling Factor: 1000 - Clients: 1 - Mode: Read Only - Average LatencyTest-Node-1-all-test-mode0.01910.03820.05730.07640.0955SE +/- 0.001, N = 30.0851. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 15Scaling Factor: 1 - Clients: 1000 - Mode: Read WriteTest-Node-1-all-test-mode4080120160200SE +/- 1.75, N = 41601. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 15Scaling Factor: 1 - Clients: 1000 - Mode: Read Write - Average LatencyTest-Node-1-all-test-mode13002600390052006500SE +/- 68.80, N = 46247.051. (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.orgTPS, More Is BetterPostgreSQL 15Scaling Factor: 100 - Clients: 100 - Mode: Read OnlyTest-Node-1-all-test-mode100K200K300K400K500KSE +/- 1822.29, N = 34866801. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 15Scaling Factor: 100 - Clients: 100 - Mode: Read Only - Average LatencyTest-Node-1-all-test-mode0.04610.09220.13830.18440.2305SE +/- 0.001, N = 30.2051. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 15Scaling Factor: 100 - Clients: 250 - Mode: Read OnlyTest-Node-1-all-test-mode100K200K300K400K500KSE +/- 2830.83, N = 34884411. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 15Scaling Factor: 100 - Clients: 250 - Mode: Read Only - Average LatencyTest-Node-1-all-test-mode0.11520.23040.34560.46080.576SE +/- 0.003, N = 30.5121. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 15Scaling Factor: 100 - Clients: 50 - Mode: Read WriteTest-Node-1-all-test-mode2K4K6K8K10KSE +/- 13.13, N = 3113241. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 15Scaling Factor: 100 - Clients: 50 - Mode: Read Write - Average LatencyTest-Node-1-all-test-mode0.99341.98682.98023.97364.967SE +/- 0.005, N = 34.4151. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 15Scaling Factor: 100 - Clients: 500 - Mode: Read OnlyTest-Node-1-all-test-mode100K200K300K400K500KSE +/- 1542.96, N = 34673771. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 15Scaling Factor: 100 - Clients: 500 - Mode: Read Only - Average LatencyTest-Node-1-all-test-mode0.24080.48160.72240.96321.204SE +/- 0.003, N = 31.0701. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 15Scaling Factor: 100 - Clients: 800 - Mode: Read OnlyTest-Node-1-all-test-mode100K200K300K400K500KSE +/- 3742.40, N = 84477101. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 15Scaling Factor: 100 - Clients: 800 - Mode: Read Only - Average LatencyTest-Node-1-all-test-mode0.40230.80461.20691.60922.0115SE +/- 0.015, N = 81.7881. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 15Scaling Factor: 1000 - Clients: 1 - Mode: Read WriteTest-Node-1-all-test-mode150300450600750SE +/- 2.58, N = 37111. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 15Scaling Factor: 1000 - Clients: 1 - Mode: Read Write - Average LatencyTest-Node-1-all-test-mode0.31660.63320.94981.26641.583SE +/- 0.005, N = 31.4071. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 15Scaling Factor: 1000 - Clients: 50 - Mode: Read OnlyTest-Node-1-all-test-mode80K160K240K320K400KSE +/- 2377.34, N = 33613781. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 15Scaling Factor: 1000 - Clients: 50 - Mode: Read Only - Average LatencyTest-Node-1-all-test-mode0.03110.06220.09330.12440.1555SE +/- 0.001, N = 30.1381. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 15Scaling Factor: 10000 - Clients: 1 - Mode: Read OnlyTest-Node-1-all-test-mode2K4K6K8K10KSE +/- 417.30, N = 9108361. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 15Scaling Factor: 10000 - Clients: 1 - Mode: Read Only - Average LatencyTest-Node-1-all-test-mode0.02120.04240.06360.08480.106SE +/- 0.005, N = 90.0941. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 15Scaling Factor: 25000 - Clients: 1 - Mode: Read OnlyTest-Node-1-all-test-mode9001800270036004500SE +/- 41.11, N = 342921. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 15Scaling Factor: 25000 - Clients: 1 - Mode: Read Only - Average LatencyTest-Node-1-all-test-mode0.05240.10480.15720.20960.262SE +/- 0.002, N = 30.2331. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 15Scaling Factor: 100 - Clients: 100 - Mode: Read WriteTest-Node-1-all-test-mode3K6K9K12K15KSE +/- 29.05, N = 3162201. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 15Scaling Factor: 100 - Clients: 100 - Mode: Read Write - Average LatencyTest-Node-1-all-test-mode246810SE +/- 0.011, N = 36.1651. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 15Scaling Factor: 100 - Clients: 1000 - Mode: Read OnlyTest-Node-1-all-test-mode90K180K270K360K450KSE +/- 5017.87, N = 34103691. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 15Scaling Factor: 100 - Clients: 1000 - Mode: Read Only - Average LatencyTest-Node-1-all-test-mode0.54861.09721.64582.19442.743SE +/- 0.029, N = 32.4381. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 15Scaling Factor: 100 - Clients: 250 - Mode: Read WriteTest-Node-1-all-test-mode5K10K15K20K25KSE +/- 8.07, N = 3225911. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 15Scaling Factor: 100 - Clients: 250 - Mode: Read Write - Average LatencyTest-Node-1-all-test-mode3691215SE +/- 0.00, N = 311.071. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 15Scaling Factor: 100 - Clients: 500 - Mode: Read WriteTest-Node-1-all-test-mode5K10K15K20K25KSE +/- 25.67, N = 3228181. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 15Scaling Factor: 100 - Clients: 500 - Mode: Read Write - Average LatencyTest-Node-1-all-test-mode510152025SE +/- 0.02, N = 321.911. (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.orgTPS, More Is BetterPostgreSQL 15Scaling Factor: 100 - Clients: 800 - Mode: Read WriteTest-Node-1-all-test-mode4K8K12K16K20KSE +/- 29.82, N = 3190111. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 15Scaling Factor: 100 - Clients: 800 - Mode: Read Write - Average LatencyTest-Node-1-all-test-mode1020304050SE +/- 0.07, N = 342.081. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 15Scaling Factor: 1000 - Clients: 100 - Mode: Read OnlyTest-Node-1-all-test-mode70K140K210K280K350KSE +/- 312.00, N = 33463971. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 15Scaling Factor: 1000 - Clients: 100 - Mode: Read Only - Average LatencyTest-Node-1-all-test-mode0.0650.130.1950.260.325SE +/- 0.000, N = 30.2891. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 15Scaling Factor: 1000 - Clients: 250 - Mode: Read OnlyTest-Node-1-all-test-mode70K140K210K280K350KSE +/- 553.78, N = 33129641. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 15Scaling Factor: 1000 - Clients: 250 - Mode: Read Only - Average LatencyTest-Node-1-all-test-mode0.17980.35960.53940.71920.899SE +/- 0.001, N = 30.7991. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 15Scaling Factor: 1000 - Clients: 50 - Mode: Read WriteTest-Node-1-all-test-mode2K4K6K8K10KSE +/- 9.45, N = 387761. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 15Scaling Factor: 1000 - Clients: 50 - Mode: Read Write - Average LatencyTest-Node-1-all-test-mode1.28182.56363.84545.12726.409SE +/- 0.006, N = 35.6971. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 15Scaling Factor: 1000 - Clients: 500 - Mode: Read OnlyTest-Node-1-all-test-mode60K120K180K240K300KSE +/- 848.56, N = 32801341. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 15Scaling Factor: 1000 - Clients: 500 - Mode: Read Only - Average LatencyTest-Node-1-all-test-mode0.40160.80321.20481.60642.008SE +/- 0.006, N = 31.7851. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 15Scaling Factor: 1000 - Clients: 800 - Mode: Read OnlyTest-Node-1-all-test-mode50K100K150K200K250KSE +/- 390.62, N = 32553371. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 15Scaling Factor: 1000 - Clients: 800 - Mode: Read Only - Average LatencyTest-Node-1-all-test-mode0.70491.40982.11472.81963.5245SE +/- 0.005, N = 33.1331. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 15Scaling Factor: 10000 - Clients: 1 - Mode: Read WriteTest-Node-1-all-test-mode140280420560700SE +/- 5.56, N = 36571. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 15Scaling Factor: 10000 - Clients: 1 - Mode: Read Write - Average LatencyTest-Node-1-all-test-mode0.34220.68441.02661.36881.711SE +/- 0.013, N = 31.5211. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 15Scaling Factor: 10000 - Clients: 50 - Mode: Read OnlyTest-Node-1-all-test-mode70K140K210K280K350KSE +/- 4104.12, N = 33123211. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 15Scaling Factor: 10000 - Clients: 50 - Mode: Read Only - Average LatencyTest-Node-1-all-test-mode0.0360.0720.1080.1440.18SE +/- 0.002, N = 30.1601. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 15Scaling Factor: 25000 - Clients: 1 - Mode: Read WriteTest-Node-1-all-test-mode130260390520650SE +/- 2.30, N = 36011. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 15Scaling Factor: 25000 - Clients: 1 - Mode: Read Write - Average LatencyTest-Node-1-all-test-mode0.37420.74841.12261.49681.871SE +/- 0.006, N = 31.6631. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 15Scaling Factor: 25000 - Clients: 50 - Mode: Read OnlyTest-Node-1-all-test-mode50K100K150K200K250KSE +/- 703.39, N = 32149461. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 15Scaling Factor: 25000 - Clients: 50 - Mode: Read Only - Average LatencyTest-Node-1-all-test-mode0.05240.10480.15720.20960.262SE +/- 0.001, N = 30.2331. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 15Scaling Factor: 100 - Clients: 1000 - Mode: Read WriteTest-Node-1-all-test-mode3K6K9K12K15KSE +/- 55.39, N = 3162321. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 15Scaling Factor: 100 - Clients: 1000 - Mode: Read Write - Average LatencyTest-Node-1-all-test-mode1428425670SE +/- 0.21, N = 361.611. (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.orgTPS, More Is BetterPostgreSQL 15Scaling Factor: 1000 - Clients: 100 - Mode: Read WriteTest-Node-1-all-test-mode2K4K6K8K10KSE +/- 18.04, N = 3114911. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 15Scaling Factor: 1000 - Clients: 100 - Mode: Read Write - Average LatencyTest-Node-1-all-test-mode246810SE +/- 0.014, N = 38.7031. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 15Scaling Factor: 1000 - Clients: 1000 - Mode: Read OnlyTest-Node-1-all-test-mode50K100K150K200K250KSE +/- 1766.92, N = 32440091. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 15Scaling Factor: 1000 - Clients: 1000 - Mode: Read Only - Average LatencyTest-Node-1-all-test-mode0.92231.84462.76693.68924.6115SE +/- 0.030, N = 34.0991. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 15Scaling Factor: 1000 - Clients: 250 - Mode: Read WriteTest-Node-1-all-test-mode2K4K6K8K10KSE +/- 55.00, N = 3113551. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 15Scaling Factor: 1000 - Clients: 250 - Mode: Read Write - Average LatencyTest-Node-1-all-test-mode510152025SE +/- 0.11, N = 322.021. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 15Scaling Factor: 1000 - Clients: 500 - Mode: Read WriteTest-Node-1-all-test-mode2K4K6K8K10KSE +/- 4.43, N = 3115911. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 15Scaling Factor: 1000 - Clients: 500 - Mode: Read Write - Average LatencyTest-Node-1-all-test-mode1020304050SE +/- 0.02, N = 343.141. (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.orgTPS, More Is BetterPostgreSQL 15Scaling Factor: 1000 - Clients: 800 - Mode: Read WriteTest-Node-1-all-test-mode2K4K6K8K10KSE +/- 39.50, N = 3110991. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 15Scaling Factor: 1000 - Clients: 800 - Mode: Read Write - Average LatencyTest-Node-1-all-test-mode1632486480SE +/- 0.26, N = 372.081. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 15Scaling Factor: 10000 - Clients: 100 - Mode: Read OnlyTest-Node-1-all-test-mode60K120K180K240K300KSE +/- 2262.68, N = 32665771. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 15Scaling Factor: 10000 - Clients: 100 - Mode: Read Only - Average LatencyTest-Node-1-all-test-mode0.08440.16880.25320.33760.422SE +/- 0.003, N = 30.3751. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 15Scaling Factor: 10000 - Clients: 250 - Mode: Read OnlyTest-Node-1-all-test-mode50K100K150K200K250KSE +/- 2639.97, N = 92351611. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 15Scaling Factor: 10000 - Clients: 250 - Mode: Read Only - Average LatencyTest-Node-1-all-test-mode0.23940.47880.71820.95761.197SE +/- 0.012, N = 91.0641. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 15Scaling Factor: 10000 - Clients: 50 - Mode: Read WriteTest-Node-1-all-test-mode16003200480064008000SE +/- 204.27, N = 673201. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 15Scaling Factor: 10000 - Clients: 50 - Mode: Read Write - Average LatencyTest-Node-1-all-test-mode246810SE +/- 0.196, N = 66.8581. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 15Scaling Factor: 10000 - Clients: 500 - Mode: Read OnlyTest-Node-1-all-test-mode40K80K120K160K200KSE +/- 3262.54, N = 92005481. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 15Scaling Factor: 10000 - Clients: 500 - Mode: Read Only - Average LatencyTest-Node-1-all-test-mode0.56211.12421.68632.24842.8105SE +/- 0.041, N = 92.4981. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 15Scaling Factor: 10000 - Clients: 800 - Mode: Read OnlyTest-Node-1-all-test-mode40K80K120K160K200KSE +/- 4323.67, N = 91838441. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 15Scaling Factor: 10000 - Clients: 800 - Mode: Read Only - Average LatencyTest-Node-1-all-test-mode0.98351.9672.95053.9344.9175SE +/- 0.104, N = 94.3711. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 15Scaling Factor: 25000 - Clients: 100 - Mode: Read OnlyTest-Node-1-all-test-mode50K100K150K200K250KSE +/- 189.42, N = 32267651. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 15Scaling Factor: 25000 - Clients: 100 - Mode: Read Only - Average LatencyTest-Node-1-all-test-mode0.09920.19840.29760.39680.496SE +/- 0.001, N = 30.4411. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 15Scaling Factor: 25000 - Clients: 250 - Mode: Read OnlyTest-Node-1-all-test-mode40K80K120K160K200KSE +/- 177.48, N = 31994561. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 15Scaling Factor: 25000 - Clients: 250 - Mode: Read Only - Average LatencyTest-Node-1-all-test-mode0.28220.56440.84661.12881.411SE +/- 0.001, N = 31.2541. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 15Scaling Factor: 25000 - Clients: 50 - Mode: Read WriteTest-Node-1-all-test-mode11002200330044005500SE +/- 82.74, N = 351361. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 15Scaling Factor: 25000 - Clients: 50 - Mode: Read Write - Average LatencyTest-Node-1-all-test-mode3691215SE +/- 0.157, N = 39.7391. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 15Scaling Factor: 25000 - Clients: 500 - Mode: Read OnlyTest-Node-1-all-test-mode40K80K120K160K200KSE +/- 2400.15, N = 31696411. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 15Scaling Factor: 25000 - Clients: 500 - Mode: Read Only - Average LatencyTest-Node-1-all-test-mode0.66351.3271.99052.6543.3175SE +/- 0.042, N = 32.9491. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 15Scaling Factor: 25000 - Clients: 800 - Mode: Read OnlyTest-Node-1-all-test-mode30K60K90K120K150KSE +/- 807.89, N = 31569551. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 15Scaling Factor: 25000 - Clients: 800 - Mode: Read Only - Average LatencyTest-Node-1-all-test-mode1.14682.29363.44044.58725.734SE +/- 0.026, N = 35.0971. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 15Scaling Factor: 1000 - Clients: 1000 - Mode: Read WriteTest-Node-1-all-test-mode2K4K6K8K10KSE +/- 20.27, N = 3109861. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 15Scaling Factor: 1000 - Clients: 1000 - Mode: Read Write - Average LatencyTest-Node-1-all-test-mode20406080100SE +/- 0.17, N = 391.021. (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.orgTPS, More Is BetterPostgreSQL 15Scaling Factor: 10000 - Clients: 100 - Mode: Read WriteTest-Node-1-all-test-mode14002800420056007000SE +/- 85.54, N = 366771. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 15Scaling Factor: 10000 - Clients: 100 - Mode: Read Write - Average LatencyTest-Node-1-all-test-mode48121620SE +/- 0.19, N = 314.981. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 15Scaling Factor: 10000 - Clients: 1000 - Mode: Read OnlyTest-Node-1-all-test-mode40K80K120K160K200KSE +/- 4407.65, N = 91686481. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 15Scaling Factor: 10000 - Clients: 1000 - Mode: Read Only - Average LatencyTest-Node-1-all-test-mode1.34122.68244.02365.36486.706SE +/- 0.152, N = 95.9611. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 15Scaling Factor: 10000 - Clients: 250 - Mode: Read WriteTest-Node-1-all-test-mode2K4K6K8K10KSE +/- 88.91, N = 395161. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 15Scaling Factor: 10000 - Clients: 250 - Mode: Read Write - Average LatencyTest-Node-1-all-test-mode612182430SE +/- 0.24, N = 326.281. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 15Scaling Factor: 10000 - Clients: 500 - Mode: Read WriteTest-Node-1-all-test-mode2K4K6K8K10KSE +/- 64.39, N = 396111. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 15Scaling Factor: 10000 - Clients: 500 - Mode: Read Write - Average LatencyTest-Node-1-all-test-mode1224364860SE +/- 0.35, N = 352.031. (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.orgTPS, More Is BetterPostgreSQL 15Scaling Factor: 10000 - Clients: 800 - Mode: Read WriteTest-Node-1-all-test-mode2K4K6K8K10KSE +/- 42.13, N = 394551. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 15Scaling Factor: 10000 - Clients: 800 - Mode: Read Write - Average LatencyTest-Node-1-all-test-mode20406080100SE +/- 0.38, N = 384.621. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 15Scaling Factor: 25000 - Clients: 100 - Mode: Read WriteTest-Node-1-all-test-mode13002600390052006500SE +/- 55.39, N = 361041. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 15Scaling Factor: 25000 - Clients: 100 - Mode: Read Write - Average LatencyTest-Node-1-all-test-mode48121620SE +/- 0.15, N = 316.381. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 15Scaling Factor: 25000 - Clients: 1000 - Mode: Read OnlyTest-Node-1-all-test-mode30K60K90K120K150KSE +/- 2123.43, N = 31480621. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 15Scaling Factor: 25000 - Clients: 1000 - Mode: Read Only - Average LatencyTest-Node-1-all-test-mode246810SE +/- 0.098, N = 36.7571. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 15Scaling Factor: 25000 - Clients: 250 - Mode: Read WriteTest-Node-1-all-test-mode2K4K6K8K10KSE +/- 97.82, N = 387121. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 15Scaling Factor: 25000 - Clients: 250 - Mode: Read Write - Average LatencyTest-Node-1-all-test-mode714212835SE +/- 0.32, N = 328.711. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 15Scaling Factor: 25000 - Clients: 500 - Mode: Read WriteTest-Node-1-all-test-mode2K4K6K8K10KSE +/- 13.59, N = 392321. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 15Scaling Factor: 25000 - Clients: 500 - Mode: Read Write - Average LatencyTest-Node-1-all-test-mode1224364860SE +/- 0.08, N = 354.161. (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.orgTPS, More Is BetterPostgreSQL 15Scaling Factor: 25000 - Clients: 800 - Mode: Read WriteTest-Node-1-all-test-mode2K4K6K8K10KSE +/- 13.74, N = 391521. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 15Scaling Factor: 25000 - Clients: 800 - Mode: Read Write - Average LatencyTest-Node-1-all-test-mode20406080100SE +/- 0.13, N = 387.421. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 15Scaling Factor: 10000 - Clients: 1000 - Mode: Read WriteTest-Node-1-all-test-mode2K4K6K8K10KSE +/- 56.80, N = 392421. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 15Scaling Factor: 10000 - Clients: 1000 - Mode: Read Write - Average LatencyTest-Node-1-all-test-mode20406080100SE +/- 0.66, N = 3108.211. (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.orgTPS, More Is BetterPostgreSQL 15Scaling Factor: 25000 - Clients: 1000 - Mode: Read WriteTest-Node-1-all-test-mode2K4K6K8K10KSE +/- 47.58, N = 388801. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 15Scaling Factor: 25000 - Clients: 1000 - Mode: Read Write - Average LatencyTest-Node-1-all-test-mode306090120150SE +/- 0.61, N = 3112.631. (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

140 Results Shown

PostgreSQL:
  1 - 1 - Read Only
  1 - 1 - Read Only - Average Latency
  1 - 1 - Read Write
  1 - 1 - Read Write - Average Latency
  1 - 50 - Read Only
  1 - 50 - Read Only - Average Latency
  1 - 100 - Read Only
  1 - 100 - Read Only - Average Latency
  1 - 250 - Read Only
  1 - 250 - Read Only - Average Latency
  1 - 50 - Read Write
  1 - 50 - Read Write - Average Latency
  1 - 500 - Read Only
  1 - 500 - Read Only - Average Latency
  1 - 800 - Read Only
  1 - 800 - Read Only - Average Latency
  100 - 1 - Read Only
  100 - 1 - Read Only - Average Latency
  1 - 100 - Read Write
  1 - 100 - Read Write - Average Latency
  1 - 1000 - Read Only
  1 - 1000 - Read Only - Average Latency
  1 - 250 - Read Write
  1 - 250 - Read Write - Average Latency
  1 - 500 - Read Write
  1 - 500 - Read Write - Average Latency
  1 - 800 - Read Write
  1 - 800 - Read Write - Average Latency
  100 - 1 - Read Write
  100 - 1 - Read Write - Average Latency
  100 - 50 - Read Only
  100 - 50 - Read Only - Average Latency
  1000 - 1 - Read Only
  1000 - 1 - Read Only - Average Latency
  1 - 1000 - Read Write
  1 - 1000 - Read Write - Average Latency
  100 - 100 - Read Only
  100 - 100 - Read Only - Average Latency
  100 - 250 - Read Only
  100 - 250 - Read Only - Average Latency
  100 - 50 - Read Write
  100 - 50 - Read Write - Average Latency
  100 - 500 - Read Only
  100 - 500 - Read Only - Average Latency
  100 - 800 - Read Only
  100 - 800 - Read Only - Average Latency
  1000 - 1 - Read Write
  1000 - 1 - Read Write - Average Latency
  1000 - 50 - Read Only
  1000 - 50 - Read Only - Average Latency
  10000 - 1 - Read Only
  10000 - 1 - Read Only - Average Latency
  25000 - 1 - Read Only
  25000 - 1 - Read Only - Average Latency
  100 - 100 - Read Write
  100 - 100 - Read Write - Average Latency
  100 - 1000 - Read Only
  100 - 1000 - Read Only - Average Latency
  100 - 250 - Read Write
  100 - 250 - Read Write - Average Latency
  100 - 500 - Read Write
  100 - 500 - Read Write - Average Latency
  100 - 800 - Read Write
  100 - 800 - Read Write - Average Latency
  1000 - 100 - Read Only
  1000 - 100 - Read Only - Average Latency
  1000 - 250 - Read Only
  1000 - 250 - Read Only - Average Latency
  1000 - 50 - Read Write
  1000 - 50 - Read Write - Average Latency
  1000 - 500 - Read Only
  1000 - 500 - Read Only - Average Latency
  1000 - 800 - Read Only
  1000 - 800 - Read Only - Average Latency
  10000 - 1 - Read Write
  10000 - 1 - Read Write - Average Latency
  10000 - 50 - Read Only
  10000 - 50 - Read Only - Average Latency
  25000 - 1 - Read Write
  25000 - 1 - Read Write - Average Latency
  25000 - 50 - Read Only
  25000 - 50 - Read Only - Average Latency
  100 - 1000 - Read Write
  100 - 1000 - Read Write - Average Latency
  1000 - 100 - Read Write
  1000 - 100 - Read Write - Average Latency
  1000 - 1000 - Read Only
  1000 - 1000 - Read Only - Average Latency
  1000 - 250 - Read Write
  1000 - 250 - Read Write - Average Latency
  1000 - 500 - Read Write
  1000 - 500 - Read Write - Average Latency
  1000 - 800 - Read Write
  1000 - 800 - Read Write - Average Latency
  10000 - 100 - Read Only
  10000 - 100 - Read Only - Average Latency
  10000 - 250 - Read Only
  10000 - 250 - Read Only - Average Latency
  10000 - 50 - Read Write
  10000 - 50 - Read Write - Average Latency
  10000 - 500 - Read Only
  10000 - 500 - Read Only - Average Latency
  10000 - 800 - Read Only
  10000 - 800 - Read Only - Average Latency
  25000 - 100 - Read Only
  25000 - 100 - Read Only - Average Latency
  25000 - 250 - Read Only
  25000 - 250 - Read Only - Average Latency
  25000 - 50 - Read Write
  25000 - 50 - Read Write - Average Latency
  25000 - 500 - Read Only
  25000 - 500 - Read Only - Average Latency
  25000 - 800 - Read Only
  25000 - 800 - Read Only - Average Latency
  1000 - 1000 - Read Write
  1000 - 1000 - Read Write - Average Latency
  10000 - 100 - Read Write
  10000 - 100 - Read Write - Average Latency
  10000 - 1000 - Read Only
  10000 - 1000 - Read Only - Average Latency
  10000 - 250 - Read Write
  10000 - 250 - Read Write - Average Latency
  10000 - 500 - Read Write
  10000 - 500 - Read Write - Average Latency
  10000 - 800 - Read Write
  10000 - 800 - Read Write - Average Latency
  25000 - 100 - Read Write
  25000 - 100 - Read Write - Average Latency
  25000 - 1000 - Read Only
  25000 - 1000 - Read Only - Average Latency
  25000 - 250 - Read Write
  25000 - 250 - Read Write - Average Latency
  25000 - 500 - Read Write
  25000 - 500 - Read Write - Average Latency
  25000 - 800 - Read Write
  25000 - 800 - Read Write - Average Latency
  10000 - 1000 - Read Write
  10000 - 1000 - Read Write - Average Latency
  25000 - 1000 - Read Write
  25000 - 1000 - Read Write - Average Latency