database-macbook-air-catalina

Intel Core i5-4250U testing with a Apple MacBook Air and Intel HD 5000 2GB on macOS 10.15.7 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 2210316-PROG-DATABAS12
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
View Logs
Performance Per
Dollar
Date
Run
  Test
  Duration
database-macbook-air-catalina
October 30 2022
  1 Day, 19 Hours, 29 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):


database-macbook-air-catalinaOpenBenchmarking.orgPhoronix Test SuiteIntel Core i5-4250U @ 1.30GHz (2 Cores / 4 Threads)Apple MacBook AirApple SSD2 x GB DDR3-1600MHz121 33GB APPLE SSD TS0128FIntel HD 5000 2GBColor LCDmacOS 10.15.719.6.0 (x86_64)OpenCL 1.2 (Apr 19 2022 00:27:55)Clang 12.0.0 + GCC 12.0.0APFS1366x768ProcessorMotherboardChipsetMemoryDiskGraphicsMonitorOSKernelOpenCLCompilerFile-SystemScreen ResolutionDatabase-macbook-air-catalina BenchmarksSystem Logs- XPC_FLAGS=0x0- CPU Microcode: 38

database-macbook-air-catalinasqlite-speedtest: Timed Time - Size 1,000pgbench: 1000 - 100 - Read Only - Average Latencypgbench: 1000 - 100 - Read Onlypgbench: 100 - 100 - Read Write - Average Latencypgbench: 100 - 100 - Read Writepgbench: 1000 - 50 - Read Only - Average Latencypgbench: 1000 - 50 - Read Onlypgbench: 1000 - 1 - Read Write - Average Latencypgbench: 1000 - 1 - Read Writepgbench: 100 - 50 - Read Write - Average Latencypgbench: 100 - 50 - Read Writepgbench: 1000 - 1 - Read Only - Average Latencypgbench: 1000 - 1 - Read Onlypgbench: 100 - 50 - Read Only - Average Latencypgbench: 100 - 50 - Read Onlypgbench: 100 - 1 - Read Write - Average Latencypgbench: 100 - 1 - Read Writepgbench: 1 - 100 - Read Write - Average Latencypgbench: 1 - 100 - Read Writepgbench: 1 - 50 - Read Write - Average Latencypgbench: 1 - 50 - Read Writepgbench: 1 - 100 - Read Only - Average Latencypgbench: 1 - 100 - Read Onlypgbench: 1 - 50 - Read Only - Average Latencypgbench: 1 - 50 - Read Onlypgbench: 1 - 1 - Read Write - Average Latencypgbench: 1 - 1 - Read Writepgbench: 1 - 1 - Read Only - Average Latencypgbench: 1 - 1 - Read Onlysqlite: 1leveldb: Seq Fillleveldb: Seq Fillleveldb: Rand Deleteleveldb: Seek Randleveldb: Rand Readleveldb: Rand Fillleveldb: Rand Fillleveldb: Overwriteleveldb: Overwriteleveldb: Fill Syncleveldb: Hot Readpgbench: 1000 - 100 - Read Write - Average Latencypgbench: 1000 - 100 - Read Writepgbench: 1000 - 50 - Read Write - Average Latencypgbench: 1000 - 50 - Read Writepgbench: 100 - 100 - Read Only - Average Latencypgbench: 100 - 100 - Read Onlypgbench: 100 - 1 - Read Only - Average Latencypgbench: 100 - 1 - Read Onlymysqlslap: 1database-macbook-air-catalina145.48711.493870138.09726255.05998842.83435317.56328471.1838462.966168591.49866878.156128029.80016784.032248021.904262650.65515260.0801243410.19065.1316.861.37020.4513.92268.8506.467.4116.675169.2853.90251.435195125.67419597.017143460.1447040OpenBenchmarking.org

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,000database-macbook-air-catalina306090120150SE +/- 0.21, N = 3145.491. (CC) gcc options: -O2 -lz

