pts-database

Apple M2 Pro testing with a Apple Mac mini and Apple M2 Pro on macOS 13.5 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 2312090-NE-PTSDATABA57
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
pts-database
December 09 2023
  1 Hour
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):


pts-databaseOpenBenchmarking.orgPhoronix Test SuiteApple M2 Pro (10 Cores)Apple Mac mini16GB461GBApple M2 ProApple M2 PromacOS 13.522.6.0 (arm64)GCC 14.0.3 + Clang 17.0.6 + LLVM 17.0.6 + Xcode 14.3.1APFSxProcessorMotherboardMemoryDiskGraphicsMonitorOSKernelCompilerFile-SystemScreen ResolutionPts-database BenchmarksSystem Logs- LDFLAGS=-L/opt/homebrew/opt/llvm/lib CPPFLAGS=-I/opt/homebrew/opt/llvm/include

pts-databaseduckdb: IMDBduckdb: TPC-H Parquetsqlite-speedtest: Timed Time - Size 1,000pts-database127.55993.56853.013OpenBenchmarking.org

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.

Benchmark: Hot Read

pts-database: The test run did not produce a result. E: leveldb: line 3: ./db_bench: No such file or directory

Benchmark: Fill Sync

pts-database: The test run did not produce a result. E: leveldb: line 3: ./db_bench: No such file or directory

Benchmark: Overwrite

pts-database: The test run did not produce a result. E: leveldb: line 3: ./db_bench: No such file or directory

Benchmark: Random Fill

pts-database: The test run did not produce a result. E: leveldb: line 3: ./db_bench: No such file or directory

Benchmark: Random Read

pts-database: The test run did not produce a result. E: leveldb: line 3: ./db_bench: No such file or directory

Benchmark: Seek Random

pts-database: The test run did not produce a result. E: leveldb: line 3: ./db_bench: No such file or directory

Benchmark: Random Delete

pts-database: The test run did not produce a result. E: leveldb: line 3: ./db_bench: No such file or directory

Benchmark: Sequential Fill

pts-database: The test run did not produce a result. E: leveldb: line 3: ./db_bench: No such file or directory

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.

Threads / Copies: 1

pts-database: The test run did not produce a result.

MariaDB

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

Clients: 1

pts-database: The test quit with a non-zero exit status. E: mysqlslap: line 3: ./bin/mysqlslap: No such file or directory

Clients: 64

pts-database: The test quit with a non-zero exit status. E: mysqlslap: line 3: ./bin/mysqlslap: No such file or directory

Clients: 128

pts-database: The test quit with a non-zero exit status. E: mysqlslap: line 3: ./bin/mysqlslap: No such file or directory

Clients: 256

pts-database: The test quit with a non-zero exit status. E: mysqlslap: line 3: ./bin/mysqlslap: No such file or directory

Clients: 512

pts-database: The test quit with a non-zero exit status. E: mysqlslap: line 3: ./bin/mysqlslap: No such file or directory

Clients: 1024

pts-database: The test quit with a non-zero exit status. E: mysqlslap: line 3: ./bin/mysqlslap: No such file or directory

Clients: 2048

pts-database: The test quit with a non-zero exit status. E: mysqlslap: line 3: ./bin/mysqlslap: No such file or directory

Clients: 4096

pts-database: The test quit with a non-zero exit status. E: mysqlslap: line 3: ./bin/mysqlslap: No such file or directory

Clients: 8192

pts-database: The test quit with a non-zero exit status. E: mysqlslap: line 3: ./bin/mysqlslap: No such file or directory

DuckDB

DuckDB is an in-progress SQL OLAP database management system optimized for analytics and features a vectorized and parallel engine. Learn more via the OpenBenchmarking.org test page.

OpenBenchmarking.orgSeconds, Fewer Is BetterDuckDB 0.9.1Benchmark: IMDBpts-database306090120150SE +/- 0.63, N = 3127.561. (CXX) g++ options: -O3 -arch -isysroot

OpenBenchmarking.orgSeconds, Fewer Is BetterDuckDB 0.9.1Benchmark: TPC-H Parquetpts-database20406080100SE +/- 0.09, N = 393.571. (CXX) g++ options: -O3 -arch -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: 1 - Clients: 1 - Mode: Read Only

pts-database: The test run did not produce a result. E: pgbench: line 21: pg_/bin/pgbench: No such file or directory

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

pts-database: The test run did not produce a result. E: pgbench: line 21: pg_/bin/pgbench: No such file or directory

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

pts-database: The test run did not produce a result. E: pgbench: line 21: pg_/bin/pgbench: No such file or directory

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

