onprem-loadtest2-database-1 onprem-loadtest2-database-1
Compare your own system(s) to this result file with the
Phoronix Test Suite by running the command:
phoronix-test-suite benchmark 2010290-FI-ONPREMLOA19 onprem-loadtest2-database-1 Processor: 6 x Intel Xeon E5-2680 0 (11 Cores), Motherboard: Intel 440BX (6.00 BIOS), Chipset: Intel 440BX/ZX/DX, Memory: 1 x 2048 MB DRAM, Disk: 9GB Virtual disk + 107GB Virtual disk, Graphics: VMware SVGA II, Network: VMware VMXNET3
OS: Red Hat Enterprise Linux 7.9, Kernel: 3.10.0-1160.2.1.el7.x86_64 (x86_64), Compiler: GCC 4.8.5 20150623, File-System: xfs, Screen Resolution: 1672x1254, System Layer: VMware
Compiler Notes: --build=x86_64-redhat-linux --disable-libgcj --disable-libunwind-exceptions --enable-__cxa_atexit --enable-bootstrap --enable-checking=release --enable-gnu-indirect-function --enable-gnu-unique-object --enable-initfini-array --enable-languages=c,c++,objc,obj-c++,java,fortran,ada,go,lto --enable-plugin --enable-shared --enable-threads=posix --mandir=/usr/share/man --with-arch_32=x86-64 --with-linker-hash-style=gnu --with-tune=genericDisk Notes: DEADLINE / attr2,inode64,noquota,relatime,rwProcessor Notes: CPU Microcode: 0x71aJava Notes: OpenJDK Runtime Environment (build 1.8.0_272-b10)Security Notes: l1tf: Mitigation of PTE Inversion + meltdown: Mitigation of PTI + spec_store_bypass: Mitigation of SSB disabled via prctl and seccomp + spectre_v1: Mitigation of Load fences __user pointer sanitization + spectre_v2: Mitigation of Full retpoline
onprem-loadtest2-database-1 OpenBenchmarking.org Phoronix Test Suite 6 x Intel Xeon E5-2680 0 (11 Cores) Intel 440BX (6.00 BIOS) Intel 440BX/ZX/DX 1 x 2048 MB DRAM 9GB Virtual disk + 107GB Virtual disk VMware SVGA II VMware VMXNET3 Red Hat Enterprise Linux 7.9 3.10.0-1160.2.1.el7.x86_64 (x86_64) GCC 4.8.5 20150623 xfs 1672x1254 VMware Processor Motherboard Chipset Memory Disk Graphics Network OS Kernel Compiler File-System Screen Resolution System Layer Onprem-loadtest2-database-1 Benchmarks System Logs - --build=x86_64-redhat-linux --disable-libgcj --disable-libunwind-exceptions --enable-__cxa_atexit --enable-bootstrap --enable-checking=release --enable-gnu-indirect-function --enable-gnu-unique-object --enable-initfini-array --enable-languages=c,c++,objc,obj-c++,java,fortran,ada,go,lto --enable-plugin --enable-shared --enable-threads=posix --mandir=/usr/share/man --with-arch_32=x86-64 --with-linker-hash-style=gnu --with-tune=generic - DEADLINE / attr2,inode64,noquota,relatime,rw - CPU Microcode: 0x71a - OpenJDK Runtime Environment (build 1.8.0_272-b10) - l1tf: Mitigation of PTE Inversion + meltdown: Mitigation of PTI + spec_store_bypass: Mitigation of SSB disabled via prctl and seccomp + spectre_v1: Mitigation of Load fences __user pointer sanitization + spectre_v2: Mitigation of Full retpoline
onprem-loadtest2-database-1 pgbench: 1000 - 1 - Read Write - Average Latency pgbench: 1000 - 1 - Read Write pgbench: 1000 - 50 - Read Write - Average Latency pgbench: 1000 - 50 - Read Write pgbench: 1000 - 250 - Read Only - Average Latency pgbench: 1000 - 250 - Read Only pgbench: 1000 - 100 - Read Only - Average Latency pgbench: 1000 - 100 - Read Only pgbench: 1000 - 1 - Read Only - Average Latency pgbench: 1000 - 1 - Read Only pgbench: 1000 - 50 - Read Only - Average Latency pgbench: 1000 - 50 - Read Only couchdb: 100 - 1000 - 24 pgbench: 100 - 250 - Read Write - Average Latency pgbench: 100 - 250 - Read Write pgbench: 1 - 1 - Read Write - Average Latency pgbench: 1 - 1 - Read Write influxdb: 4 - 10000 - 2,5000,1 - 10000 influxdb: 64 - 10000 - 2,5000,1 - 10000 influxdb: 1024 - 10000 - 2,5000,1 - 10000 sqlite: 1 pgbench: 100 - 1 - Read Only - Average Latency pgbench: 100 - 1 - Read Only pgbench: 100 - 100 - Read Only - Average Latency pgbench: 100 - 100 - Read Only pgbench: 100 - 100 - Read Write - Average Latency pgbench: 100 - 100 - Read Write pgbench: 100 - 1 - Read Write - Average Latency pgbench: 100 - 1 - Read Write pgbench: 100 - 50 - Read Write - Average Latency pgbench: 100 - 50 - Read Write pgbench: 100 - 250 - Read Only - Average Latency pgbench: 100 - 250 - Read Only pgbench: 100 - 50 - Read Only - Average Latency pgbench: 100 - 50 - Read Only pgbench: 1 - 250 - Read Write - Average Latency pgbench: 1 - 250 - Read Write pgbench: 1 - 100 - Read Write - Average Latency pgbench: 1 - 100 - Read Write pgbench: 1 - 1 - Read Only - Average Latency pgbench: 1 - 1 - Read Only pgbench: 1 - 100 - Read Only - Average Latency pgbench: 1 - 100 - Read Only pgbench: 1 - 50 - Read Write - Average Latency pgbench: 1 - 50 - Read Write pgbench: 1 - 250 - Read Only - Average Latency pgbench: 1 - 250 - Read Only pgbench: 1 - 50 - Read Only - Average Latency pgbench: 1 - 50 - Read Only onprem-loadtest2-database-1 1.360 740 11.855 4220 3.445 72621 1.235 81002 0.145 6887 0.646 77415 229.731 32.610 7698 1.376 745 920069.6 1085000.7 1095750.0 10.575 0.139 7212 1.247 80222 11.946 8377 1.308 765 6.034 8295 3.378 74030 0.637 78579 223.054 1122 71.147 1406 0.119 8419 1.059 94462 33.686 1485 2.695 92805 0.532 94055 OpenBenchmarking.org
PostgreSQL pgbench This is a benchmark of PostgreSQL using pgbench for facilitating the database benchmarks. Learn more via the OpenBenchmarking.org test page.
OpenBenchmarking.org ms, Fewer Is Better PostgreSQL pgbench 13.0 Scaling Factor: 1000 - Clients: 1 - Mode: Read Write - Average Latency onprem-loadtest2-database-1 0.306 0.612 0.918 1.224 1.53 SE +/- 0.037, N = 9 1.360 1. (CC) gcc options: -std=gnu99 -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
OpenBenchmarking.org TPS, More Is Better PostgreSQL pgbench 13.0 Scaling Factor: 1000 - Clients: 1 - Mode: Read Write onprem-loadtest2-database-1 160 320 480 640 800 SE +/- 19.31, N = 9 740 1. (CC) gcc options: -std=gnu99 -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
OpenBenchmarking.org ms, Fewer Is Better PostgreSQL pgbench 13.0 Scaling Factor: 1000 - Clients: 50 - Mode: Read Write - Average Latency onprem-loadtest2-database-1 3 6 9 12 15 SE +/- 0.03, N = 3 11.86 1. (CC) gcc options: -std=gnu99 -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
OpenBenchmarking.org TPS, More Is Better PostgreSQL pgbench 13.0 Scaling Factor: 1000 - Clients: 50 - Mode: Read Write onprem-loadtest2-database-1 900 1800 2700 3600 4500 SE +/- 9.51, N = 3 4220 1. (CC) gcc options: -std=gnu99 -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
OpenBenchmarking.org ms, Fewer Is Better PostgreSQL pgbench 13.0 Scaling Factor: 1000 - Clients: 250 - Mode: Read Only - Average Latency onprem-loadtest2-database-1 0.7751 1.5502 2.3253 3.1004 3.8755 SE +/- 0.032, N = 3 3.445 1. (CC) gcc options: -std=gnu99 -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
OpenBenchmarking.org TPS, More Is Better PostgreSQL pgbench 13.0 Scaling Factor: 1000 - Clients: 250 - Mode: Read Only onprem-loadtest2-database-1 16K 32K 48K 64K 80K SE +/- 658.28, N = 3 72621 1. (CC) gcc options: -std=gnu99 -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
OpenBenchmarking.org ms, Fewer Is Better PostgreSQL pgbench 13.0 Scaling Factor: 1000 - Clients: 100 - Mode: Read Only - Average Latency onprem-loadtest2-database-1 0.2779 0.5558 0.8337 1.1116 1.3895 SE +/- 0.004, N = 3 1.235 1. (CC) gcc options: -std=gnu99 -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
OpenBenchmarking.org TPS, More Is Better PostgreSQL pgbench 13.0 Scaling Factor: 1000 - Clients: 100 - Mode: Read Only onprem-loadtest2-database-1 20K 40K 60K 80K 100K SE +/- 260.80, N = 3 81002 1. (CC) gcc options: -std=gnu99 -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
OpenBenchmarking.org ms, Fewer Is Better PostgreSQL pgbench 13.0 Scaling Factor: 1000 - Clients: 1 - Mode: Read Only - Average Latency onprem-loadtest2-database-1 0.0326 0.0652 0.0978 0.1304 0.163 SE +/- 0.002, N = 3 0.145 1. (CC) gcc options: -std=gnu99 -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
OpenBenchmarking.org TPS, More Is Better PostgreSQL pgbench 13.0 Scaling Factor: 1000 - Clients: 1 - Mode: Read Only onprem-loadtest2-database-1 1500 3000 4500 6000 7500 SE +/- 113.36, N = 3 6887 1. (CC) gcc options: -std=gnu99 -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
OpenBenchmarking.org ms, Fewer Is Better PostgreSQL pgbench 13.0 Scaling Factor: 1000 - Clients: 50 - Mode: Read Only - Average Latency onprem-loadtest2-database-1 0.1454 0.2908 0.4362 0.5816 0.727 SE +/- 0.001, N = 3 0.646 1. (CC) gcc options: -std=gnu99 -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
OpenBenchmarking.org TPS, More Is Better PostgreSQL pgbench 13.0 Scaling Factor: 1000 - Clients: 50 - Mode: Read Only onprem-loadtest2-database-1 17K 34K 51K 68K 85K SE +/- 92.83, N = 3 77415 1. (CC) gcc options: -std=gnu99 -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
OpenBenchmarking.org TPS, More Is Better PostgreSQL pgbench 13.0 Scaling Factor: 100 - Clients: 250 - Mode: Read Write onprem-loadtest2-database-1 1600 3200 4800 6400 8000 SE +/- 131.57, N = 13 7698 1. (CC) gcc options: -std=gnu99 -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
OpenBenchmarking.org ms, Fewer Is Better PostgreSQL pgbench 13.0 Scaling Factor: 1 - Clients: 1 - Mode: Read Write - Average Latency onprem-loadtest2-database-1 0.3096 0.6192 0.9288 1.2384 1.548 SE +/- 0.059, N = 15 1.376 1. (CC) gcc options: -std=gnu99 -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
OpenBenchmarking.org TPS, More Is Better PostgreSQL pgbench 13.0 Scaling Factor: 1 - Clients: 1 - Mode: Read Write onprem-loadtest2-database-1 160 320 480 640 800 SE +/- 29.70, N = 15 745 1. (CC) gcc options: -std=gnu99 -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
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 onprem-loadtest2-database-1 200K 400K 600K 800K 1000K SE +/- 3406.54, N = 3 920069.6
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 onprem-loadtest2-database-1 200K 400K 600K 800K 1000K SE +/- 2478.32, N = 3 1085000.7
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 onprem-loadtest2-database-1 200K 400K 600K 800K 1000K SE +/- 1210.65, N = 3 1095750.0
PostgreSQL pgbench This is a benchmark of PostgreSQL using pgbench for facilitating the database benchmarks. Learn more via the OpenBenchmarking.org test page.
OpenBenchmarking.org ms, Fewer Is Better PostgreSQL pgbench 13.0 Scaling Factor: 100 - Clients: 1 - Mode: Read Only - Average Latency onprem-loadtest2-database-1 0.0313 0.0626 0.0939 0.1252 0.1565 SE +/- 0.001, N = 3 0.139 1. (CC) gcc options: -std=gnu99 -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
OpenBenchmarking.org TPS, More Is Better PostgreSQL pgbench 13.0 Scaling Factor: 100 - Clients: 1 - Mode: Read Only onprem-loadtest2-database-1 1500 3000 4500 6000 7500 SE +/- 70.33, N = 3 7212 1. (CC) gcc options: -std=gnu99 -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
OpenBenchmarking.org ms, Fewer Is Better PostgreSQL pgbench 13.0 Scaling Factor: 100 - Clients: 100 - Mode: Read Only - Average Latency onprem-loadtest2-database-1 0.2806 0.5612 0.8418 1.1224 1.403 SE +/- 0.001, N = 3 1.247 1. (CC) gcc options: -std=gnu99 -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
OpenBenchmarking.org TPS, More Is Better PostgreSQL pgbench 13.0 Scaling Factor: 100 - Clients: 100 - Mode: Read Only onprem-loadtest2-database-1 20K 40K 60K 80K 100K SE +/- 62.73, N = 3 80222 1. (CC) gcc options: -std=gnu99 -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
OpenBenchmarking.org ms, Fewer Is Better PostgreSQL pgbench 13.0 Scaling Factor: 100 - Clients: 100 - Mode: Read Write - Average Latency onprem-loadtest2-database-1 3 6 9 12 15 SE +/- 0.15, N = 3 11.95 1. (CC) gcc options: -std=gnu99 -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
OpenBenchmarking.org TPS, More Is Better PostgreSQL pgbench 13.0 Scaling Factor: 100 - Clients: 100 - Mode: Read Write onprem-loadtest2-database-1 2K 4K 6K 8K 10K SE +/- 104.42, N = 3 8377 1. (CC) gcc options: -std=gnu99 -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
OpenBenchmarking.org ms, Fewer Is Better PostgreSQL pgbench 13.0 Scaling Factor: 100 - Clients: 1 - Mode: Read Write - Average Latency onprem-loadtest2-database-1 0.2943 0.5886 0.8829 1.1772 1.4715 SE +/- 0.020, N = 3 1.308 1. (CC) gcc options: -std=gnu99 -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
OpenBenchmarking.org TPS, More Is Better PostgreSQL pgbench 13.0 Scaling Factor: 100 - Clients: 1 - Mode: Read Write onprem-loadtest2-database-1 160 320 480 640 800 SE +/- 11.87, N = 3 765 1. (CC) gcc options: -std=gnu99 -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
OpenBenchmarking.org ms, Fewer Is Better PostgreSQL pgbench 13.0 Scaling Factor: 100 - Clients: 50 - Mode: Read Write - Average Latency onprem-loadtest2-database-1 2 4 6 8 10 SE +/- 0.102, N = 3 6.034 1. (CC) gcc options: -std=gnu99 -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
OpenBenchmarking.org TPS, More Is Better PostgreSQL pgbench 13.0 Scaling Factor: 100 - Clients: 50 - Mode: Read Write onprem-loadtest2-database-1 2K 4K 6K 8K 10K SE +/- 141.96, N = 3 8295 1. (CC) gcc options: -std=gnu99 -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
OpenBenchmarking.org ms, Fewer Is Better PostgreSQL pgbench 13.0 Scaling Factor: 100 - Clients: 250 - Mode: Read Only - Average Latency onprem-loadtest2-database-1 0.7601 1.5202 2.2803 3.0404 3.8005 SE +/- 0.003, N = 3 3.378 1. (CC) gcc options: -std=gnu99 -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
OpenBenchmarking.org TPS, More Is Better PostgreSQL pgbench 13.0 Scaling Factor: 100 - Clients: 250 - Mode: Read Only onprem-loadtest2-database-1 16K 32K 48K 64K 80K SE +/- 68.36, N = 3 74030 1. (CC) gcc options: -std=gnu99 -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
OpenBenchmarking.org ms, Fewer Is Better PostgreSQL pgbench 13.0 Scaling Factor: 100 - Clients: 50 - Mode: Read Only - Average Latency onprem-loadtest2-database-1 0.1433 0.2866 0.4299 0.5732 0.7165 SE +/- 0.002, N = 3 0.637 1. (CC) gcc options: -std=gnu99 -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
OpenBenchmarking.org TPS, More Is Better PostgreSQL pgbench 13.0 Scaling Factor: 100 - Clients: 50 - Mode: Read Only onprem-loadtest2-database-1 20K 40K 60K 80K 100K SE +/- 273.18, N = 3 78579 1. (CC) gcc options: -std=gnu99 -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
OpenBenchmarking.org ms, Fewer Is Better PostgreSQL pgbench 13.0 Scaling Factor: 1 - Clients: 250 - Mode: Read Write - Average Latency onprem-loadtest2-database-1 50 100 150 200 250 SE +/- 2.76, N = 5 223.05 1. (CC) gcc options: -std=gnu99 -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
OpenBenchmarking.org TPS, More Is Better PostgreSQL pgbench 13.0 Scaling Factor: 1 - Clients: 250 - Mode: Read Write onprem-loadtest2-database-1 200 400 600 800 1000 SE +/- 14.18, N = 5 1122 1. (CC) gcc options: -std=gnu99 -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
OpenBenchmarking.org ms, Fewer Is Better PostgreSQL pgbench 13.0 Scaling Factor: 1 - Clients: 100 - Mode: Read Write - Average Latency onprem-loadtest2-database-1 16 32 48 64 80 SE +/- 0.46, N = 3 71.15 1. (CC) gcc options: -std=gnu99 -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
OpenBenchmarking.org TPS, More Is Better PostgreSQL pgbench 13.0 Scaling Factor: 1 - Clients: 100 - Mode: Read Write onprem-loadtest2-database-1 300 600 900 1200 1500 SE +/- 9.12, N = 3 1406 1. (CC) gcc options: -std=gnu99 -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
OpenBenchmarking.org ms, Fewer Is Better PostgreSQL pgbench 13.0 Scaling Factor: 1 - Clients: 1 - Mode: Read Only - Average Latency onprem-loadtest2-database-1 0.0268 0.0536 0.0804 0.1072 0.134 SE +/- 0.001, N = 3 0.119 1. (CC) gcc options: -std=gnu99 -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
OpenBenchmarking.org TPS, More Is Better PostgreSQL pgbench 13.0 Scaling Factor: 1 - Clients: 1 - Mode: Read Only onprem-loadtest2-database-1 2K 4K 6K 8K 10K SE +/- 40.13, N = 3 8419 1. (CC) gcc options: -std=gnu99 -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
OpenBenchmarking.org ms, Fewer Is Better PostgreSQL pgbench 13.0 Scaling Factor: 1 - Clients: 100 - Mode: Read Only - Average Latency onprem-loadtest2-database-1 0.2383 0.4766 0.7149 0.9532 1.1915 SE +/- 0.001, N = 3 1.059 1. (CC) gcc options: -std=gnu99 -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
OpenBenchmarking.org TPS, More Is Better PostgreSQL pgbench 13.0 Scaling Factor: 1 - Clients: 100 - Mode: Read Only onprem-loadtest2-database-1 20K 40K 60K 80K 100K SE +/- 83.53, N = 3 94462 1. (CC) gcc options: -std=gnu99 -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
OpenBenchmarking.org ms, Fewer Is Better PostgreSQL pgbench 13.0 Scaling Factor: 1 - Clients: 50 - Mode: Read Write - Average Latency onprem-loadtest2-database-1 8 16 24 32 40 SE +/- 0.21, N = 3 33.69 1. (CC) gcc options: -std=gnu99 -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
OpenBenchmarking.org TPS, More Is Better PostgreSQL pgbench 13.0 Scaling Factor: 1 - Clients: 50 - Mode: Read Write onprem-loadtest2-database-1 300 600 900 1200 1500 SE +/- 9.38, N = 3 1485 1. (CC) gcc options: -std=gnu99 -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
OpenBenchmarking.org ms, Fewer Is Better PostgreSQL pgbench 13.0 Scaling Factor: 1 - Clients: 250 - Mode: Read Only - Average Latency onprem-loadtest2-database-1 0.6064 1.2128 1.8192 2.4256 3.032 SE +/- 0.004, N = 3 2.695 1. (CC) gcc options: -std=gnu99 -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
OpenBenchmarking.org TPS, More Is Better PostgreSQL pgbench 13.0 Scaling Factor: 1 - Clients: 250 - Mode: Read Only onprem-loadtest2-database-1 20K 40K 60K 80K 100K SE +/- 146.09, N = 3 92805 1. (CC) gcc options: -std=gnu99 -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
OpenBenchmarking.org ms, Fewer Is Better PostgreSQL pgbench 13.0 Scaling Factor: 1 - Clients: 50 - Mode: Read Only - Average Latency onprem-loadtest2-database-1 0.1197 0.2394 0.3591 0.4788 0.5985 SE +/- 0.001, N = 3 0.532 1. (CC) gcc options: -std=gnu99 -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
OpenBenchmarking.org TPS, More Is Better PostgreSQL pgbench 13.0 Scaling Factor: 1 - Clients: 50 - Mode: Read Only onprem-loadtest2-database-1 20K 40K 60K 80K 100K SE +/- 219.16, N = 3 94055 1. (CC) gcc options: -std=gnu99 -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
onprem-loadtest2-database-1 Processor: 6 x Intel Xeon E5-2680 0 (11 Cores), Motherboard: Intel 440BX (6.00 BIOS), Chipset: Intel 440BX/ZX/DX, Memory: 1 x 2048 MB DRAM, Disk: 9GB Virtual disk + 107GB Virtual disk, Graphics: VMware SVGA II, Network: VMware VMXNET3
OS: Red Hat Enterprise Linux 7.9, Kernel: 3.10.0-1160.2.1.el7.x86_64 (x86_64), Compiler: GCC 4.8.5 20150623, File-System: xfs, Screen Resolution: 1672x1254, System Layer: VMware
Compiler Notes: --build=x86_64-redhat-linux --disable-libgcj --disable-libunwind-exceptions --enable-__cxa_atexit --enable-bootstrap --enable-checking=release --enable-gnu-indirect-function --enable-gnu-unique-object --enable-initfini-array --enable-languages=c,c++,objc,obj-c++,java,fortran,ada,go,lto --enable-plugin --enable-shared --enable-threads=posix --mandir=/usr/share/man --with-arch_32=x86-64 --with-linker-hash-style=gnu --with-tune=genericDisk Notes: DEADLINE / attr2,inode64,noquota,relatime,rwProcessor Notes: CPU Microcode: 0x71aJava Notes: OpenJDK Runtime Environment (build 1.8.0_272-b10)Security Notes: l1tf: Mitigation of PTE Inversion + meltdown: Mitigation of PTI + spec_store_bypass: Mitigation of SSB disabled via prctl and seccomp + spectre_v1: Mitigation of Load fences __user pointer sanitization + spectre_v2: Mitigation of Full retpoline
Testing initiated at 29 October 2020 17:35 by user .