2022-09-28-1108

Unknown testing with a HPE C01_APACHE_MB (L50_5.13_1.14 BIOS) and ASPEED on Ubuntu 20.04 via the Phoronix Test Suite.

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

Statistics

Remove Outliers Before Calculating Averages

Graph Settings

Prefer Vertical Bar Graphs

Multi-Way Comparison

Condense Multi-Option Tests Into Single Result Graphs

Table

Show Detailed System Result Table

Run Management

Result
Identifier
Performance Per
Dollar
Date
Run
  Test
  Duration
Toshiba MK001920GWUGK
September 28 2022
  13 Hours, 59 Minutes
Only show results matching title/arguments (delimit multiple options with a comma):
Do not show results matching title/arguments (delimit multiple options with a comma):


2022-09-28-1108OpenBenchmarking.orgPhoronix Test SuiteUnknown (64 Cores)HPE C01_APACHE_MB (L50_5.13_1.14 BIOS)Cavium CN99xx128GB1920GB Toshiba MK001920GWUGKASPEED2 x Mellanox MT27710Ubuntu 20.045.4.0-120-generic (aarch64)GCC 9.4.0nfs1024x768ProcessorMotherboardChipsetMemoryDiskGraphicsNetworkOSKernelCompilerFile-SystemScreen Resolution2022-09-28-1108 BenchmarksSystem Logs- Transparent Huge Pages: madvise- --build=aarch64-linux-gnu --disable-libquadmath --disable-libquadmath-support --disable-werror --enable-checking=release --enable-clocale=gnu --enable-default-pie --enable-fix-cortex-a53-843419 --enable-gnu-unique-object --enable-languages=c,ada,c++,go,d,fortran,objc,obj-c++,gm2 --enable-libstdcxx-debug --enable-libstdcxx-time=yes --enable-multiarch --enable-nls --enable-objc-gc=auto --enable-plugin --enable-shared --enable-threads=posix --host=aarch64-linux-gnu --program-prefix=aarch64-linux-gnu- --target=aarch64-linux-gnu --with-default-libstdcxx-abi=new --with-gcc-major-version-only --with-target-system-zlib=auto -v - MQ-DEADLINE- itlb_multihit: Not affected + l1tf: Not affected + mds: Not affected + meltdown: Not affected + mmio_stale_data: Not affected + spec_store_bypass: Vulnerable + spectre_v1: Mitigation of __user pointer sanitization + spectre_v2: Vulnerable + srbds: Not affected + tsx_async_abort: Not affected

2022-09-28-1108sqlite: 1clickhouse: 100M Rows Web Analytics Dataset, First Run / Cold Cacheclickhouse: 100M Rows Web Analytics Dataset, Second Runclickhouse: 100M Rows Web Analytics Dataset, Third Runredis: GET - 50redis: SET - 50redis: GET - 500redis: LPOP - 50redis: SADD - 50redis: SET - 500redis: GET - 1000redis: LPOP - 500redis: LPUSH - 50redis: SADD - 500redis: SET - 1000redis: LPOP - 1000redis: LPUSH - 500redis: SADD - 1000redis: LPUSH - 1000pgbench: 1 - 1 - Read Onlypgbench: 1 - 1 - Read Only - Average Latencypgbench: 1 - 1 - Read Writepgbench: 1 - 1 - Read Write - Average Latencypgbench: 1 - 50 - Read Onlypgbench: 1 - 50 - Read Only - Average Latencypgbench: 1 - 100 - Read Onlypgbench: 1 - 100 - Read Only - Average Latencypgbench: 1 - 250 - Read Onlypgbench: 1 - 250 - Read Only - Average Latencypgbench: 1 - 50 - Read Writepgbench: 1 - 50 - Read Write - Average Latencypgbench: 1 - 500 - Read Onlypgbench: 1 - 500 - Read Only - Average Latencypgbench: 100 - 1 - Read Onlypgbench: 100 - 1 - Read Only - Average Latencypgbench: 1 - 100 - Read Writepgbench: 1 - 100 - Read Write - Average Latencypgbench: 1 - 250 - Read Writepgbench: 1 - 250 - Read Write - Average Latencypgbench: 1 - 500 - Read Writepgbench: 1 - 500 - Read Write - Average Latencypgbench: 100 - 1 - Read Writepgbench: 100 - 1 - Read Write - Average Latencypgbench: 100 - 50 - Read Onlypgbench: 100 - 50 - Read Only - Average Latencypgbench: 1000 - 1 - Read Onlypgbench: 1000 - 1 - Read Only - Average Latencypgbench: 100 - 100 - Read Onlypgbench: 100 - 100 - Read Only - Average Latencypgbench: 100 - 250 - Read Onlypgbench: 100 - 250 - Read Only - Average Latencypgbench: 100 - 50 - Read Writepgbench: 100 - 50 - Read Write - Average Latencypgbench: 100 - 500 - Read Onlypgbench: 100 - 500 - Read Only - Average Latencypgbench: 1000 - 1 - Read Writepgbench: 1000 - 1 - Read Write - Average Latencypgbench: 1000 - 50 - Read Onlypgbench: 1000 - 50 - Read Only - Average Latencysqlite-speedtest: Timed Time - Size 1,000Toshiba MK001920GWUGK59.586121.74127.29128.68984966.99622265.96799283.02995773.89747275.67581037.58808574.33927330.04494709.35691334.66597046.92478685.66467134.68733905.98468253.8579740.1266341.5793595370.1394411830.2273992070.62688756.4014056451.23377180.129785127.493566443.7423731341.2145251.9103477950.14441750.2394216670.2373717480.673301016.8413782851.3224692.1352168600.233185.798OpenBenchmarking.org