PostgreSQL

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

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 15Scaling Factor: 1000 - Clients: 100 - Mode: Read Only - Average Latencydatabase-macbook-air-catalina3691215SE +/- 0.02, N = 311.491. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -isysroot -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 15Scaling Factor: 1000 - Clients: 100 - Mode: Read Onlydatabase-macbook-air-catalina2K4K6K8K10KSE +/- 17.82, N = 387011. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -isysroot -lm

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 15Scaling Factor: 100 - Clients: 100 - Mode: Read Write - Average Latencydatabase-macbook-air-catalina918273645SE +/- 0.30, N = 338.101. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -isysroot -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 15Scaling Factor: 100 - Clients: 100 - Mode: Read Writedatabase-macbook-air-catalina6001200180024003000SE +/- 20.31, N = 326251. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -isysroot -lm

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 15Scaling Factor: 1000 - Clients: 50 - Mode: Read Only - Average Latencydatabase-macbook-air-catalina1.13832.27663.41494.55325.6915SE +/- 0.006, N = 35.0591. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -isysroot -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 15Scaling Factor: 1000 - Clients: 50 - Mode: Read Onlydatabase-macbook-air-catalina2K4K6K8K10KSE +/- 12.40, N = 398841. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -isysroot -lm

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 15Scaling Factor: 1000 - Clients: 1 - Mode: Read Write - Average Latencydatabase-macbook-air-catalina0.63771.27541.91312.55083.1885SE +/- 0.038, N = 92.8341. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -isysroot -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 15Scaling Factor: 1000 - Clients: 1 - Mode: Read Writedatabase-macbook-air-catalina80160240320400SE +/- 4.63, N = 93531. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -isysroot -lm

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 15Scaling Factor: 100 - Clients: 50 - Mode: Read Write - Average Latencydatabase-macbook-air-catalina48121620SE +/- 0.13, N = 317.561. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -isysroot -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 15Scaling Factor: 100 - Clients: 50 - Mode: Read Writedatabase-macbook-air-catalina6001200180024003000SE +/- 20.81, N = 328471. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -isysroot -lm

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 15Scaling Factor: 1000 - Clients: 1 - Mode: Read Only - Average Latencydatabase-macbook-air-catalina0.26620.53240.79861.06481.331SE +/- 0.010, N = 31.1831. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -isysroot -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 15Scaling Factor: 1000 - Clients: 1 - Mode: Read Onlydatabase-macbook-air-catalina2004006008001000SE +/- 6.79, N = 38461. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -isysroot -lm

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 15Scaling Factor: 100 - Clients: 50 - Mode: Read Only - Average Latencydatabase-macbook-air-catalina0.66741.33482.00222.66963.337SE +/- 0.025, N = 32.9661. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -isysroot -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 15Scaling Factor: 100 - Clients: 50 - Mode: Read Onlydatabase-macbook-air-catalina4K8K12K16K20KSE +/- 139.90, N = 3168591. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -isysroot -lm

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 15Scaling Factor: 100 - Clients: 1 - Mode: Read Write - Average Latencydatabase-macbook-air-catalina0.33710.67421.01131.34841.6855SE +/- 0.011, N = 101.4981. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -isysroot -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 15Scaling Factor: 100 - Clients: 1 - Mode: Read Writedatabase-macbook-air-catalina140280420560700SE +/- 5.02, N = 106681. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -isysroot -lm

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 15Scaling Factor: 1 - Clients: 100 - Mode: Read Write - Average Latencydatabase-macbook-air-catalina20406080100SE +/- 0.28, N = 378.161. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -isysroot -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 15Scaling Factor: 1 - Clients: 100 - Mode: Read Writedatabase-macbook-air-catalina30060090012001500SE +/- 4.60, N = 312801. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -isysroot -lm

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 15Scaling Factor: 1 - Clients: 50 - Mode: Read Write - Average Latencydatabase-macbook-air-catalina714212835SE +/- 0.05, N = 329.801. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -isysroot -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 15Scaling Factor: 1 - Clients: 50 - Mode: Read Writedatabase-macbook-air-catalina400800120016002000SE +/- 2.61, N = 316781. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -isysroot -lm

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 15Scaling Factor: 1 - Clients: 100 - Mode: Read Only - Average Latencydatabase-macbook-air-catalina0.90721.81442.72163.62884.536SE +/- 0.012, N = 34.0321. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -isysroot -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 15Scaling Factor: 1 - Clients: 100 - Mode: Read Onlydatabase-macbook-air-catalina5K10K15K20K25KSE +/- 77.88, N = 3248021. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -isysroot -lm

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 15Scaling Factor: 1 - Clients: 50 - Mode: Read Only - Average Latencydatabase-macbook-air-catalina0.42840.85681.28521.71362.142SE +/- 0.015, N = 31.9041. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -isysroot -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 15Scaling Factor: 1 - Clients: 50 - Mode: Read Onlydatabase-macbook-air-catalina6K12K18K24K30KSE +/- 206.63, N = 3262651. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -isysroot -lm

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 15Scaling Factor: 1 - Clients: 1 - Mode: Read Write - Average Latencydatabase-macbook-air-catalina0.14740.29480.44220.58960.737SE +/- 0.007, N = 30.6551. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -isysroot -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 15Scaling Factor: 1 - Clients: 1 - Mode: Read Writedatabase-macbook-air-catalina30060090012001500SE +/- 15.96, N = 315261. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -isysroot -lm

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 15Scaling Factor: 1 - Clients: 1 - Mode: Read Only - Average Latencydatabase-macbook-air-catalina0.0180.0360.0540.0720.09SE +/- 0.001, N = 30.0801. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -isysroot -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 15Scaling Factor: 1 - Clients: 1 - Mode: Read Onlydatabase-macbook-air-catalina3K6K9K12K15KSE +/- 99.79, N = 3124341. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -isysroot -lm

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: 1database-macbook-air-catalina3691215SE +/- 0.10, N = 310.191. (CC) gcc options: -O2 -lreadline -ltermcap -lz

