benchmark2 Processor: 32 x Intel Xeon E312xx (Sandy Bridge IBRS update) (32 Cores), Motherboard: QEMU Standard PC (i440FX + PIIX 1996) (1.15.0-1 BIOS), Chipset: Intel 440FX 82441FX PMC, Memory: 16 x GB RAM QEMU, Disk: 1100GB QEMU HDD, Graphics: Cirrus Logic GD 5446, Network: Red Hat Virtio device
OS: Ubuntu 22.04, Kernel: 5.15.0-100-generic (x86_64), Compiler: GCC 11.4.0, File-System: ext4, System Layer: microsoft
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 -vDisk Notes: NONE / discard,errors=remount-ro,relatime,rw / Block Size: 4096Processor Notes: CPU Microcode: 0x1000065Security Notes: gather_data_sampling: Not affected + itlb_multihit: Not affected + l1tf: Not affected + mds: Not affected + meltdown: Not affected + mmio_stale_data: Not affected + retbleed: Not affected + spec_rstack_overflow: Not affected + spec_store_bypass: Mitigation of SSB disabled via prctl and seccomp + spectre_v1: Mitigation of usercopy/swapgs barriers and __user pointer sanitization + spectre_v2: Mitigation of Retpolines IBPB: conditional IBRS_FW STIBP: disabled RSB filling PBRSB-eIBRS: Not affected + srbds: Not affected + tsx_async_abort: Not affected
benchmark2 OpenBenchmarking.org Phoronix Test Suite 32 x Intel Xeon E312xx (Sandy Bridge IBRS update) (32 Cores) QEMU Standard PC (i440FX + PIIX 1996) (1.15.0-1 BIOS) Intel 440FX 82441FX PMC 16 x GB RAM QEMU 1100GB QEMU HDD Cirrus Logic GD 5446 Red Hat Virtio device Ubuntu 22.04 5.15.0-100-generic (x86_64) GCC 11.4.0 ext4 microsoft Processor Motherboard Chipset Memory Disk Graphics Network OS Kernel Compiler File-System System Layer Benchmark2 Performance System 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 - NONE / discard,errors=remount-ro,relatime,rw / Block Size: 4096 - CPU Microcode: 0x1000065 - gather_data_sampling: Not affected + itlb_multihit: Not affected + l1tf: Not affected + mds: Not affected + meltdown: Not affected + mmio_stale_data: Not affected + retbleed: Not affected + spec_rstack_overflow: Not affected + spec_store_bypass: Mitigation of SSB disabled via prctl and seccomp + spectre_v1: Mitigation of usercopy/swapgs barriers and __user pointer sanitization + spectre_v2: Mitigation of Retpolines IBPB: conditional IBRS_FW STIBP: disabled RSB filling PBRSB-eIBRS: Not affected + srbds: Not affected + tsx_async_abort: Not affected
Gcrypt Library Libgcrypt is a general purpose cryptographic library developed as part of the GnuPG project. This is a benchmark of libgcrypt's integrated benchmark and is measuring the time to run the benchmark command with a cipher/mac/hash repetition count set for 50 times as simple, high level look at the overall crypto performance of the system under test. Learn more via the OpenBenchmarking.org test page.
OpenBenchmarking.org Seconds, Fewer Is Better Gcrypt Library 1.9 benchmark2 50 100 150 200 250 SE +/- 0.71, N = 3 230.51 1. (CC) gcc options: -O2 -fvisibility=hidden -lgpg-error
OpenBenchmarking.org us Per Event, Fewer Is Better OSBench Test: Create Threads benchmark2 6 12 18 24 30 SE +/- 0.27, N = 5 24.24 1. (CC) gcc options: -lm
OpenBenchmarking.org us Per Event, Fewer Is Better OSBench Test: Launch Programs benchmark2 14 28 42 56 70 SE +/- 0.80, N = 15 61.96 1. (CC) gcc options: -lm
OpenBenchmarking.org us Per Event, Fewer Is Better OSBench Test: Create Processes benchmark2 9 18 27 36 45 SE +/- 2.10, N = 12 40.52 1. (CC) gcc options: -lm
OpenBenchmarking.org Ns Per Event, Fewer Is Better OSBench Test: Memory Allocations benchmark2 20 40 60 80 100 SE +/- 0.17, N = 3 80.66 1. (CC) gcc options: -lm
OpenBenchmarking.org MB/s, More Is Better Zstd Compression 1.5.4 Compression Level: 3, Long Mode - Compression Speed benchmark2 100 200 300 400 500 SE +/- 3.66, N = 3 460.2 1. (CC) gcc options: -O3 -pthread -lz -llzma -llz4
OpenBenchmarking.org MB/s, More Is Better Zstd Compression 1.5.4 Compression Level: 3, Long Mode - Decompression Speed benchmark2 300 600 900 1200 1500 SE +/- 3.25, N = 3 1212.6 1. (CC) gcc options: -O3 -pthread -lz -llzma -llz4
OpenBenchmarking.org MB/s, More Is Better Zstd Compression 1.5.4 Compression Level: 8, Long Mode - Compression Speed benchmark2 140 280 420 560 700 SE +/- 3.81, N = 3 642.7 1. (CC) gcc options: -O3 -pthread -lz -llzma -llz4
OpenBenchmarking.org MB/s, More Is Better Zstd Compression 1.5.4 Compression Level: 19, Long Mode - Decompression Speed benchmark2 200 400 600 800 1000 SE +/- 8.31, N = 3 1129.9 1. (CC) gcc options: -O3 -pthread -lz -llzma -llz4
Parallel BZIP2 Compression OpenBenchmarking.org Seconds, Fewer Is Better Parallel BZIP2 Compression 1.1.13 FreeBSD-13.0-RELEASE-amd64-memstick.img Compression benchmark2 0.8094 1.6188 2.4282 3.2376 4.047 SE +/- 0.006223, N = 3 3.597165 1. (CXX) g++ options: -O2 -pthread -lbz2 -lpthread
nginx This is a benchmark of the lightweight Nginx HTTP(S) web-server. This Nginx web server benchmark test profile makes use of the wrk program for facilitating the HTTP requests over a fixed period time with a configurable number of concurrent clients/connections. HTTPS with a self-signed OpenSSL certificate is used by this test for local benchmarking. Learn more via the OpenBenchmarking.org test page.
Connections: 1
benchmark2: The test quit with a non-zero exit status. The test quit with a non-zero exit status. The test quit with a non-zero exit status.
Connections: 20
benchmark2: The test quit with a non-zero exit status. The test quit with a non-zero exit status. The test quit with a non-zero exit status.
OpenBenchmarking.org Requests Per Second, More Is Better nginx 1.23.2 Connections: 100 benchmark2 14K 28K 42K 56K 70K SE +/- 116.30, N = 3 66676.43 1. (CC) gcc options: -lluajit-5.1 -lm -lssl -lcrypto -lpthread -ldl -std=c99 -O2
OpenBenchmarking.org Requests Per Second, More Is Better nginx 1.23.2 Connections: 200 benchmark2 14K 28K 42K 56K 70K SE +/- 253.00, N = 3 66697.23 1. (CC) gcc options: -lluajit-5.1 -lm -lssl -lcrypto -lpthread -ldl -std=c99 -O2
OpenBenchmarking.org Requests Per Second, More Is Better nginx 1.23.2 Connections: 500 benchmark2 14K 28K 42K 56K 70K SE +/- 100.12, N = 3 66500.81 1. (CC) gcc options: -lluajit-5.1 -lm -lssl -lcrypto -lpthread -ldl -std=c99 -O2
OpenBenchmarking.org Requests Per Second, More Is Better nginx 1.23.2 Connections: 1000 benchmark2 14K 28K 42K 56K 70K SE +/- 93.49, N = 3 67687.75 1. (CC) gcc options: -lluajit-5.1 -lm -lssl -lcrypto -lpthread -ldl -std=c99 -O2
Connections: 4000
benchmark2: The test quit with a non-zero exit status. The test quit with a non-zero exit status. The test quit with a non-zero exit status.
Apache HTTP Server This is a test of the Apache HTTPD web server. This Apache HTTPD web server benchmark test profile makes use of the wrk program for facilitating the HTTP requests over a fixed period time with a configurable number of concurrent clients. Learn more via the OpenBenchmarking.org test page.
Concurrent Requests: 4
benchmark2: The test quit with a non-zero exit status. The test quit with a non-zero exit status. The test quit with a non-zero exit status.
Concurrent Requests: 20
benchmark2: The test quit with a non-zero exit status. The test quit with a non-zero exit status. The test quit with a non-zero exit status.
OpenBenchmarking.org Requests Per Second, More Is Better Apache HTTP Server 2.4.56 Concurrent Requests: 100 benchmark2 14K 28K 42K 56K 70K SE +/- 105.37, N = 3 63073.62 1. (CC) gcc options: -lluajit-5.1 -lm -lssl -lcrypto -lpthread -ldl -std=c99 -O2
OpenBenchmarking.org Requests Per Second, More Is Better Apache HTTP Server 2.4.56 Concurrent Requests: 200 benchmark2 20K 40K 60K 80K 100K SE +/- 691.90, N = 3 91651.79 1. (CC) gcc options: -lluajit-5.1 -lm -lssl -lcrypto -lpthread -ldl -std=c99 -O2
OpenBenchmarking.org Requests Per Second, More Is Better Apache HTTP Server 2.4.56 Concurrent Requests: 500 benchmark2 20K 40K 60K 80K 100K SE +/- 314.37, N = 3 105764.25 1. (CC) gcc options: -lluajit-5.1 -lm -lssl -lcrypto -lpthread -ldl -std=c99 -O2
OpenBenchmarking.org Requests Per Second, More Is Better Apache HTTP Server 2.4.56 Concurrent Requests: 1000 benchmark2 20K 40K 60K 80K 100K SE +/- 679.39, N = 3 99150.22 1. (CC) gcc options: -lluajit-5.1 -lm -lssl -lcrypto -lpthread -ldl -std=c99 -O2
OpenSSL OpenSSL is an open-source toolkit that implements SSL (Secure Sockets Layer) and TLS (Transport Layer Security) protocols. This test profile makes use of the built-in "openssl speed" benchmarking capabilities. Learn more via the OpenBenchmarking.org test page.
OpenBenchmarking.org byte/s, More Is Better OpenSSL 3.1 Algorithm: SHA256 benchmark2 2000M 4000M 6000M 8000M 10000M SE +/- 241399.77, N = 3 9294869883 1. (CC) gcc options: -pthread -m64 -O3 -lssl -lcrypto -ldl
OpenBenchmarking.org byte/s, More Is Better OpenSSL 3.1 Algorithm: SHA512 benchmark2 2000M 4000M 6000M 8000M 10000M SE +/- 4215130.08, N = 3 9185914147 1. (CC) gcc options: -pthread -m64 -O3 -lssl -lcrypto -ldl
OpenBenchmarking.org sign/s, More Is Better OpenSSL 3.1 Algorithm: RSA4096 benchmark2 1000 2000 3000 4000 5000 SE +/- 1.07, N = 3 4780.8 1. (CC) gcc options: -pthread -m64 -O3 -lssl -lcrypto -ldl
OpenBenchmarking.org verify/s, More Is Better OpenSSL 3.1 Algorithm: RSA4096 benchmark2 70K 140K 210K 280K 350K SE +/- 64.67, N = 3 312713.0 1. (CC) gcc options: -pthread -m64 -O3 -lssl -lcrypto -ldl
OpenBenchmarking.org byte/s, More Is Better OpenSSL 3.1 Algorithm: ChaCha20 benchmark2 11000M 22000M 33000M 44000M 55000M SE +/- 2814007.00, N = 3 51553981967 1. (CC) gcc options: -pthread -m64 -O3 -lssl -lcrypto -ldl
OpenBenchmarking.org byte/s, More Is Better OpenSSL 3.1 Algorithm: AES-128-GCM benchmark2 20000M 40000M 60000M 80000M 100000M SE +/- 36681830.40, N = 3 112050078787 1. (CC) gcc options: -pthread -m64 -O3 -lssl -lcrypto -ldl
OpenBenchmarking.org byte/s, More Is Better OpenSSL 3.1 Algorithm: AES-256-GCM benchmark2 20000M 40000M 60000M 80000M 100000M SE +/- 20078107.25, N = 3 103521589930 1. (CC) gcc options: -pthread -m64 -O3 -lssl -lcrypto -ldl
OpenBenchmarking.org byte/s, More Is Better OpenSSL 3.1 Algorithm: ChaCha20-Poly1305 benchmark2 8000M 16000M 24000M 32000M 40000M SE +/- 4908626.24, N = 3 38134651563 1. (CC) gcc options: -pthread -m64 -O3 -lssl -lcrypto -ldl
PHPBench PHPBench is a benchmark suite for PHP. It performs a large number of simple tests in order to bench various aspects of the PHP interpreter. PHPBench can be used to compare hardware, operating systems, PHP versions, PHP accelerators and caches, compiler options, etc. Learn more via the OpenBenchmarking.org test page.
OpenBenchmarking.org Score, More Is Better PHPBench 0.8.1 PHP Benchmark Suite benchmark2 160K 320K 480K 640K 800K SE +/- 3498.95, N = 3 728603
ClickHouse ClickHouse is an open-source, high performance OLAP data management system. This test profile uses ClickHouse's standard benchmark recommendations per https://clickhouse.com/docs/en/operations/performance-test/ / https://github.com/ClickHouse/ClickBench/tree/main/clickhouse with the 100 million rows web analytics dataset. The reported value is the query processing time using the geometric mean of all separate queries performed as an aggregate. Learn more via the OpenBenchmarking.org test page.
OpenBenchmarking.org Queries Per Minute, Geo Mean, More Is Better ClickHouse 22.12.3.5 100M Rows Hits Dataset, First Run / Cold Cache benchmark2 60 120 180 240 300 SE +/- 2.82, N = 9 284.10 MIN: 17.93 / MAX: 4615.38
InfluxDB This is a benchmark of the InfluxDB open-source time-series database optimized for fast, high-availability storage for IoT and other use-cases. The InfluxDB test profile makes use of InfluxDB Inch for facilitating the benchmarks. Learn more via the OpenBenchmarking.org test page.
OpenBenchmarking.org val/sec, More Is Better InfluxDB 1.8.2 Concurrent Streams: 4 - Batch Size: 10000 - Tags: 2,5000,1 - Points Per Series: 10000 benchmark2 200K 400K 600K 800K 1000K SE +/- 2231.79, N = 3 1043266.5
OpenBenchmarking.org val/sec, More Is Better InfluxDB 1.8.2 Concurrent Streams: 64 - Batch Size: 10000 - Tags: 2,5000,1 - Points Per Series: 10000 benchmark2 300K 600K 900K 1200K 1500K SE +/- 2667.11, N = 3 1361294.2
OpenBenchmarking.org val/sec, More Is Better InfluxDB 1.8.2 Concurrent Streams: 1024 - Batch Size: 10000 - Tags: 2,5000,1 - Points Per Series: 10000 benchmark2 300K 600K 900K 1200K 1500K SE +/- 20.81, N = 3 1428905.5
OpenBenchmarking.org Requests Per Second, More Is Better Redis 7.0.4 Test: SET - Parallel Connections: 50 benchmark2 500K 1000K 1500K 2000K 2500K SE +/- 19257.11, N = 3 2127263.21 1. (CXX) g++ options: -MM -MT -g3 -fvisibility=hidden -O3
OpenBenchmarking.org Requests Per Second, More Is Better Redis 7.0.4 Test: GET - Parallel Connections: 500 benchmark2 400K 800K 1200K 1600K 2000K SE +/- 6415.18, N = 3 1899691.00 1. (CXX) g++ options: -MM -MT -g3 -fvisibility=hidden -O3
OpenBenchmarking.org Requests Per Second, More Is Better Redis 7.0.4 Test: LPOP - Parallel Connections: 50 benchmark2 700K 1400K 2100K 2800K 3500K SE +/- 34414.00, N = 4 3080945.19 1. (CXX) g++ options: -MM -MT -g3 -fvisibility=hidden -O3
OpenBenchmarking.org Requests Per Second, More Is Better Redis 7.0.4 Test: SADD - Parallel Connections: 50 benchmark2 500K 1000K 1500K 2000K 2500K SE +/- 25839.70, N = 3 2385045.17 1. (CXX) g++ options: -MM -MT -g3 -fvisibility=hidden -O3
OpenBenchmarking.org Requests Per Second, More Is Better Redis 7.0.4 Test: SET - Parallel Connections: 500 benchmark2 300K 600K 900K 1200K 1500K SE +/- 10420.44, N = 3 1556050.8 1. (CXX) g++ options: -MM -MT -g3 -fvisibility=hidden -O3
OpenBenchmarking.org Requests Per Second, More Is Better Redis 7.0.4 Test: GET - Parallel Connections: 1000 benchmark2 400K 800K 1200K 1600K 2000K SE +/- 24512.11, N = 4 1970243.03 1. (CXX) g++ options: -MM -MT -g3 -fvisibility=hidden -O3
OpenBenchmarking.org Requests Per Second, More Is Better Redis 7.0.4 Test: LPOP - Parallel Connections: 500 benchmark2 500K 1000K 1500K 2000K 2500K SE +/- 13950.79, N = 3 2241125.8 1. (CXX) g++ options: -MM -MT -g3 -fvisibility=hidden -O3
OpenBenchmarking.org Requests Per Second, More Is Better Redis 7.0.4 Test: LPUSH - Parallel Connections: 50 benchmark2 300K 600K 900K 1200K 1500K SE +/- 13945.79, N = 3 1578123.79 1. (CXX) g++ options: -MM -MT -g3 -fvisibility=hidden -O3
OpenBenchmarking.org Requests Per Second, More Is Better Redis 7.0.4 Test: SADD - Parallel Connections: 500 benchmark2 400K 800K 1200K 1600K 2000K SE +/- 1430.31, N = 3 1732895.37 1. (CXX) g++ options: -MM -MT -g3 -fvisibility=hidden -O3
OpenBenchmarking.org Requests Per Second, More Is Better Redis 7.0.4 Test: SET - Parallel Connections: 1000 benchmark2 400K 800K 1200K 1600K 2000K SE +/- 22029.91, N = 3 1644080.29 1. (CXX) g++ options: -MM -MT -g3 -fvisibility=hidden -O3
OpenBenchmarking.org Requests Per Second, More Is Better Redis 7.0.4 Test: LPOP - Parallel Connections: 1000 benchmark2 300K 600K 900K 1200K 1500K SE +/- 6200.57, N = 3 1355051.50 1. (CXX) g++ options: -MM -MT -g3 -fvisibility=hidden -O3
OpenBenchmarking.org Requests Per Second, More Is Better Redis 7.0.4 Test: LPUSH - Parallel Connections: 500 benchmark2 300K 600K 900K 1200K 1500K SE +/- 11397.86, N = 3 1321441.45 1. (CXX) g++ options: -MM -MT -g3 -fvisibility=hidden -O3
OpenBenchmarking.org Requests Per Second, More Is Better Redis 7.0.4 Test: SADD - Parallel Connections: 1000 benchmark2 400K 800K 1200K 1600K 2000K SE +/- 6998.87, N = 3 1823507.96 1. (CXX) g++ options: -MM -MT -g3 -fvisibility=hidden -O3
OpenBenchmarking.org Requests Per Second, More Is Better Redis 7.0.4 Test: LPUSH - Parallel Connections: 1000 benchmark2 300K 600K 900K 1200K 1500K SE +/- 16126.58, N = 3 1372927.21 1. (CXX) g++ options: -MM -MT -g3 -fvisibility=hidden -O3
OpenBenchmarking.org Seconds, Fewer Is Better SQLite 3.30.1 Threads / Copies: 8 benchmark2 6 12 18 24 30 SE +/- 0.54, N = 12 26.66 1. (CC) gcc options: -O2 -lreadline -ltermcap -lz -lm
OpenBenchmarking.org Seconds, Fewer Is Better SQLite 3.30.1 Threads / Copies: 32 benchmark2 13 26 39 52 65 SE +/- 0.17, N = 3 56.75 1. (CC) gcc options: -O2 -lreadline -ltermcap -lz -lm
OpenBenchmarking.org Seconds, Fewer Is Better SQLite 3.30.1 Threads / Copies: 64 benchmark2 20 40 60 80 100 SE +/- 0.56, N = 3 83.49 1. (CC) gcc options: -O2 -lreadline -ltermcap -lz -lm
OpenBenchmarking.org Seconds, Fewer Is Better SQLite 3.30.1 Threads / Copies: 128 benchmark2 30 60 90 120 150 SE +/- 0.45, N = 3 123.36 1. (CC) gcc options: -O2 -lreadline -ltermcap -lz -lm
OpenBenchmarking.org ms, Fewer Is Better PostgreSQL 16 Scaling Factor: 1 - Clients: 1 - Mode: Read Only - Average Latency benchmark2 0.0045 0.009 0.0135 0.018 0.0225 SE +/- 0.000, N = 9 0.020 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
OpenBenchmarking.org TPS, More Is Better PostgreSQL 16 Scaling Factor: 1 - Clients: 1 - Mode: Read Write benchmark2 400 800 1200 1600 2000 SE +/- 44.56, N = 9 1743 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
OpenBenchmarking.org ms, Fewer Is Better PostgreSQL 16 Scaling Factor: 1 - Clients: 1 - Mode: Read Write - Average Latency benchmark2 0.1298 0.2596 0.3894 0.5192 0.649 SE +/- 0.015, N = 9 0.577 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
OpenBenchmarking.org TPS, More Is Better PostgreSQL 16 Scaling Factor: 1 - Clients: 50 - Mode: Read Only benchmark2 200K 400K 600K 800K 1000K SE +/- 3913.53, N = 3 1136232 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
OpenBenchmarking.org ms, Fewer Is Better PostgreSQL 16 Scaling Factor: 1 - Clients: 50 - Mode: Read Only - Average Latency benchmark2 0.0099 0.0198 0.0297 0.0396 0.0495 SE +/- 0.000, N = 3 0.044 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
OpenBenchmarking.org TPS, More Is Better PostgreSQL 16 Scaling Factor: 1 - Clients: 100 - Mode: Read Only benchmark2 300K 600K 900K 1200K 1500K SE +/- 10479.39, N = 3 1324375 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
OpenBenchmarking.org ms, Fewer Is Better PostgreSQL 16 Scaling Factor: 1 - Clients: 100 - Mode: Read Only - Average Latency benchmark2 0.0171 0.0342 0.0513 0.0684 0.0855 SE +/- 0.001, N = 3 0.076 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
OpenBenchmarking.org TPS, More Is Better PostgreSQL 16 Scaling Factor: 1 - Clients: 250 - Mode: Read Only benchmark2 300K 600K 900K 1200K 1500K SE +/- 12161.74, N = 3 1325094 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
OpenBenchmarking.org ms, Fewer Is Better PostgreSQL 16 Scaling Factor: 1 - Clients: 250 - Mode: Read Only - Average Latency benchmark2 0.0425 0.085 0.1275 0.17 0.2125 SE +/- 0.002, N = 3 0.189 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
OpenBenchmarking.org TPS, More Is Better PostgreSQL 16 Scaling Factor: 1 - Clients: 50 - Mode: Read Write benchmark2 200 400 600 800 1000 SE +/- 7.38, N = 3 1099 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
OpenBenchmarking.org ms, Fewer Is Better PostgreSQL 16 Scaling Factor: 1 - Clients: 50 - Mode: Read Write - Average Latency benchmark2 10 20 30 40 50 SE +/- 0.30, N = 3 45.50 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
OpenBenchmarking.org TPS, More Is Better PostgreSQL 16 Scaling Factor: 1 - Clients: 500 - Mode: Read Only benchmark2 200K 400K 600K 800K 1000K SE +/- 8070.83, N = 3 1056100 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
OpenBenchmarking.org ms, Fewer Is Better PostgreSQL 16 Scaling Factor: 1 - Clients: 500 - Mode: Read Only - Average Latency benchmark2 0.1067 0.2134 0.3201 0.4268 0.5335 SE +/- 0.004, N = 3 0.474 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
OpenBenchmarking.org TPS, More Is Better PostgreSQL 16 Scaling Factor: 1 - Clients: 800 - Mode: Read Only benchmark2 200K 400K 600K 800K 1000K SE +/- 9350.12, N = 3 1084491 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
OpenBenchmarking.org ms, Fewer Is Better PostgreSQL 16 Scaling Factor: 1 - Clients: 800 - Mode: Read Only - Average Latency benchmark2 0.1661 0.3322 0.4983 0.6644 0.8305 SE +/- 0.007, N = 3 0.738 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
OpenBenchmarking.org TPS, More Is Better PostgreSQL 16 Scaling Factor: 100 - Clients: 1 - Mode: Read Only benchmark2 10K 20K 30K 40K 50K SE +/- 1246.68, N = 9 44960 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
OpenBenchmarking.org ms, Fewer Is Better PostgreSQL 16 Scaling Factor: 100 - Clients: 1 - Mode: Read Only - Average Latency benchmark2 0.0052 0.0104 0.0156 0.0208 0.026 SE +/- 0.001, N = 9 0.023 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
OpenBenchmarking.org TPS, More Is Better PostgreSQL 16 Scaling Factor: 1 - Clients: 100 - Mode: Read Write benchmark2 200 400 600 800 1000 SE +/- 7.44, N = 3 1007 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
OpenBenchmarking.org ms, Fewer Is Better PostgreSQL 16 Scaling Factor: 1 - Clients: 100 - Mode: Read Write - Average Latency benchmark2 20 40 60 80 100 SE +/- 0.73, N = 3 99.32 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
OpenBenchmarking.org TPS, More Is Better PostgreSQL 16 Scaling Factor: 1 - Clients: 1000 - Mode: Read Only benchmark2 200K 400K 600K 800K 1000K SE +/- 6999.28, N = 3 1117960 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
OpenBenchmarking.org ms, Fewer Is Better PostgreSQL 16 Scaling Factor: 1 - Clients: 1000 - Mode: Read Only - Average Latency benchmark2 0.2014 0.4028 0.6042 0.8056 1.007 SE +/- 0.006, N = 3 0.895 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
OpenBenchmarking.org TPS, More Is Better PostgreSQL 16 Scaling Factor: 1 - Clients: 250 - Mode: Read Write benchmark2 200 400 600 800 1000 SE +/- 6.70, N = 3 875 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
OpenBenchmarking.org ms, Fewer Is Better PostgreSQL 16 Scaling Factor: 1 - Clients: 250 - Mode: Read Write - Average Latency benchmark2 60 120 180 240 300 SE +/- 2.21, N = 3 285.84 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
OpenBenchmarking.org TPS, More Is Better PostgreSQL 16 Scaling Factor: 1 - Clients: 500 - Mode: Read Write benchmark2 150 300 450 600 750 SE +/- 7.95, N = 12 698 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
OpenBenchmarking.org ms, Fewer Is Better PostgreSQL 16 Scaling Factor: 1 - Clients: 500 - Mode: Read Write - Average Latency benchmark2 150 300 450 600 750 SE +/- 8.37, N = 12 717.85 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
Scaling Factor: 1 - Clients: 5000 - Mode: Read Only
benchmark2: The test run did not produce a result. The test run did not produce a result. 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 16 Scaling Factor: 1 - Clients: 800 - Mode: Read Write benchmark2 130 260 390 520 650 SE +/- 5.57, N = 12 583 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
OpenBenchmarking.org ms, Fewer Is Better PostgreSQL 16 Scaling Factor: 1 - Clients: 800 - Mode: Read Write - Average Latency benchmark2 300 600 900 1200 1500 SE +/- 13.53, N = 12 1374.16 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
OpenBenchmarking.org TPS, More Is Better PostgreSQL 16 Scaling Factor: 100 - Clients: 1 - Mode: Read Write benchmark2 300 600 900 1200 1500 SE +/- 22.57, N = 12 1207 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
OpenBenchmarking.org ms, Fewer Is Better PostgreSQL 16 Scaling Factor: 100 - Clients: 1 - Mode: Read Write - Average Latency benchmark2 0.1872 0.3744 0.5616 0.7488 0.936 SE +/- 0.015, N = 12 0.832 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
OpenBenchmarking.org TPS, More Is Better PostgreSQL 16 Scaling Factor: 100 - Clients: 50 - Mode: Read Only benchmark2 200K 400K 600K 800K 1000K SE +/- 4694.34, N = 3 977976 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
OpenBenchmarking.org ms, Fewer Is Better PostgreSQL 16 Scaling Factor: 100 - Clients: 50 - Mode: Read Only - Average Latency benchmark2 0.0115 0.023 0.0345 0.046 0.0575 SE +/- 0.000, N = 3 0.051 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
OpenBenchmarking.org TPS, More Is Better PostgreSQL 16 Scaling Factor: 1000 - Clients: 1 - Mode: Read Only benchmark2 8K 16K 24K 32K 40K SE +/- 360.37, N = 3 38561 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
OpenBenchmarking.org ms, Fewer Is Better PostgreSQL 16 Scaling Factor: 1000 - Clients: 1 - Mode: Read Only - Average Latency benchmark2 0.0059 0.0118 0.0177 0.0236 0.0295 SE +/- 0.000, N = 3 0.026 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
OpenBenchmarking.org TPS, More Is Better PostgreSQL 16 Scaling Factor: 1 - Clients: 1000 - Mode: Read Write benchmark2 110 220 330 440 550 SE +/- 11.76, N = 12 501 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
OpenBenchmarking.org ms, Fewer Is Better PostgreSQL 16 Scaling Factor: 1 - Clients: 1000 - Mode: Read Write - Average Latency benchmark2 400 800 1200 1600 2000 SE +/- 47.58, N = 12 2009.10 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
Scaling Factor: 1 - Clients: 5000 - Mode: Read Write
benchmark2: The test run did not produce a result. The test run did not produce a result. 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 16 Scaling Factor: 100 - Clients: 100 - Mode: Read Only benchmark2 200K 400K 600K 800K 1000K SE +/- 2893.33, N = 3 1031743 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
OpenBenchmarking.org ms, Fewer Is Better PostgreSQL 16 Scaling Factor: 100 - Clients: 100 - Mode: Read Only - Average Latency benchmark2 0.0218 0.0436 0.0654 0.0872 0.109 SE +/- 0.000, N = 3 0.097 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
OpenBenchmarking.org TPS, More Is Better PostgreSQL 16 Scaling Factor: 100 - Clients: 250 - Mode: Read Only benchmark2 200K 400K 600K 800K 1000K SE +/- 10565.49, N = 3 1110481 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
OpenBenchmarking.org ms, Fewer Is Better PostgreSQL 16 Scaling Factor: 100 - Clients: 250 - Mode: Read Only - Average Latency benchmark2 0.0506 0.1012 0.1518 0.2024 0.253 SE +/- 0.002, N = 3 0.225 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
OpenBenchmarking.org TPS, More Is Better PostgreSQL 16 Scaling Factor: 100 - Clients: 50 - Mode: Read Write benchmark2 5K 10K 15K 20K 25K SE +/- 66.93, N = 3 21068 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
OpenBenchmarking.org ms, Fewer Is Better PostgreSQL 16 Scaling Factor: 100 - Clients: 50 - Mode: Read Write - Average Latency benchmark2 0.5339 1.0678 1.6017 2.1356 2.6695 SE +/- 0.008, N = 3 2.373 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
OpenBenchmarking.org TPS, More Is Better PostgreSQL 16 Scaling Factor: 100 - Clients: 500 - Mode: Read Only benchmark2 200K 400K 600K 800K 1000K SE +/- 817.51, N = 3 928639 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
OpenBenchmarking.org ms, Fewer Is Better PostgreSQL 16 Scaling Factor: 100 - Clients: 500 - Mode: Read Only - Average Latency benchmark2 0.1211 0.2422 0.3633 0.4844 0.6055 SE +/- 0.001, N = 3 0.538 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
OpenBenchmarking.org TPS, More Is Better PostgreSQL 16 Scaling Factor: 100 - Clients: 800 - Mode: Read Only benchmark2 200K 400K 600K 800K 1000K SE +/- 4420.42, N = 3 932077 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
OpenBenchmarking.org ms, Fewer Is Better PostgreSQL 16 Scaling Factor: 100 - Clients: 800 - Mode: Read Only - Average Latency benchmark2 0.1931 0.3862 0.5793 0.7724 0.9655 SE +/- 0.004, N = 3 0.858 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
OpenBenchmarking.org TPS, More Is Better PostgreSQL 16 Scaling Factor: 1000 - Clients: 1 - Mode: Read Write benchmark2 200 400 600 800 1000 SE +/- 5.75, N = 3 1006 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
OpenBenchmarking.org ms, Fewer Is Better PostgreSQL 16 Scaling Factor: 1000 - Clients: 1 - Mode: Read Write - Average Latency benchmark2 0.2237 0.4474 0.6711 0.8948 1.1185 SE +/- 0.006, N = 3 0.994 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
OpenBenchmarking.org TPS, More Is Better PostgreSQL 16 Scaling Factor: 1000 - Clients: 50 - Mode: Read Only benchmark2 140K 280K 420K 560K 700K SE +/- 4271.57, N = 3 660252 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
OpenBenchmarking.org ms, Fewer Is Better PostgreSQL 16 Scaling Factor: 1000 - Clients: 50 - Mode: Read Only - Average Latency benchmark2 0.0171 0.0342 0.0513 0.0684 0.0855 SE +/- 0.001, N = 3 0.076 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
OpenBenchmarking.org TPS, More Is Better PostgreSQL 16 Scaling Factor: 10000 - Clients: 1 - Mode: Read Only benchmark2 3K 6K 9K 12K 15K SE +/- 819.06, N = 9 13941 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
OpenBenchmarking.org ms, Fewer Is Better PostgreSQL 16 Scaling Factor: 10000 - Clients: 1 - Mode: Read Only - Average Latency benchmark2 0.0167 0.0334 0.0501 0.0668 0.0835 SE +/- 0.005, N = 9 0.074 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
OpenBenchmarking.org TPS, More Is Better PostgreSQL 16 Scaling Factor: 100 - Clients: 100 - Mode: Read Write benchmark2 5K 10K 15K 20K 25K SE +/- 143.25, N = 3 24523 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
OpenBenchmarking.org ms, Fewer Is Better PostgreSQL 16 Scaling Factor: 100 - Clients: 100 - Mode: Read Write - Average Latency benchmark2 0.9176 1.8352 2.7528 3.6704 4.588 SE +/- 0.024, N = 3 4.078 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
OpenBenchmarking.org TPS, More Is Better PostgreSQL 16 Scaling Factor: 100 - Clients: 1000 - Mode: Read Only benchmark2 200K 400K 600K 800K 1000K SE +/- 8806.54, N = 3 929440 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
OpenBenchmarking.org ms, Fewer Is Better PostgreSQL 16 Scaling Factor: 100 - Clients: 1000 - Mode: Read Only - Average Latency benchmark2 0.2421 0.4842 0.7263 0.9684 1.2105 SE +/- 0.011, N = 3 1.076 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
OpenBenchmarking.org TPS, More Is Better PostgreSQL 16 Scaling Factor: 100 - Clients: 250 - Mode: Read Write benchmark2 6K 12K 18K 24K 30K SE +/- 83.58, N = 3 27077 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
OpenBenchmarking.org ms, Fewer Is Better PostgreSQL 16 Scaling Factor: 100 - Clients: 250 - Mode: Read Write - Average Latency benchmark2 3 6 9 12 15 SE +/- 0.029, N = 3 9.233 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
OpenBenchmarking.org TPS, More Is Better PostgreSQL 16 Scaling Factor: 100 - Clients: 500 - Mode: Read Write benchmark2 6K 12K 18K 24K 30K SE +/- 191.49, N = 3 25853 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
OpenBenchmarking.org ms, Fewer Is Better PostgreSQL 16 Scaling Factor: 100 - Clients: 500 - Mode: Read Write - Average Latency benchmark2 5 10 15 20 25 SE +/- 0.14, N = 3 19.34 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
Scaling Factor: 100 - Clients: 5000 - Mode: Read Only
benchmark2: The test run did not produce a result. The test run did not produce a result. 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 16 Scaling Factor: 100 - Clients: 800 - Mode: Read Write benchmark2 5K 10K 15K 20K 25K SE +/- 243.61, N = 3 24347 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
OpenBenchmarking.org ms, Fewer Is Better PostgreSQL 16 Scaling Factor: 100 - Clients: 800 - Mode: Read Write - Average Latency benchmark2 8 16 24 32 40 SE +/- 0.33, N = 3 32.87 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
OpenBenchmarking.org TPS, More Is Better PostgreSQL 16 Scaling Factor: 1000 - Clients: 100 - Mode: Read Only benchmark2 130K 260K 390K 520K 650K SE +/- 2019.77, N = 3 627725 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
OpenBenchmarking.org ms, Fewer Is Better PostgreSQL 16 Scaling Factor: 1000 - Clients: 100 - Mode: Read Only - Average Latency benchmark2 0.0358 0.0716 0.1074 0.1432 0.179 SE +/- 0.000, N = 3 0.159 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
OpenBenchmarking.org TPS, More Is Better PostgreSQL 16 Scaling Factor: 1000 - Clients: 250 - Mode: Read Only benchmark2 150K 300K 450K 600K 750K SE +/- 5484.45, N = 3 685838 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
OpenBenchmarking.org ms, Fewer Is Better PostgreSQL 16 Scaling Factor: 1000 - Clients: 250 - Mode: Read Only - Average Latency benchmark2 0.0819 0.1638 0.2457 0.3276 0.4095 SE +/- 0.003, N = 3 0.364 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
OpenBenchmarking.org TPS, More Is Better PostgreSQL 16 Scaling Factor: 1000 - Clients: 50 - Mode: Read Write benchmark2 2K 4K 6K 8K 10K SE +/- 68.05, N = 3 11055 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
OpenBenchmarking.org ms, Fewer Is Better PostgreSQL 16 Scaling Factor: 1000 - Clients: 50 - Mode: Read Write - Average Latency benchmark2 1.0177 2.0354 3.0531 4.0708 5.0885 SE +/- 0.028, N = 3 4.523 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
OpenBenchmarking.org TPS, More Is Better PostgreSQL 16 Scaling Factor: 1000 - Clients: 500 - Mode: Read Only benchmark2 150K 300K 450K 600K 750K SE +/- 1430.47, N = 3 693044 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
OpenBenchmarking.org ms, Fewer Is Better PostgreSQL 16 Scaling Factor: 1000 - Clients: 500 - Mode: Read Only - Average Latency benchmark2 0.1622 0.3244 0.4866 0.6488 0.811 SE +/- 0.001, N = 3 0.721 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
OpenBenchmarking.org TPS, More Is Better PostgreSQL 16 Scaling Factor: 1000 - Clients: 800 - Mode: Read Only benchmark2 150K 300K 450K 600K 750K SE +/- 2340.32, N = 3 693689 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
OpenBenchmarking.org ms, Fewer Is Better PostgreSQL 16 Scaling Factor: 1000 - Clients: 800 - Mode: Read Only - Average Latency benchmark2 0.2594 0.5188 0.7782 1.0376 1.297 SE +/- 0.004, N = 3 1.153 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
OpenBenchmarking.org TPS, More Is Better PostgreSQL 16 Scaling Factor: 10000 - Clients: 1 - Mode: Read Write benchmark2 200 400 600 800 1000 SE +/- 12.19, N = 9 972 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
OpenBenchmarking.org ms, Fewer Is Better PostgreSQL 16 Scaling Factor: 10000 - Clients: 1 - Mode: Read Write - Average Latency benchmark2 0.232 0.464 0.696 0.928 1.16 SE +/- 0.013, N = 9 1.031 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
OpenBenchmarking.org TPS, More Is Better PostgreSQL 16 Scaling Factor: 10000 - Clients: 50 - Mode: Read Only benchmark2 100K 200K 300K 400K 500K SE +/- 3344.05, N = 3 477627 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
OpenBenchmarking.org ms, Fewer Is Better PostgreSQL 16 Scaling Factor: 10000 - Clients: 50 - Mode: Read Only - Average Latency benchmark2 0.0236 0.0472 0.0708 0.0944 0.118 SE +/- 0.001, N = 3 0.105 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
OpenBenchmarking.org TPS, More Is Better PostgreSQL 16 Scaling Factor: 100 - Clients: 1000 - Mode: Read Write benchmark2 5K 10K 15K 20K 25K SE +/- 284.20, N = 3 23998 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
OpenBenchmarking.org ms, Fewer Is Better PostgreSQL 16 Scaling Factor: 100 - Clients: 1000 - Mode: Read Write - Average Latency benchmark2 10 20 30 40 50 SE +/- 0.50, N = 3 41.68 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
Scaling Factor: 100 - Clients: 5000 - Mode: Read Write
benchmark2: The test run did not produce a result. The test run did not produce a result. 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 16 Scaling Factor: 1000 - Clients: 100 - Mode: Read Write benchmark2 3K 6K 9K 12K 15K SE +/- 106.99, N = 3 13434 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
OpenBenchmarking.org ms, Fewer Is Better PostgreSQL 16 Scaling Factor: 1000 - Clients: 100 - Mode: Read Write - Average Latency benchmark2 2 4 6 8 10 SE +/- 0.060, N = 3 7.445 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
OpenBenchmarking.org TPS, More Is Better PostgreSQL 16 Scaling Factor: 1000 - Clients: 1000 - Mode: Read Only benchmark2 150K 300K 450K 600K 750K SE +/- 2731.72, N = 3 686666 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
OpenBenchmarking.org ms, Fewer Is Better PostgreSQL 16 Scaling Factor: 1000 - Clients: 1000 - Mode: Read Only - Average Latency benchmark2 0.3276 0.6552 0.9828 1.3104 1.638 SE +/- 0.006, N = 3 1.456 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
OpenBenchmarking.org TPS, More Is Better PostgreSQL 16 Scaling Factor: 1000 - Clients: 250 - Mode: Read Write benchmark2 3K 6K 9K 12K 15K SE +/- 174.89, N = 3 13416 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
OpenBenchmarking.org ms, Fewer Is Better PostgreSQL 16 Scaling Factor: 1000 - Clients: 250 - Mode: Read Write - Average Latency benchmark2 5 10 15 20 25 SE +/- 0.25, N = 3 18.64 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
OpenBenchmarking.org TPS, More Is Better PostgreSQL 16 Scaling Factor: 1000 - Clients: 500 - Mode: Read Write benchmark2 2K 4K 6K 8K 10K SE +/- 114.31, N = 5 10420 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
OpenBenchmarking.org ms, Fewer Is Better PostgreSQL 16 Scaling Factor: 1000 - Clients: 500 - Mode: Read Write - Average Latency benchmark2 11 22 33 44 55 SE +/- 0.53, N = 5 48.01 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
Scaling Factor: 1000 - Clients: 5000 - Mode: Read Only
benchmark2: The test run did not produce a result. The test run did not produce a result. 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 16 Scaling Factor: 1000 - Clients: 800 - Mode: Read Write benchmark2 3K 6K 9K 12K 15K SE +/- 36.88, N = 3 12102 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
OpenBenchmarking.org ms, Fewer Is Better PostgreSQL 16 Scaling Factor: 1000 - Clients: 800 - Mode: Read Write - Average Latency benchmark2 15 30 45 60 75 SE +/- 0.20, N = 3 66.11 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
OpenBenchmarking.org TPS, More Is Better PostgreSQL 16 Scaling Factor: 10000 - Clients: 100 - Mode: Read Only benchmark2 90K 180K 270K 360K 450K SE +/- 1180.04, N = 3 429019 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
OpenBenchmarking.org ms, Fewer Is Better PostgreSQL 16 Scaling Factor: 10000 - Clients: 100 - Mode: Read Only - Average Latency benchmark2 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 16 Scaling Factor: 10000 - Clients: 250 - Mode: Read Only benchmark2 110K 220K 330K 440K 550K SE +/- 406.15, N = 3 529985 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
OpenBenchmarking.org ms, Fewer Is Better PostgreSQL 16 Scaling Factor: 10000 - Clients: 250 - Mode: Read Only - Average Latency benchmark2 0.1062 0.2124 0.3186 0.4248 0.531 SE +/- 0.000, N = 3 0.472 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
OpenBenchmarking.org TPS, More Is Better PostgreSQL 16 Scaling Factor: 10000 - Clients: 50 - Mode: Read Write benchmark2 2K 4K 6K 8K 10K SE +/- 48.87, N = 3 9460 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
OpenBenchmarking.org ms, Fewer Is Better PostgreSQL 16 Scaling Factor: 10000 - Clients: 50 - Mode: Read Write - Average Latency benchmark2 1.1894 2.3788 3.5682 4.7576 5.947 SE +/- 0.027, N = 3 5.286 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
OpenBenchmarking.org TPS, More Is Better PostgreSQL 16 Scaling Factor: 10000 - Clients: 500 - Mode: Read Only benchmark2 120K 240K 360K 480K 600K SE +/- 2082.14, N = 3 547428 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
OpenBenchmarking.org ms, Fewer Is Better PostgreSQL 16 Scaling Factor: 10000 - Clients: 500 - Mode: Read Only - Average Latency benchmark2 0.2054 0.4108 0.6162 0.8216 1.027 SE +/- 0.003, N = 3 0.913 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
OpenBenchmarking.org TPS, More Is Better PostgreSQL 16 Scaling Factor: 10000 - Clients: 800 - Mode: Read Only benchmark2 120K 240K 360K 480K 600K SE +/- 7675.97, N = 3 546445 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
OpenBenchmarking.org ms, Fewer Is Better PostgreSQL 16 Scaling Factor: 10000 - Clients: 800 - Mode: Read Only - Average Latency benchmark2 0.3296 0.6592 0.9888 1.3184 1.648 SE +/- 0.021, N = 3 1.465 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
OpenBenchmarking.org TPS, More Is Better PostgreSQL 16 Scaling Factor: 1000 - Clients: 1000 - Mode: Read Write benchmark2 3K 6K 9K 12K 15K SE +/- 127.23, N = 3 13111 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
OpenBenchmarking.org ms, Fewer Is Better PostgreSQL 16 Scaling Factor: 1000 - Clients: 1000 - Mode: Read Write - Average Latency benchmark2 20 40 60 80 100 SE +/- 0.74, N = 3 76.29 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
Scaling Factor: 1000 - Clients: 5000 - Mode: Read Write
benchmark2: The test run did not produce a result. The test run did not produce a result. 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 16 Scaling Factor: 10000 - Clients: 100 - Mode: Read Write benchmark2 2K 4K 6K 8K 10K SE +/- 32.30, N = 3 8153 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
OpenBenchmarking.org ms, Fewer Is Better PostgreSQL 16 Scaling Factor: 10000 - Clients: 100 - Mode: Read Write - Average Latency benchmark2 3 6 9 12 15 SE +/- 0.05, N = 3 12.27 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
OpenBenchmarking.org TPS, More Is Better PostgreSQL 16 Scaling Factor: 10000 - Clients: 1000 - Mode: Read Only benchmark2 120K 240K 360K 480K 600K SE +/- 3718.12, N = 3 552542 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
OpenBenchmarking.org ms, Fewer Is Better PostgreSQL 16 Scaling Factor: 10000 - Clients: 1000 - Mode: Read Only - Average Latency benchmark2 0.4073 0.8146 1.2219 1.6292 2.0365 SE +/- 0.012, N = 3 1.810 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
OpenBenchmarking.org TPS, More Is Better PostgreSQL 16 Scaling Factor: 10000 - Clients: 250 - Mode: Read Write benchmark2 2K 4K 6K 8K 10K SE +/- 43.30, N = 3 8099 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
OpenBenchmarking.org ms, Fewer Is Better PostgreSQL 16 Scaling Factor: 10000 - Clients: 250 - Mode: Read Write - Average Latency benchmark2 7 14 21 28 35 SE +/- 0.16, N = 3 30.87 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
OpenBenchmarking.org TPS, More Is Better PostgreSQL 16 Scaling Factor: 10000 - Clients: 500 - Mode: Read Write benchmark2 2K 4K 6K 8K 10K SE +/- 75.87, N = 3 8406 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
OpenBenchmarking.org ms, Fewer Is Better PostgreSQL 16 Scaling Factor: 10000 - Clients: 500 - Mode: Read Write - Average Latency benchmark2 13 26 39 52 65 SE +/- 0.54, N = 3 59.49 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
Scaling Factor: 10000 - Clients: 5000 - Mode: Read Only
benchmark2: The test run did not produce a result. The test run did not produce a result. 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 16 Scaling Factor: 10000 - Clients: 800 - Mode: Read Write benchmark2 2K 4K 6K 8K 10K SE +/- 63.13, N = 3 9130 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
OpenBenchmarking.org ms, Fewer Is Better PostgreSQL 16 Scaling Factor: 10000 - Clients: 800 - Mode: Read Write - Average Latency benchmark2 20 40 60 80 100 SE +/- 0.61, N = 3 87.63 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
OpenBenchmarking.org TPS, More Is Better PostgreSQL 16 Scaling Factor: 10000 - Clients: 1000 - Mode: Read Write benchmark2 2K 4K 6K 8K 10K SE +/- 76.65, N = 3 9181 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
OpenBenchmarking.org ms, Fewer Is Better PostgreSQL 16 Scaling Factor: 10000 - Clients: 1000 - Mode: Read Write - Average Latency benchmark2 20 40 60 80 100 SE +/- 0.91, N = 3 108.94 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
Scaling Factor: 10000 - Clients: 5000 - Mode: Read Write
benchmark2: The test run did not produce a result. The test run did not produce a result. The test run did not produce a result. E: pgbench: error: need at least 5003 open files, but system limit is 1024
benchmark2 Processor: 32 x Intel Xeon E312xx (Sandy Bridge IBRS update) (32 Cores), Motherboard: QEMU Standard PC (i440FX + PIIX 1996) (1.15.0-1 BIOS), Chipset: Intel 440FX 82441FX PMC, Memory: 16 x GB RAM QEMU, Disk: 1100GB QEMU HDD, Graphics: Cirrus Logic GD 5446, Network: Red Hat Virtio device
OS: Ubuntu 22.04, Kernel: 5.15.0-100-generic (x86_64), Compiler: GCC 11.4.0, File-System: ext4, System Layer: microsoft
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 -vDisk Notes: NONE / discard,errors=remount-ro,relatime,rw / Block Size: 4096Processor Notes: CPU Microcode: 0x1000065Security Notes: gather_data_sampling: Not affected + itlb_multihit: Not affected + l1tf: Not affected + mds: Not affected + meltdown: Not affected + mmio_stale_data: Not affected + retbleed: Not affected + spec_rstack_overflow: Not affected + spec_store_bypass: Mitigation of SSB disabled via prctl and seccomp + spectre_v1: Mitigation of usercopy/swapgs barriers and __user pointer sanitization + spectre_v2: Mitigation of Retpolines IBPB: conditional IBRS_FW STIBP: disabled RSB filling PBRSB-eIBRS: Not affected + srbds: Not affected + tsx_async_abort: Not affected
Testing initiated at 14 March 2024 05:46 by user root.