SQLite

This is a simple benchmark of SQLite. At present this test profile just measures the time to perform a pre-defined number of insertions on an indexed database. Learn more via the OpenBenchmarking.org test page.

OpenBenchmarking.orgSeconds, Fewer Is BetterSQLite 3.30.1Threads / Copies: 1Toshiba MK001920GWUGK1326395265SE +/- 0.68, N = 359.591. (CC) gcc options: -O2 -ledit -ltinfo -lz -lm -ldl -lpthread

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/ with the 100 million rows web analytics dataset. The reported value is the query processing time using the geometric mean of all queries performed. Learn more via the OpenBenchmarking.org test page.

OpenBenchmarking.orgQueries Per Minute, Geo Mean, More Is BetterClickHouse 22.5.4.19100M Rows Web Analytics Dataset, First Run / Cold CacheToshiba MK001920GWUGK306090120150SE +/- 2.05, N = 12121.74MIN: 8.25 / MAX: 5454.551. ClickHouse server version 22.5.4.19 (official build).

OpenBenchmarking.orgQueries Per Minute, Geo Mean, More Is BetterClickHouse 22.5.4.19100M Rows Web Analytics Dataset, Second RunToshiba MK001920GWUGK306090120150SE +/- 0.93, N = 12127.29MIN: 9.11 / MAX: 60001. ClickHouse server version 22.5.4.19 (official build).

OpenBenchmarking.orgQueries Per Minute, Geo Mean, More Is BetterClickHouse 22.5.4.19100M Rows Web Analytics Dataset, Third RunToshiba MK001920GWUGK306090120150SE +/- 0.99, N = 12128.68MIN: 9.1 / MAX: 60001. ClickHouse server version 22.5.4.19 (official build).

Redis

Redis is an open-source in-memory data structure store, used as a database, cache, and message broker. Learn more via the OpenBenchmarking.org test page.

OpenBenchmarking.orgRequests Per Second, More Is BetterRedis 7.0.4Test: GET - Parallel Connections: 50Toshiba MK001920GWUGK200K400K600K800K1000KSE +/- 6743.10, N = 13984966.991. (CXX) g++ options: -MM -MT -g3 -fvisibility=hidden -O3

OpenBenchmarking.orgRequests Per Second, More Is BetterRedis 7.0.4Test: SET - Parallel Connections: 50Toshiba MK001920GWUGK130K260K390K520K650KSE +/- 3714.71, N = 3622265.961. (CXX) g++ options: -MM -MT -g3 -fvisibility=hidden -O3

OpenBenchmarking.orgRequests Per Second, More Is BetterRedis 7.0.4Test: GET - Parallel Connections: 500Toshiba MK001920GWUGK200K400K600K800K1000KSE +/- 4337.98, N = 3799283.021. (CXX) g++ options: -MM -MT -g3 -fvisibility=hidden -O3