LevelDB

LevelDB is a key-value storage library developed by Google that supports making use of Snappy for data compression and has other modern features. Learn more via the OpenBenchmarking.org test page.

OpenBenchmarking.orgMicroseconds Per Op, Fewer Is BetterLevelDB 1.22Benchmark: Sequential Filldatabase-macbook-air-catalina1530456075SE +/- 0.20, N = 365.131. (CXX) g++ options: -O3 -isysroot

OpenBenchmarking.orgMB/s, More Is BetterLevelDB 1.22Benchmark: Sequential Filldatabase-macbook-air-catalina246810SE +/- 0.03, N = 36.81. (CXX) g++ options: -O3 -isysroot

OpenBenchmarking.orgMicroseconds Per Op, Fewer Is BetterLevelDB 1.22Benchmark: Random Deletedatabase-macbook-air-catalina1428425670SE +/- 0.59, N = 1561.371. (CXX) g++ options: -O3 -isysroot

OpenBenchmarking.orgMicroseconds Per Op, Fewer Is BetterLevelDB 1.22Benchmark: Seek Randomdatabase-macbook-air-catalina510152025SE +/- 0.05, N = 320.451. (CXX) g++ options: -O3 -isysroot

OpenBenchmarking.orgMicroseconds Per Op, Fewer Is BetterLevelDB 1.22Benchmark: Random Readdatabase-macbook-air-catalina0.88251.7652.64753.534.4125SE +/- 0.010, N = 33.9221. (CXX) g++ options: -O3 -isysroot

OpenBenchmarking.orgMicroseconds Per Op, Fewer Is BetterLevelDB 1.22Benchmark: Random Filldatabase-macbook-air-catalina1530456075SE +/- 0.70, N = 668.851. (CXX) g++ options: -O3 -isysroot

OpenBenchmarking.orgMB/s, More Is BetterLevelDB 1.22Benchmark: Random Filldatabase-macbook-air-catalina246810SE +/- 0.06, N = 66.41. (CXX) g++ options: -O3 -isysroot

OpenBenchmarking.orgMicroseconds Per Op, Fewer Is BetterLevelDB 1.22Benchmark: Overwritedatabase-macbook-air-catalina1530456075SE +/- 0.85, N = 1567.411. (CXX) g++ options: -O3 -isysroot

OpenBenchmarking.orgMB/s, More Is BetterLevelDB 1.22Benchmark: Overwritedatabase-macbook-air-catalina246810SE +/- 0.08, N = 156.61. (CXX) g++ options: -O3 -isysroot