pts-database: The test run did not produce a result. E: pgbench: line 21: pg_/bin/pgbench: No such file or directory

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

pts-database: The test run did not produce a result. E: pgbench: line 21: pg_/bin/pgbench: No such file or directory

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

pts-database: The test run did not produce a result. E: pgbench: line 21: pg_/bin/pgbench: No such file or directory

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

pts-database: The test run did not produce a result. E: pgbench: line 21: pg_/bin/pgbench: No such file or directory

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

pts-database: The test run did not produce a result. E: pgbench: line 21: pg_/bin/pgbench: No such file or directory

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

pts-database: The test run did not produce a result. E: pgbench: line 21: pg_/bin/pgbench: No such file or directory

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

pts-database: The test run did not produce a result. E: pgbench: line 21: pg_/bin/pgbench: No such file or directory

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

pts-database: The test run did not produce a result. E: pgbench: line 21: pg_/bin/pgbench: No such file or directory

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

pts-database: The test run did not produce a result. E: pgbench: line 21: pg_/bin/pgbench: No such file or directory

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

pts-database: The test run did not produce a result. E: pgbench: line 21: pg_/bin/pgbench: No such file or directory

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

pts-database: The test run did not produce a result. E: pgbench: line 21: pg_/bin/pgbench: No such file or directory

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

pts-database: The test run did not produce a result. E: pgbench: line 21: pg_/bin/pgbench: No such file or directory

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

pts-database: The test run did not produce a result. E: pgbench: line 21: pg_/bin/pgbench: No such file or directory

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

pts-database: The test run did not produce a result. E: pgbench: line 21: pg_/bin/pgbench: No such file or directory

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

pts-database: The test run did not produce a result. E: pgbench: line 21: pg_/bin/pgbench: No such file or directory

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

pts-database: The test run did not produce a result. E: pgbench: line 21: pg_/bin/pgbench: No such file or directory

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

pts-database: The test run did not produce a result. E: pgbench: line 21: pg_/bin/pgbench: No such file or directory

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

pts-database: The test run did not produce a result. E: pgbench: line 21: pg_/bin/pgbench: No such file or directory

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

pts-database: The test run did not produce a result. E: pgbench: line 21: pg_/bin/pgbench: No such file or directory

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

pts-database: The test run did not produce a result. E: pgbench: line 21: pg_/bin/pgbench: No such file or directory

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

pts-database: The test run did not produce a result. E: pgbench: line 21: pg_/bin/pgbench: No such file or directory

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

pts-database: The test run did not produce a result. E: pgbench: line 21: pg_/bin/pgbench: No such file or directory

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

pts-database: The test run did not produce a result. E: pgbench: line 21: pg_/bin/pgbench: No such file or directory

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

pts-database: The test run did not produce a result. E: pgbench: line 21: pg_/bin/pgbench: No such file or directory

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

pts-database: The test run did not produce a result. E: pgbench: line 21: pg_/bin/pgbench: No such file or directory

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

pts-database: The test run did not produce a result. E: pgbench: line 21: pg_/bin/pgbench: No such file or directory

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

pts-database: The test run did not produce a result. E: pgbench: line 21: pg_/bin/pgbench: No such file or directory

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

pts-database: The test run did not produce a result. E: pgbench: line 21: pg_/bin/pgbench: No such file or directory

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

pts-database: The test run did not produce a result. E: pgbench: line 21: pg_/bin/pgbench: No such file or directory

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

pts-database: The test run did not produce a result. E: pgbench: line 21: pg_/bin/pgbench: No such file or directory

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

pts-database: The test run did not produce a result. E: pgbench: line 21: pg_/bin/pgbench: No such file or directory

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

pts-database: The test run did not produce a result. E: pgbench: line 21: pg_/bin/pgbench: No such file or directory

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

pts-database: The test run did not produce a result. E: pgbench: line 21: pg_/bin/pgbench: No such file or directory

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

pts-database: The test run did not produce a result. E: pgbench: line 21: pg_/bin/pgbench: No such file or directory

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

pts-database: The test run did not produce a result. E: pgbench: line 21: pg_/bin/pgbench: No such file or directory

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

pts-database: The test run did not produce a result. E: pgbench: line 21: pg_/bin/pgbench: No such file or directory

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

pts-database: The test run did not produce a result. E: pgbench: line 21: pg_/bin/pgbench: No such file or directory

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

pts-database: The test run did not produce a result. E: pgbench: line 21: pg_/bin/pgbench: No such file or directory

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

pts-database: The test run did not produce a result. E: pgbench: line 21: pg_/bin/pgbench: No such file or directory

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