OpenBenchmarking.orgRequests Per Second, More Is BetterRedis 7.0.4Test: LPOP - Parallel Connections: 50Toshiba MK001920GWUGK200K400K600K800K1000KSE +/- 11903.41, N = 4995773.891. (CXX) g++ options: -MM -MT -g3 -fvisibility=hidden -O3

OpenBenchmarking.orgRequests Per Second, More Is BetterRedis 7.0.4Test: SADD - Parallel Connections: 50Toshiba MK001920GWUGK160K320K480K640K800KSE +/- 6798.22, N = 3747275.671. (CXX) g++ options: -MM -MT -g3 -fvisibility=hidden -O3

OpenBenchmarking.orgRequests Per Second, More Is BetterRedis 7.0.4Test: SET - Parallel Connections: 500Toshiba MK001920GWUGK120K240K360K480K600KSE +/- 7178.33, N = 4581037.581. (CXX) g++ options: -MM -MT -g3 -fvisibility=hidden -O3

OpenBenchmarking.orgRequests Per Second, More Is BetterRedis 7.0.4Test: GET - Parallel Connections: 1000Toshiba MK001920GWUGK200K400K600K800K1000KSE +/- 6012.38, N = 3808574.331. (CXX) g++ options: -MM -MT -g3 -fvisibility=hidden -O3

OpenBenchmarking.orgRequests Per Second, More Is BetterRedis 7.0.4Test: LPOP - Parallel Connections: 500Toshiba MK001920GWUGK200K400K600K800K1000KSE +/- 11809.21, N = 3927330.041. (CXX) g++ options: -MM -MT -g3 -fvisibility=hidden -O3

OpenBenchmarking.orgRequests Per Second, More Is BetterRedis 7.0.4Test: LPUSH - Parallel Connections: 50Toshiba MK001920GWUGK110K220K330K440K550KSE +/- 2567.98, N = 3494709.351. (CXX) g++ options: -MM -MT -g3 -fvisibility=hidden -O3

OpenBenchmarking.orgRequests Per Second, More Is BetterRedis 7.0.4Test: SADD - Parallel Connections: 500Toshiba MK001920GWUGK150K300K450K600K750KSE +/- 4714.32, N = 15691334.661. (CXX) g++ options: -MM -MT -g3 -fvisibility=hidden -O3

OpenBenchmarking.orgRequests Per Second, More Is BetterRedis 7.0.4Test: SET - Parallel Connections: 1000Toshiba MK001920GWUGK130K260K390K520K650KSE +/- 8364.95, N = 3597046.921. (CXX) g++ options: -MM -MT -g3 -fvisibility=hidden -O3

OpenBenchmarking.orgRequests Per Second, More Is BetterRedis 7.0.4Test: LPOP - Parallel Connections: 1000Toshiba MK001920GWUGK100K200K300K400K500KSE +/- 2680.28, N = 3478685.661. (CXX) g++ options: -MM -MT -g3 -fvisibility=hidden -O3

OpenBenchmarking.orgRequests Per Second, More Is BetterRedis 7.0.4Test: LPUSH - Parallel Connections: 500Toshiba MK001920GWUGK100K200K300K400K500KSE +/- 2984.01, N = 3467134.681. (CXX) g++ options: -MM -MT -g3 -fvisibility=hidden -O3

OpenBenchmarking.orgRequests Per Second, More Is BetterRedis 7.0.4Test: SADD - Parallel Connections: 1000Toshiba MK001920GWUGK160K320K480K640K800KSE +/- 3301.86, N = 3733905.981. (CXX) g++ options: -MM -MT -g3 -fvisibility=hidden -O3

OpenBenchmarking.orgRequests Per Second, More Is BetterRedis 7.0.4Test: LPUSH - Parallel Connections: 1000Toshiba MK001920GWUGK100K200K300K400K500KSE +/- 5091.60, N = 4468253.851. (CXX) g++ options: -MM -MT -g3 -fvisibility=hidden -O3