OpenBenchmarking.orgMicroseconds Per Op, Fewer Is BetterLevelDB 1.22Benchmark: Fill Syncdatabase-macbook-air-catalina16K32K48K64K80KSE +/- 501.89, N = 1575169.291. (CXX) g++ options: -O3 -isysroot

OpenBenchmarking.orgMicroseconds Per Op, Fewer Is BetterLevelDB 1.22Benchmark: Hot Readdatabase-macbook-air-catalina0.8781.7562.6343.5124.39SE +/- 0.016, N = 33.9021. (CXX) g++ options: -O3 -isysroot

PostgreSQL

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

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

database-macbook-air-catalina: 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 503 open files, but system limit is 256

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

database-macbook-air-catalina: 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: could not create connection for client 62

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

database-macbook-air-catalina: 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: Run was aborted; the above results are incomplete.

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

database-macbook-air-catalina: 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 503 open files, but system limit is 256

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

database-macbook-air-catalina: 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: could not create connection for client 62

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

database-macbook-air-catalina: 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: Run was aborted; the above results are incomplete.

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

database-macbook-air-catalina: 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 503 open files, but system limit is 256

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

database-macbook-air-catalina: 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: Run was aborted; the above results are incomplete.

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

database-macbook-air-catalina: 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: could not create connection for client 62

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

database-macbook-air-catalina: 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: Run was aborted; the above results are incomplete.

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

database-macbook-air-catalina: 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 503 open files, but system limit is 256

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

database-macbook-air-catalina: 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: Run was aborted; the above results are incomplete.

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

database-macbook-air-catalina: 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: could not create connection for client 125

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

database-macbook-air-catalina: 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: Run was aborted; the above results are incomplete.

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

database-macbook-air-catalina: 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 503 open files, but system limit is 256

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

database-macbook-air-catalina: 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: could not create connection for client 62

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 15Scaling Factor: 1000 - Clients: 100 - Mode: Read Write - Average Latencydatabase-macbook-air-catalina1224364860SE +/- 1.09, N = 951.441. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -isysroot -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 15Scaling Factor: 1000 - Clients: 100 - Mode: Read Writedatabase-macbook-air-catalina400800120016002000SE +/- 39.16, N = 919511. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -isysroot -lm

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

database-macbook-air-catalina: 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: Run was aborted; the above results are incomplete.

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

database-macbook-air-catalina: 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: Run was aborted; the above results are incomplete.

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

database-macbook-air-catalina: 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: Run was aborted; the above results are incomplete.

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

database-macbook-air-catalina: 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: Run was aborted; the above results are incomplete.

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

database-macbook-air-catalina: 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 503 open files, but system limit is 256

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 15Scaling Factor: 1000 - Clients: 50 - Mode: Read Write - Average Latencydatabase-macbook-air-catalina612182430SE +/- 0.72, N = 925.671. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -isysroot -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 15Scaling Factor: 1000 - Clients: 50 - Mode: Read Writedatabase-macbook-air-catalina400800120016002000SE +/- 50.25, N = 919591. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -isysroot -lm

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

database-macbook-air-catalina: 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: could not create connection for client 125

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

database-macbook-air-catalina: 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 503 open files, but system limit is 256

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

database-macbook-air-catalina: 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: could not create connection for client 125

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

database-macbook-air-catalina: 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: Run was aborted; the above results are incomplete.

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

database-macbook-air-catalina: 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: Run was aborted; the above results are incomplete.

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

database-macbook-air-catalina: 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 503 open files, but system limit is 256

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

database-macbook-air-catalina: 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: could not create connection for client 62

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 15Scaling Factor: 100 - Clients: 100 - Mode: Read Only - Average Latencydatabase-macbook-air-catalina246810SE +/- 0.154, N = 127.0171. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -isysroot -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 15Scaling Factor: 100 - Clients: 100 - Mode: Read Onlydatabase-macbook-air-catalina3K6K9K12K15KSE +/- 397.68, N = 12143461. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -isysroot -lm

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

database-macbook-air-catalina: 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 503 open files, but system limit is 256

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