pts-database: The test run did not produce a result. E: pgbench: line 21: pg_/bin/pgbench: No such file or directory

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

pts-database: The test run did not produce a result. E: pgbench: line 21: pg_/bin/pgbench: No such file or directory

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

pts-database: The test run did not produce a result. E: pgbench: line 21: pg_/bin/pgbench: No such file or directory

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

pts-database: The test run did not produce a result. E: pgbench: line 21: pg_/bin/pgbench: No such file or directory

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

pts-database: The test run did not produce a result. E: pgbench: line 21: pg_/bin/pgbench: No such file or directory

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

pts-database: The test run did not produce a result. E: pgbench: line 21: pg_/bin/pgbench: No such file or directory

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

pts-database: The test run did not produce a result. E: pgbench: line 21: pg_/bin/pgbench: No such file or directory

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

pts-database: The test run did not produce a result. E: pgbench: line 21: pg_/bin/pgbench: No such file or directory

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

pts-database: The test run did not produce a result. E: pgbench: line 21: pg_/bin/pgbench: No such file or directory

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

pts-database: The test run did not produce a result. E: pgbench: line 21: pg_/bin/pgbench: No such file or directory

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

pts-database: The test run did not produce a result. E: pgbench: line 21: pg_/bin/pgbench: No such file or directory

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

pts-database: The test run did not produce a result. E: pgbench: line 21: pg_/bin/pgbench: No such file or directory

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

pts-database: The test run did not produce a result. E: pgbench: line 21: pg_/bin/pgbench: No such file or directory

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

pts-database: The test run did not produce a result. E: pgbench: line 21: pg_/bin/pgbench: No such file or directory

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

pts-database: The test run did not produce a result. E: pgbench: line 21: pg_/bin/pgbench: No such file or directory

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

pts-database: The test run did not produce a result. E: pgbench: line 21: pg_/bin/pgbench: No such file or directory

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

pts-database: The test run did not produce a result. E: pgbench: line 21: pg_/bin/pgbench: No such file or directory

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

pts-database: The test run did not produce a result. E: pgbench: line 21: pg_/bin/pgbench: No such file or directory

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

pts-database: The test run did not produce a result. E: pgbench: line 21: pg_/bin/pgbench: No such file or directory

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

pts-database: The test run did not produce a result. E: pgbench: line 21: pg_/bin/pgbench: No such file or directory

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

pts-database: The test run did not produce a result. E: pgbench: line 21: pg_/bin/pgbench: No such file or directory

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

pts-database: The test run did not produce a result. E: pgbench: line 21: pg_/bin/pgbench: No such file or directory

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

pts-database: The test run did not produce a result. E: pgbench: line 21: pg_/bin/pgbench: No such file or directory

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

pts-database: The test run did not produce a result. E: pgbench: line 21: pg_/bin/pgbench: No such file or directory

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

pts-database: The test run did not produce a result. E: pgbench: line 21: pg_/bin/pgbench: No such file or directory

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

pts-database: The test run did not produce a result. E: pgbench: line 21: pg_/bin/pgbench: No such file or directory

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

pts-database: The test run did not produce a result. E: pgbench: line 21: pg_/bin/pgbench: No such file or directory

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

pts-database: The test run did not produce a result. E: pgbench: line 21: pg_/bin/pgbench: No such file or directory

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

pts-database: The test run did not produce a result. E: pgbench: line 21: pg_/bin/pgbench: No such file or directory

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

pts-database: The test run did not produce a result. E: pgbench: line 21: pg_/bin/pgbench: No such file or directory

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

pts-database: The test run did not produce a result. E: pgbench: line 21: pg_/bin/pgbench: No such file or directory

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

pts-database: The test run did not produce a result. E: pgbench: line 21: pg_/bin/pgbench: No such file or directory

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

pts-database: The test run did not produce a result. E: pgbench: line 21: pg_/bin/pgbench: No such file or directory

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

pts-database: The test run did not produce a result. E: pgbench: line 21: pg_/bin/pgbench: No such file or directory

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

pts-database: The test run did not produce a result. E: pgbench: line 21: pg_/bin/pgbench: No such file or directory

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

pts-database: The test run did not produce a result. E: pgbench: line 21: pg_/bin/pgbench: No such file or directory

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

pts-database: The test run did not produce a result. E: pgbench: line 21: pg_/bin/pgbench: No such file or directory

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

pts-database: The test run did not produce a result. E: pgbench: line 21: pg_/bin/pgbench: 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,000pts-database1224364860SE +/- 0.21, N = 353.011. (CC) gcc options: -O2 -lz