PostgreSQL pgbench

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

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 14.0Scaling Factor: 1 - Clients: 1 - Mode: Read OnlyToshiba MK001920GWUGK2K4K6K8K10KSE +/- 44.43, N = 379741. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL pgbench 14.0Scaling Factor: 1 - Clients: 1 - Mode: Read Only - Average LatencyToshiba MK001920GWUGK0.02840.05680.08520.11360.142SE +/- 0.001, N = 30.1261. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 14.0Scaling Factor: 1 - Clients: 1 - Mode: Read WriteToshiba MK001920GWUGK140280420560700SE +/- 6.74, N = 36341. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL pgbench 14.0Scaling Factor: 1 - Clients: 1 - Mode: Read Write - Average LatencyToshiba MK001920GWUGK0.35530.71061.06591.42121.7765SE +/- 0.017, N = 31.5791. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 14.0Scaling Factor: 1 - Clients: 50 - Mode: Read OnlyToshiba MK001920GWUGK80K160K240K320K400KSE +/- 586.82, N = 33595371. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL pgbench 14.0Scaling Factor: 1 - Clients: 50 - Mode: Read Only - Average LatencyToshiba MK001920GWUGK0.03130.06260.09390.12520.1565SE +/- 0.000, N = 30.1391. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 14.0Scaling Factor: 1 - Clients: 100 - Mode: Read OnlyToshiba MK001920GWUGK90K180K270K360K450KSE +/- 904.51, N = 34411831. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL pgbench 14.0Scaling Factor: 1 - Clients: 100 - Mode: Read Only - Average LatencyToshiba MK001920GWUGK0.05110.10220.15330.20440.2555SE +/- 0.001, N = 30.2271. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 14.0Scaling Factor: 1 - Clients: 250 - Mode: Read OnlyToshiba MK001920GWUGK90K180K270K360K450KSE +/- 723.22, N = 33992071. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL pgbench 14.0Scaling Factor: 1 - Clients: 250 - Mode: Read Only - Average LatencyToshiba MK001920GWUGK0.14090.28180.42270.56360.7045SE +/- 0.001, N = 30.6261. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 14.0Scaling Factor: 1 - Clients: 50 - Mode: Read WriteToshiba MK001920GWUGK2004006008001000SE +/- 5.01, N = 38871. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL pgbench 14.0Scaling Factor: 1 - Clients: 50 - Mode: Read Write - Average LatencyToshiba MK001920GWUGK1326395265SE +/- 0.32, N = 356.401. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 14.0Scaling Factor: 1 - Clients: 500 - Mode: Read OnlyToshiba MK001920GWUGK90K180K270K360K450KSE +/- 100.85, N = 34056451. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL pgbench 14.0Scaling Factor: 1 - Clients: 500 - Mode: Read Only - Average LatencyToshiba MK001920GWUGK0.27740.55480.83221.10961.387SE +/- 0.000, N = 31.2331. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 14.0Scaling Factor: 100 - Clients: 1 - Mode: Read OnlyToshiba MK001920GWUGK17003400510068008500SE +/- 8.38, N = 377181. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL pgbench 14.0Scaling Factor: 100 - Clients: 1 - Mode: Read Only - Average LatencyToshiba MK001920GWUGK0.0290.0580.0870.1160.145SE +/- 0.000, N = 30.1291. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 14.0Scaling Factor: 1 - Clients: 100 - Mode: Read WriteToshiba MK001920GWUGK2004006008001000SE +/- 10.18, N = 37851. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL pgbench 14.0Scaling Factor: 1 - Clients: 100 - Mode: Read Write - Average LatencyToshiba MK001920GWUGK306090120150SE +/- 1.66, N = 3127.491. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 14.0Scaling Factor: 1 - Clients: 250 - Mode: Read WriteToshiba MK001920GWUGK120240360480600SE +/- 11.64, N = 125661. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL pgbench 14.0Scaling Factor: 1 - Clients: 250 - Mode: Read Write - Average LatencyToshiba MK001920GWUGK100200300400500SE +/- 9.44, N = 12443.741. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 14.0Scaling Factor: 1 - Clients: 500 - Mode: Read WriteToshiba MK001920GWUGK80160240320400SE +/- 2.52, N = 33731. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL pgbench 14.0Scaling Factor: 1 - Clients: 500 - Mode: Read Write - Average LatencyToshiba MK001920GWUGK30060090012001500SE +/- 9.06, N = 31341.211. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 14.0Scaling Factor: 100 - Clients: 1 - Mode: Read WriteToshiba MK001920GWUGK110220330440550SE +/- 8.30, N = 125251. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL pgbench 14.0Scaling Factor: 100 - Clients: 1 - Mode: Read Write - Average LatencyToshiba MK001920GWUGK0.42980.85961.28941.71922.149SE +/- 0.028, N = 121.9101. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 14.0Scaling Factor: 100 - Clients: 50 - Mode: Read OnlyToshiba MK001920GWUGK70K140K210K280K350KSE +/- 420.12, N = 33477951. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL pgbench 14.0Scaling Factor: 100 - Clients: 50 - Mode: Read Only - Average LatencyToshiba MK001920GWUGK0.03240.06480.09720.12960.162SE +/- 0.000, N = 30.1441. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 14.0Scaling Factor: 1000 - Clients: 1 - Mode: Read OnlyToshiba MK001920GWUGK9001800270036004500SE +/- 20.05, N = 341751. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL pgbench 14.0Scaling Factor: 1000 - Clients: 1 - Mode: Read Only - Average LatencyToshiba MK001920GWUGK0.05380.10760.16140.21520.269SE +/- 0.001, N = 30.2391. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 14.0Scaling Factor: 100 - Clients: 100 - Mode: Read OnlyToshiba MK001920GWUGK90K180K270K360K450KSE +/- 1059.05, N = 34216671. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL pgbench 14.0Scaling Factor: 100 - Clients: 100 - Mode: Read Only - Average LatencyToshiba MK001920GWUGK0.05330.10660.15990.21320.2665SE +/- 0.001, N = 30.2371. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 14.0Scaling Factor: 100 - Clients: 250 - Mode: Read OnlyToshiba MK001920GWUGK80K160K240K320K400KSE +/- 595.48, N = 33717481. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL pgbench 14.0Scaling Factor: 100 - Clients: 250 - Mode: Read Only - Average LatencyToshiba MK001920GWUGK0.15140.30280.45420.60560.757SE +/- 0.001, N = 30.6731. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 14.0Scaling Factor: 100 - Clients: 50 - Mode: Read WriteToshiba MK001920GWUGK6001200180024003000SE +/- 118.03, N = 1030101. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL pgbench 14.0Scaling Factor: 100 - Clients: 50 - Mode: Read Write - Average LatencyToshiba MK001920GWUGK48121620SE +/- 0.65, N = 1016.841. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 14.0Scaling Factor: 100 - Clients: 500 - Mode: Read OnlyToshiba MK001920GWUGK80K160K240K320K400KSE +/- 349.08, N = 33782851. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL pgbench 14.0Scaling Factor: 100 - Clients: 500 - Mode: Read Only - Average LatencyToshiba MK001920GWUGK0.29750.5950.89251.191.4875SE +/- 0.001, N = 31.3221. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 14.0Scaling Factor: 1000 - Clients: 1 - Mode: Read WriteToshiba MK001920GWUGK100200300400500SE +/- 5.43, N = 44691. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL pgbench 14.0Scaling Factor: 1000 - Clients: 1 - Mode: Read Write - Average LatencyToshiba MK001920GWUGK0.48040.96081.44121.92162.402SE +/- 0.025, N = 42.1351. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 14.0Scaling Factor: 1000 - Clients: 50 - Mode: Read OnlyToshiba MK001920GWUGK50K100K150K200K250KSE +/- 7458.62, N = 92168601. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL pgbench 14.0Scaling Factor: 1000 - Clients: 50 - Mode: Read Only - Average LatencyToshiba MK001920GWUGK0.05240.10480.15720.20960.262SE +/- 0.009, N = 90.2331. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