database-macbook-air-catalina: 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: could not create socket: Too many open files

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 15Scaling Factor: 100 - Clients: 1 - Mode: Read Only - Average Latencydatabase-macbook-air-catalina0.03240.06480.09720.12960.162SE +/- 0.006, N = 120.1441. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -isysroot -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 15Scaling Factor: 100 - Clients: 1 - Mode: Read Onlydatabase-macbook-air-catalina15003000450060007500SE +/- 222.77, N = 1270401. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -isysroot -lm

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

database-macbook-air-catalina: 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 503 open files, but system limit is 256

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

database-macbook-air-catalina: 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: pgbench: error: could not create connection for client 62

MariaDB

This is a MariaDB MySQL database server benchmark making use of mysqlslap. Learn more via the OpenBenchmarking.org test page.

Clients: 4096

database-macbook-air-catalina: 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. E: mysqlslap: line 3: ./bin/mysqlslap: No such file or directory

Clients: 2048

database-macbook-air-catalina: 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. E: mysqlslap: line 3: ./bin/mysqlslap: No such file or directory

Clients: 1024

database-macbook-air-catalina: 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. E: mysqlslap: line 3: ./bin/mysqlslap: No such file or directory

Clients: 512

database-macbook-air-catalina: 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. E: mysqlslap: line 3: ./bin/mysqlslap: No such file or directory

Clients: 256

database-macbook-air-catalina: 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. E: mysqlslap: line 3: ./bin/mysqlslap: No such file or directory

Clients: 128

database-macbook-air-catalina: 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. E: mysqlslap: line 3: ./bin/mysqlslap: No such file or directory

Clients: 64

database-macbook-air-catalina: 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. E: mysqlslap: line 3: ./bin/mysqlslap: No such file or directory

Clients: 32

database-macbook-air-catalina: 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. E: mysqlslap: line 3: ./bin/mysqlslap: No such file or directory

Clients: 16

database-macbook-air-catalina: 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. E: mysqlslap: line 3: ./bin/mysqlslap: No such file or directory

Clients: 8

database-macbook-air-catalina: 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. E: mysqlslap: line 3: ./bin/mysqlslap: No such file or directory

Clients: 1

database-macbook-air-catalina: 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. E: mysqlslap: line 3: ./bin/mysqlslap: No such file or directory

49 Results Shown

SQLite Speedtest
PostgreSQL:
  1000 - 100 - Read Only - Average Latency
  1000 - 100 - Read Only
  100 - 100 - Read Write - Average Latency
  100 - 100 - Read Write
  1000 - 50 - Read Only - Average Latency
  1000 - 50 - Read Only
  1000 - 1 - Read Write - Average Latency
  1000 - 1 - Read Write
  100 - 50 - Read Write - Average Latency
  100 - 50 - Read Write
  1000 - 1 - Read Only - Average Latency
  1000 - 1 - Read Only
  100 - 50 - Read Only - Average Latency
  100 - 50 - Read Only
  100 - 1 - Read Write - Average Latency
  100 - 1 - Read Write
  1 - 100 - Read Write - Average Latency
  1 - 100 - Read Write
  1 - 50 - Read Write - Average Latency
  1 - 50 - Read Write
  1 - 100 - Read Only - Average Latency
  1 - 100 - Read Only
  1 - 50 - Read Only - Average Latency
  1 - 50 - Read Only
  1 - 1 - Read Write - Average Latency
  1 - 1 - Read Write
  1 - 1 - Read Only - Average Latency
  1 - 1 - Read Only
SQLite
LevelDB:
  Seq Fill:
    Microseconds Per Op
    MB/s
  Rand Delete:
    Microseconds Per Op
  Seek Rand:
    Microseconds Per Op
  Rand Read:
    Microseconds Per Op
  Rand Fill:
    Microseconds Per Op
    MB/s
  Overwrite:
    Microseconds Per Op
    MB/s
  Fill Sync:
    Microseconds Per Op
  Hot Read:
    Microseconds Per Op
PostgreSQL:
  1000 - 100 - Read Write - Average Latency
  1000 - 100 - Read Write
  1000 - 50 - Read Write - Average Latency
  1000 - 50 - Read Write
  100 - 100 - Read Only - Average Latency
  100 - 100 - Read Only
  100 - 1 - Read Only - Average Latency
  100 - 1 - Read Only