benchmark1 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: 32 x 16 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
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 benchmark1 50 100 150 200 250 SE +/- 0.59, N = 3 230.90 1. (CC) gcc options: -O2 -fvisibility=hidden -lgpg-error
OpenBenchmarking.org us Per Event, Fewer Is Better OSBench Test: Create Threads benchmark1 5 10 15 20 25 SE +/- 0.78, N = 12 19.00 1. (CC) gcc options: -lm
OpenBenchmarking.org us Per Event, Fewer Is Better OSBench Test: Launch Programs benchmark1 13 26 39 52 65 SE +/- 0.30, N = 3 56.06 1. (CC) gcc options: -lm
OpenBenchmarking.org us Per Event, Fewer Is Better OSBench Test: Create Processes benchmark1 10 20 30 40 50 SE +/- 1.77, N = 15 44.30 1. (CC) gcc options: -lm
OpenBenchmarking.org Ns Per Event, Fewer Is Better OSBench Test: Memory Allocations benchmark1 20 40 60 80 100 SE +/- 0.15, N = 3 81.75 1. (CC) gcc options: -lm
OpenBenchmarking.org MB/s, More Is Better Zstd Compression 1.5.4 Compression Level: 3, Long Mode - Compression Speed benchmark1 100 200 300 400 500 SE +/- 1.99, N = 3 451.6 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 benchmark1 300 600 900 1200 1500 SE +/- 2.84, N = 3 1213.2 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 benchmark1 140 280 420 560 700 SE +/- 2.69, N = 3 634.8 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 - Decompression Speed benchmark1 300 600 900 1200 1500 SE +/- 4.55, N = 2 1299.0 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 benchmark1 200 400 600 800 1000 SE +/- 2.11, N = 3 1118.7 1. (CC) gcc options: -O3 -pthread -lz -llzma -llz4
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
benchmark1: 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
benchmark1: 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 benchmark1 14K 28K 42K 56K 70K SE +/- 143.39, N = 3 66899.47 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 benchmark1 14K 28K 42K 56K 70K SE +/- 120.01, N = 3 66803.67 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 benchmark1 14K 28K 42K 56K 70K SE +/- 118.37, N = 3 66994.42 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 benchmark1 15K 30K 45K 60K 75K SE +/- 281.90, N = 3 68221.14 1. (CC) gcc options: -lluajit-5.1 -lm -lssl -lcrypto -lpthread -ldl -std=c99 -O2
Connections: 4000
benchmark1: 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
benchmark1: 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
benchmark1: 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 benchmark1 14K 28K 42K 56K 70K SE +/- 410.24, N = 3 64921.53 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 benchmark1 20K 40K 60K 80K 100K SE +/- 214.30, N = 3 90671.97 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 benchmark1 20K 40K 60K 80K 100K SE +/- 444.81, N = 3 107367.61 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 benchmark1 20K 40K 60K 80K 100K SE +/- 630.84, N = 3 101459.03 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 benchmark1 2000M 4000M 6000M 8000M 10000M SE +/- 10644395.57, N = 3 9273922607 1. (CC) gcc options: -pthread -m64 -O3 -lssl -lcrypto -ldl
OpenBenchmarking.org byte/s, More Is Better OpenSSL 3.1 Algorithm: SHA512 benchmark1 2000M 4000M 6000M 8000M 10000M SE +/- 5967061.59, N = 3 9184916333 1. (CC) gcc options: -pthread -m64 -O3 -lssl -lcrypto -ldl
OpenBenchmarking.org sign/s, More Is Better OpenSSL 3.1 Algorithm: RSA4096 benchmark1 1000 2000 3000 4000 5000 SE +/- 0.50, N = 3 4783.0 1. (CC) gcc options: -pthread -m64 -O3 -lssl -lcrypto -ldl
OpenBenchmarking.org verify/s, More Is Better OpenSSL 3.1 Algorithm: RSA4096 benchmark1 70K 140K 210K 280K 350K SE +/- 41.21, N = 3 312702.4 1. (CC) gcc options: -pthread -m64 -O3 -lssl -lcrypto -ldl
OpenBenchmarking.org byte/s, More Is Better OpenSSL 3.1 Algorithm: ChaCha20 benchmark1 11000M 22000M 33000M 44000M 55000M SE +/- 6518905.80, N = 3 51552001680 1. (CC) gcc options: -pthread -m64 -O3 -lssl -lcrypto -ldl
OpenBenchmarking.org byte/s, More Is Better OpenSSL 3.1 Algorithm: AES-128-GCM benchmark1 20000M 40000M 60000M 80000M 100000M SE +/- 16125132.26, N = 3 112251603173 1. (CC) gcc options: -pthread -m64 -O3 -lssl -lcrypto -ldl
OpenBenchmarking.org byte/s, More Is Better OpenSSL 3.1 Algorithm: AES-256-GCM benchmark1 20000M 40000M 60000M 80000M 100000M SE +/- 40113240.38, N = 3 103496803030 1. (CC) gcc options: -pthread -m64 -O3 -lssl -lcrypto -ldl
OpenBenchmarking.org byte/s, More Is Better OpenSSL 3.1 Algorithm: ChaCha20-Poly1305 benchmark1 8000M 16000M 24000M 32000M 40000M SE +/- 1803211.39, N = 3 38130242993 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 benchmark1 160K 320K 480K 640K 800K SE +/- 4144.98, N = 3 738250
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 benchmark1 60 120 180 240 300 SE +/- 2.94, N = 9 282.81 MIN: 17.67 / MAX: 4000
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 benchmark1 200K 400K 600K 800K 1000K SE +/- 3882.38, N = 3 1014938.2
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 benchmark1 300K 600K 900K 1200K 1500K SE +/- 1586.66, N = 3 1360914.0
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 benchmark1 300K 600K 900K 1200K 1500K SE +/- 1059.54, N = 3 1431827.2
OpenBenchmarking.org Requests Per Second, More Is Better Redis 7.0.4 Test: SET - Parallel Connections: 50 benchmark1 500K 1000K 1500K 2000K 2500K SE +/- 8734.43, N = 3 2155467.33 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 benchmark1 400K 800K 1200K 1600K 2000K SE +/- 13569.05, N = 3 1898002.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: 50 benchmark1 700K 1400K 2100K 2800K 3500K SE +/- 18615.59, N = 3 3095040.83 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 benchmark1 500K 1000K 1500K 2000K 2500K SE +/- 16626.18, N = 3 2451916.7 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 benchmark1 300K 600K 900K 1200K 1500K SE +/- 15166.21, N = 6 1561463.12 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 benchmark1 400K 800K 1200K 1600K 2000K SE +/- 19488.83, N = 6 2008311.88 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 benchmark1 500K 1000K 1500K 2000K 2500K SE +/- 9348.61, N = 3 2315503.42 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 benchmark1 300K 600K 900K 1200K 1500K SE +/- 19833.10, N = 3 1627481.04 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 benchmark1 400K 800K 1200K 1600K 2000K SE +/- 18026.83, N = 3 1776199.21 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 benchmark1 400K 800K 1200K 1600K 2000K SE +/- 15482.92, N = 3 1642766.46 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 benchmark1 300K 600K 900K 1200K 1500K SE +/- 6771.36, N = 3 1357425.17 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 benchmark1 300K 600K 900K 1200K 1500K SE +/- 7524.16, N = 3 1337782.41 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 benchmark1 400K 800K 1200K 1600K 2000K SE +/- 17823.28, N = 3 1859846.75 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 benchmark1 300K 600K 900K 1200K 1500K SE +/- 7005.20, N = 3 1412245.29 1. (CXX) g++ options: -MM -MT -g3 -fvisibility=hidden -O3
OpenBenchmarking.org Seconds, Fewer Is Better SQLite 3.30.1 Threads / Copies: 8 benchmark1 7 14 21 28 35 SE +/- 0.33, N = 3 28.32 1. (CC) gcc options: -O2 -lreadline -ltermcap -lz -lm
OpenBenchmarking.org Seconds, Fewer Is Better SQLite 3.30.1 Threads / Copies: 32 benchmark1 14 28 42 56 70 SE +/- 0.64, N = 3 61.17 1. (CC) gcc options: -O2 -lreadline -ltermcap -lz -lm
OpenBenchmarking.org Seconds, Fewer Is Better SQLite 3.30.1 Threads / Copies: 64 benchmark1 20 40 60 80 100 SE +/- 1.20, N = 3 92.23 1. (CC) gcc options: -O2 -lreadline -ltermcap -lz -lm
OpenBenchmarking.org Seconds, Fewer Is Better SQLite 3.30.1 Threads / Copies: 128 benchmark1 30 60 90 120 150 SE +/- 1.56, N = 3 139.12 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 benchmark1 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 benchmark1 300 600 900 1200 1500 SE +/- 21.70, N = 12 1576 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 benchmark1 0.1431 0.2862 0.4293 0.5724 0.7155 SE +/- 0.009, N = 12 0.636 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 benchmark1 200K 400K 600K 800K 1000K SE +/- 1057.10, N = 3 1121243 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 benchmark1 0.0101 0.0202 0.0303 0.0404 0.0505 SE +/- 0.000, N = 3 0.045 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 benchmark1 300K 600K 900K 1200K 1500K SE +/- 14582.63, N = 5 1328914 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 benchmark1 0.0169 0.0338 0.0507 0.0676 0.0845 SE +/- 0.001, N = 5 0.075 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 benchmark1 300K 600K 900K 1200K 1500K SE +/- 15872.01, N = 3 1279152 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 benchmark1 0.0439 0.0878 0.1317 0.1756 0.2195 SE +/- 0.003, N = 3 0.195 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 benchmark1 200 400 600 800 1000 SE +/- 7.28, N = 3 1088 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 benchmark1 10 20 30 40 50 SE +/- 0.31, N = 3 45.95 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 benchmark1 200K 400K 600K 800K 1000K SE +/- 3413.12, N = 3 1020610 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 benchmark1 0.1103 0.2206 0.3309 0.4412 0.5515 SE +/- 0.002, N = 3 0.490 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 benchmark1 200K 400K 600K 800K 1000K SE +/- 3449.65, N = 3 1069276 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 benchmark1 0.1683 0.3366 0.5049 0.6732 0.8415 SE +/- 0.002, N = 3 0.748 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 benchmark1 9K 18K 27K 36K 45K SE +/- 1337.16, N = 9 42728 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 benchmark1 0.0054 0.0108 0.0162 0.0216 0.027 SE +/- 0.001, N = 9 0.024 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 benchmark1 200 400 600 800 1000 SE +/- 5.51, N = 3 1001 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 benchmark1 20 40 60 80 100 SE +/- 0.55, N = 3 99.88 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 benchmark1 200K 400K 600K 800K 1000K SE +/- 6101.00, N = 3 1070152 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 benchmark1 0.2104 0.4208 0.6312 0.8416 1.052 SE +/- 0.005, N = 3 0.935 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 benchmark1 200 400 600 800 1000 SE +/- 10.68, N = 4 890 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 benchmark1 60 120 180 240 300 SE +/- 3.35, N = 4 281.11 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 benchmark1 150 300 450 600 750 SE +/- 8.18, N = 12 713 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 benchmark1 150 300 450 600 750 SE +/- 8.16, N = 12 701.88 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
Scaling Factor: 1 - Clients: 5000 - Mode: Read Only
benchmark1: 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 benchmark1 130 260 390 520 650 SE +/- 6.65, N = 4 604 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 benchmark1 300 600 900 1200 1500 SE +/- 14.62, N = 4 1326.00 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 benchmark1 300 600 900 1200 1500 SE +/- 2.59, N = 3 1203 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 benchmark1 0.187 0.374 0.561 0.748 0.935 SE +/- 0.002, N = 3 0.831 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 benchmark1 200K 400K 600K 800K 1000K SE +/- 10304.09, N = 3 976596 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 benchmark1 0.0115 0.023 0.0345 0.046 0.0575 SE +/- 0.001, 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 benchmark1 9K 18K 27K 36K 45K SE +/- 422.98, N = 3 40117 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 benchmark1 0.0056 0.0112 0.0168 0.0224 0.028 SE +/- 0.000, N = 3 0.025 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 benchmark1 110 220 330 440 550 SE +/- 7.60, N = 9 523 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 benchmark1 400 800 1200 1600 2000 SE +/- 28.42, N = 9 1914.00 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
Scaling Factor: 1 - Clients: 5000 - Mode: Read Write
benchmark1: 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 benchmark1 200K 400K 600K 800K 1000K SE +/- 6095.47, N = 3 1046261 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 benchmark1 0.0216 0.0432 0.0648 0.0864 0.108 SE +/- 0.001, N = 3 0.096 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 benchmark1 200K 400K 600K 800K 1000K SE +/- 10986.24, N = 5 1099830 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 benchmark1 0.0511 0.1022 0.1533 0.2044 0.2555 SE +/- 0.002, N = 5 0.227 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 benchmark1 4K 8K 12K 16K 20K SE +/- 129.39, N = 3 18654 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 benchmark1 0.6032 1.2064 1.8096 2.4128 3.016 SE +/- 0.019, N = 3 2.681 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 benchmark1 200K 400K 600K 800K 1000K SE +/- 6782.09, N = 3 926597 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 benchmark1 0.1215 0.243 0.3645 0.486 0.6075 SE +/- 0.004, N = 3 0.540 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 benchmark1 200K 400K 600K 800K 1000K SE +/- 5741.01, N = 3 939527 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 benchmark1 0.1917 0.3834 0.5751 0.7668 0.9585 SE +/- 0.005, N = 3 0.852 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 benchmark1 200 400 600 800 1000 SE +/- 9.02, N = 3 993 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 benchmark1 0.2266 0.4532 0.6798 0.9064 1.133 SE +/- 0.009, N = 3 1.007 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 benchmark1 140K 280K 420K 560K 700K SE +/- 2703.76, N = 3 645408 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 benchmark1 0.0173 0.0346 0.0519 0.0692 0.0865 SE +/- 0.000, N = 3 0.077 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 benchmark1 7K 14K 21K 28K 35K SE +/- 151.09, N = 3 33783 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 benchmark1 0.0068 0.0136 0.0204 0.0272 0.034 SE +/- 0.000, N = 3 0.030 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 benchmark1 5K 10K 15K 20K 25K SE +/- 146.67, N = 3 22679 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 benchmark1 0.9923 1.9846 2.9769 3.9692 4.9615 SE +/- 0.028, N = 3 4.410 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 benchmark1 200K 400K 600K 800K 1000K SE +/- 1516.82, N = 3 937594 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 benchmark1 0.2401 0.4802 0.7203 0.9604 1.2005 SE +/- 0.002, N = 3 1.067 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 benchmark1 5K 10K 15K 20K 25K SE +/- 135.71, N = 3 25600 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 benchmark1 3 6 9 12 15 SE +/- 0.052, N = 3 9.766 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 benchmark1 5K 10K 15K 20K 25K SE +/- 90.71, N = 3 25012 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 benchmark1 5 10 15 20 25 SE +/- 0.07, N = 3 19.99 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
Scaling Factor: 100 - Clients: 5000 - Mode: Read Only
benchmark1: 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 benchmark1 5K 10K 15K 20K 25K SE +/- 217.17, N = 3 23879 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 benchmark1 8 16 24 32 40 SE +/- 0.31, N = 3 33.51 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 benchmark1 130K 260K 390K 520K 650K SE +/- 10914.00, N = 12 610866 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 benchmark1 0.0369 0.0738 0.1107 0.1476 0.1845 SE +/- 0.003, N = 12 0.164 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 benchmark1 140K 280K 420K 560K 700K SE +/- 22665.66, N = 9 643135 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 benchmark1 0.0884 0.1768 0.2652 0.3536 0.442 SE +/- 0.015, N = 9 0.393 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 benchmark1 2K 4K 6K 8K 10K SE +/- 77.75, N = 3 9507 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 benchmark1 1.1835 2.367 3.5505 4.734 5.9175 SE +/- 0.043, N = 3 5.260 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 benchmark1 150K 300K 450K 600K 750K SE +/- 2531.85, N = 3 703106 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 benchmark1 0.16 0.32 0.48 0.64 0.8 SE +/- 0.002, N = 3 0.711 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 benchmark1 150K 300K 450K 600K 750K SE +/- 1635.84, N = 3 696939 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 benchmark1 0.2583 0.5166 0.7749 1.0332 1.2915 SE +/- 0.003, N = 3 1.148 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 benchmark1 200 400 600 800 1000 SE +/- 23.21, N = 9 1044 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 benchmark1 0.2162 0.4324 0.6486 0.8648 1.081 SE +/- 0.020, N = 9 0.961 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 benchmark1 110K 220K 330K 440K 550K SE +/- 3303.52, N = 3 513831 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 benchmark1 0.0218 0.0436 0.0654 0.0872 0.109 SE +/- 0.001, 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: 1000 - Mode: Read Write benchmark1 5K 10K 15K 20K 25K SE +/- 72.09, N = 3 22787 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 benchmark1 10 20 30 40 50 SE +/- 0.14, N = 3 43.89 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
Scaling Factor: 100 - Clients: 5000 - Mode: Read Write
benchmark1: 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 benchmark1 3K 6K 9K 12K 15K SE +/- 25.70, N = 3 11964 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 benchmark1 2 4 6 8 10 SE +/- 0.018, N = 3 8.359 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 benchmark1 150K 300K 450K 600K 750K SE +/- 2727.25, N = 3 692888 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 benchmark1 0.3247 0.6494 0.9741 1.2988 1.6235 SE +/- 0.006, N = 3 1.443 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 benchmark1 3K 6K 9K 12K 15K SE +/- 133.12, N = 6 13619 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 benchmark1 5 10 15 20 25 SE +/- 0.18, N = 6 18.37 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 benchmark1 2K 4K 6K 8K 10K SE +/- 66.57, N = 3 9611 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 benchmark1 12 24 36 48 60 SE +/- 0.36, N = 3 52.03 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
Scaling Factor: 1000 - Clients: 5000 - Mode: Read Only
benchmark1: 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 benchmark1 2K 4K 6K 8K 10K SE +/- 39.71, N = 3 10847 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 benchmark1 16 32 48 64 80 SE +/- 0.27, N = 3 73.75 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 benchmark1 90K 180K 270K 360K 450K SE +/- 840.27, N = 3 434191 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 benchmark1 0.0518 0.1036 0.1554 0.2072 0.259 SE +/- 0.000, N = 3 0.230 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 benchmark1 110K 220K 330K 440K 550K SE +/- 546.37, N = 3 533283 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 benchmark1 0.1055 0.211 0.3165 0.422 0.5275 SE +/- 0.000, N = 3 0.469 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 benchmark1 2K 4K 6K 8K 10K SE +/- 27.78, N = 3 7962 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 benchmark1 2 4 6 8 10 SE +/- 0.022, N = 3 6.280 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 benchmark1 120K 240K 360K 480K 600K SE +/- 2717.46, N = 3 552466 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 benchmark1 0.2036 0.4072 0.6108 0.8144 1.018 SE +/- 0.005, N = 3 0.905 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 benchmark1 120K 240K 360K 480K 600K SE +/- 432.42, N = 3 562942 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 benchmark1 0.3197 0.6394 0.9591 1.2788 1.5985 SE +/- 0.001, N = 3 1.421 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 benchmark1 2K 4K 6K 8K 10K SE +/- 103.01, N = 12 11548 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 benchmark1 20 40 60 80 100 SE +/- 0.77, N = 12 86.67 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
Scaling Factor: 1000 - Clients: 5000 - Mode: Read Write
benchmark1: 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 benchmark1 2K 4K 6K 8K 10K SE +/- 93.07, N = 3 9399 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 benchmark1 3 6 9 12 15 SE +/- 0.10, N = 3 10.64 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 benchmark1 120K 240K 360K 480K 600K SE +/- 1459.47, N = 3 556520 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 benchmark1 0.4043 0.8086 1.2129 1.6172 2.0215 SE +/- 0.005, N = 3 1.797 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 benchmark1 2K 4K 6K 8K 10K SE +/- 66.75, N = 3 8915 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 benchmark1 7 14 21 28 35 SE +/- 0.21, N = 3 28.05 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 benchmark1 1700 3400 5100 6800 8500 SE +/- 34.36, N = 3 7766 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 benchmark1 14 28 42 56 70 SE +/- 0.29, N = 3 64.39 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
Scaling Factor: 10000 - Clients: 5000 - Mode: Read Only
benchmark1: 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 benchmark1 2K 4K 6K 8K 10K SE +/- 100.67, N = 4 8493 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 benchmark1 20 40 60 80 100 SE +/- 1.10, N = 4 94.23 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 benchmark1 2K 4K 6K 8K 10K SE +/- 99.84, N = 4 8366 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 benchmark1 30 60 90 120 150 SE +/- 1.44, N = 4 119.58 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
Scaling Factor: 10000 - Clients: 5000 - Mode: Read Write
benchmark1: 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
benchmark1 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: 32 x 16 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:44 by user root.