Scaling Factor: 10000 - Clients: 1 - Mode: Read Only

Toshiba MK001920GWUGK: 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: connection to server on socket "/tmp/.s.PGSQL.7777" failed: No such file or directory

Scaling Factor: 25000 - Clients: 1 - Mode: Read Only

Toshiba MK001920GWUGK: 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: connection to server on socket "/tmp/.s.PGSQL.7777" failed: No such file or directory

Scaling Factor: 100 - Clients: 100 - Mode: Read Write

Toshiba MK001920GWUGK: 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: connection to server on socket "/tmp/.s.PGSQL.7777" failed: No such file or directory

Scaling Factor: 100 - Clients: 250 - Mode: Read Write

Toshiba MK001920GWUGK: 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: connection to server on socket "/tmp/.s.PGSQL.7777" failed: No such file or directory

Scaling Factor: 100 - Clients: 500 - Mode: Read Write

Toshiba MK001920GWUGK: 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: connection to server on socket "/tmp/.s.PGSQL.7777" failed: No such file or directory

Scaling Factor: 1000 - Clients: 100 - Mode: Read Only

Toshiba MK001920GWUGK: 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: connection to server on socket "/tmp/.s.PGSQL.7777" failed: No such file or directory

Scaling Factor: 1000 - Clients: 250 - Mode: Read Only

Toshiba MK001920GWUGK: 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: connection to server on socket "/tmp/.s.PGSQL.7777" failed: No such file or directory

Scaling Factor: 1000 - Clients: 50 - Mode: Read Write

Toshiba MK001920GWUGK: 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: connection to server on socket "/tmp/.s.PGSQL.7777" failed: No such file or directory

Scaling Factor: 1000 - Clients: 500 - Mode: Read Only

Toshiba MK001920GWUGK: 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: connection to server on socket "/tmp/.s.PGSQL.7777" failed: No such file or directory

Scaling Factor: 10000 - Clients: 1 - Mode: Read Write

Toshiba MK001920GWUGK: 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: connection to server on socket "/tmp/.s.PGSQL.7777" failed: No such file or directory

Scaling Factor: 10000 - Clients: 50 - Mode: Read Only

Toshiba MK001920GWUGK: 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: connection to server on socket "/tmp/.s.PGSQL.7777" failed: No such file or directory

Scaling Factor: 25000 - Clients: 1 - Mode: Read Write

Toshiba MK001920GWUGK: 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: connection to server on socket "/tmp/.s.PGSQL.7777" failed: No such file or directory

Scaling Factor: 25000 - Clients: 50 - Mode: Read Only

Toshiba MK001920GWUGK: 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: connection to server on socket "/tmp/.s.PGSQL.7777" failed: No such file or directory

Scaling Factor: 1000 - Clients: 100 - Mode: Read Write

Toshiba MK001920GWUGK: 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: connection to server on socket "/tmp/.s.PGSQL.7777" failed: No such file or directory

Scaling Factor: 1000 - Clients: 250 - Mode: Read Write

Toshiba MK001920GWUGK: 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: connection to server on socket "/tmp/.s.PGSQL.7777" failed: FATAL: the database system is starting up

Scaling Factor: 1000 - Clients: 500 - Mode: Read Write

Toshiba MK001920GWUGK: 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: connection to server on socket "/tmp/.s.PGSQL.7777" failed: No such file or directory

Scaling Factor: 10000 - Clients: 100 - Mode: Read Only

Toshiba MK001920GWUGK: 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: connection to server on socket "/tmp/.s.PGSQL.7777" failed: No such file or directory

Scaling Factor: 10000 - Clients: 250 - Mode: Read Only

Toshiba MK001920GWUGK: 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: connection to server on socket "/tmp/.s.PGSQL.7777" failed: No such file or directory

Scaling Factor: 10000 - Clients: 50 - Mode: Read Write

Toshiba MK001920GWUGK: 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: connection to server on socket "/tmp/.s.PGSQL.7777" failed: No such file or directory

Scaling Factor: 10000 - Clients: 500 - Mode: Read Only

Toshiba MK001920GWUGK: 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: connection to server on socket "/tmp/.s.PGSQL.7777" failed: No such file or directory

Scaling Factor: 25000 - Clients: 100 - Mode: Read Only

Toshiba MK001920GWUGK: 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: connection to server on socket "/tmp/.s.PGSQL.7777" failed: No such file or directory

Scaling Factor: 25000 - Clients: 250 - Mode: Read Only

Toshiba MK001920GWUGK: 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: connection to server on socket "/tmp/.s.PGSQL.7777" failed: No such file or directory

Scaling Factor: 25000 - Clients: 50 - Mode: Read Write

Toshiba MK001920GWUGK: 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: connection to server on socket "/tmp/.s.PGSQL.7777" failed: No such file or directory

Scaling Factor: 25000 - Clients: 500 - Mode: Read Only

Toshiba MK001920GWUGK: 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: connection to server on socket "/tmp/.s.PGSQL.7777" failed: No such file or directory

Scaling Factor: 10000 - Clients: 100 - Mode: Read Write

Toshiba MK001920GWUGK: 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: connection to server on socket "/tmp/.s.PGSQL.7777" failed: No such file or directory

Scaling Factor: 10000 - Clients: 250 - Mode: Read Write

Toshiba MK001920GWUGK: 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: connection to server on socket "/tmp/.s.PGSQL.7777" failed: No such file or directory

Scaling Factor: 10000 - Clients: 500 - Mode: Read Write

Toshiba MK001920GWUGK: 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: connection to server on socket "/tmp/.s.PGSQL.7777" failed: No such file or directory

Scaling Factor: 25000 - Clients: 100 - Mode: Read Write

Toshiba MK001920GWUGK: 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: connection to server on socket "/tmp/.s.PGSQL.7777" failed: No such file or directory

Scaling Factor: 25000 - Clients: 250 - Mode: Read Write

Toshiba MK001920GWUGK: 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: connection to server on socket "/tmp/.s.PGSQL.7777" failed: No such file or directory

Scaling Factor: 25000 - Clients: 500 - Mode: Read Write

Toshiba MK001920GWUGK: 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: connection to server on socket "/tmp/.s.PGSQL.7777" failed: No such file or directory

SQLite Speedtest

This is a benchmark of SQLite's speedtest1 benchmark program with an increased problem size of 1,000. Learn more via the OpenBenchmarking.org test page.

OpenBenchmarking.orgSeconds, Fewer Is BetterSQLite Speedtest 3.30Timed Time - Size 1,000Toshiba MK001920GWUGK4080120160200SE +/- 0.82, N = 3185.801. (CC) gcc options: -O2 -ldl -lz -lpthread

60 Results Shown

SQLite
ClickHouse:
  100M Rows Web Analytics Dataset, First Run / Cold Cache
  100M Rows Web Analytics Dataset, Second Run
  100M Rows Web Analytics Dataset, Third Run
Redis:
  GET - 50
  SET - 50
  GET - 500
  LPOP - 50
  SADD - 50
  SET - 500
  GET - 1000
  LPOP - 500
  LPUSH - 50
  SADD - 500
  SET - 1000
  LPOP - 1000
  LPUSH - 500
  SADD - 1000
  LPUSH - 1000
PostgreSQL pgbench:
  1 - 1 - Read Only
  1 - 1 - Read Only - Average Latency
  1 - 1 - Read Write
  1 - 1 - Read Write - Average Latency
  1 - 50 - Read Only
  1 - 50 - Read Only - Average Latency
  1 - 100 - Read Only
  1 - 100 - Read Only - Average Latency
  1 - 250 - Read Only
  1 - 250 - Read Only - Average Latency
  1 - 50 - Read Write
  1 - 50 - Read Write - Average Latency
  1 - 500 - Read Only
  1 - 500 - Read Only - Average Latency
  100 - 1 - Read Only
  100 - 1 - Read Only - Average Latency
  1 - 100 - Read Write
  1 - 100 - Read Write - Average Latency
  1 - 250 - Read Write
  1 - 250 - Read Write - Average Latency
  1 - 500 - Read Write
  1 - 500 - Read Write - Average Latency
  100 - 1 - Read Write
  100 - 1 - Read Write - Average Latency
  100 - 50 - Read Only
  100 - 50 - Read Only - Average Latency
  1000 - 1 - Read Only
  1000 - 1 - Read Only - Average Latency
  100 - 100 - Read Only
  100 - 100 - Read Only - Average Latency
  100 - 250 - Read Only
  100 - 250 - Read Only - Average Latency
  100 - 50 - Read Write
  100 - 50 - Read Write - Average Latency
  100 - 500 - Read Only
  100 - 500 - Read Only - Average Latency
  1000 - 1 - Read Write
  1000 - 1 - Read Write - Average Latency
  1000 - 50 - Read Only
  1000 - 50 - Read Only - Average Latency
SQLite Speedtest