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. database-macbook-air-catalina: Processor: Intel Core i5-4250U @ 1.30GHz (2 Cores / 4 Threads), Motherboard: Apple MacBook Air, Chipset: Apple SSD, Memory: 2 x GB DDR3-1600MHz, Disk: 121 33GB APPLE SSD TS0128F, Graphics: Intel HD 5000 2GB, Monitor: Color LCD OS: macOS 10.15.7, Kernel: 19.6.0 (x86_64), OpenCL: OpenCL 1.2 (Apr 19 2022 00:27:55), Compiler: Clang 12.0.0 + GCC 12.0.0, File-System: APFS, Screen Resolution: 1366x768 LevelDB 1.22 Benchmark: Hot Read Microseconds Per Op < Lower Is Better database-macbook-air-catalina . 3.902 |======================================== LevelDB 1.22 Benchmark: Fill Sync Microseconds Per Op < Lower Is Better database-macbook-air-catalina . 75169.29 |===================================== LevelDB 1.22 Benchmark: Overwrite MB/s > Higher Is Better database-macbook-air-catalina . 6.6 |========================================== LevelDB 1.22 Benchmark: Overwrite Microseconds Per Op < Lower Is Better database-macbook-air-catalina . 67.41 |======================================== LevelDB 1.22 Benchmark: Random Fill MB/s > Higher Is Better database-macbook-air-catalina . 6.4 |========================================== LevelDB 1.22 Benchmark: Random Fill Microseconds Per Op < Lower Is Better database-macbook-air-catalina . 68.85 |======================================== LevelDB 1.22 Benchmark: Random Read Microseconds Per Op < Lower Is Better database-macbook-air-catalina . 3.922 |======================================== LevelDB 1.22 Benchmark: Seek Random Microseconds Per Op < Lower Is Better database-macbook-air-catalina . 20.45 |======================================== LevelDB 1.22 Benchmark: Random Delete Microseconds Per Op < Lower Is Better database-macbook-air-catalina . 61.37 |======================================== LevelDB 1.22 Benchmark: Sequential Fill MB/s > Higher Is Better database-macbook-air-catalina . 6.8 |========================================== LevelDB 1.22 Benchmark: Sequential Fill Microseconds Per Op < Lower Is Better database-macbook-air-catalina . 65.13 |======================================== SQLite 3.30.1 Threads / Copies: 1 Seconds < Lower Is Better database-macbook-air-catalina . 10.19 |======================================== MariaDB 10.8.2 Clients: 1 Queries Per Second > Higher Is Better MariaDB 10.8.2 Clients: 8 Queries Per Second > Higher Is Better MariaDB 10.8.2 Clients: 16 Queries Per Second > Higher Is Better MariaDB 10.8.2 Clients: 32 Queries Per Second > Higher Is Better MariaDB 10.8.2 Clients: 64 Queries Per Second > Higher Is Better MariaDB 10.8.2 Clients: 128 Queries Per Second > Higher Is Better MariaDB 10.8.2 Clients: 256 Queries Per Second > Higher Is Better MariaDB 10.8.2 Clients: 512 Queries Per Second > Higher Is Better MariaDB 10.8.2 Clients: 1024 Queries Per Second > Higher Is Better MariaDB 10.8.2 Clients: 2048 Queries Per Second > Higher Is Better MariaDB 10.8.2 Clients: 4096 Queries Per Second > Higher Is Better PostgreSQL 15 Scaling Factor: 1 - Clients: 1 - Mode: Read Only TPS > Higher Is Better database-macbook-air-catalina . 12434 |======================================== PostgreSQL 15 Scaling Factor: 1 - Clients: 1 - Mode: Read Only - Average Latency ms < Lower Is Better database-macbook-air-catalina . 0.080 |======================================== PostgreSQL 15 Scaling Factor: 1 - Clients: 1 - Mode: Read Write TPS > Higher Is Better database-macbook-air-catalina . 1526 |========================================= PostgreSQL 15 Scaling Factor: 1 - Clients: 1 - Mode: Read Write - Average Latency ms < Lower Is Better database-macbook-air-catalina . 0.655 |======================================== PostgreSQL 15 Scaling Factor: 1 - Clients: 50 - Mode: Read Only TPS > Higher Is Better database-macbook-air-catalina . 26265 |======================================== PostgreSQL 15 Scaling Factor: 1 - Clients: 50 - Mode: Read Only - Average Latency ms < Lower Is Better database-macbook-air-catalina . 1.904 |======================================== PostgreSQL 15 Scaling Factor: 1 - Clients: 100 - Mode: Read Only TPS > Higher Is Better database-macbook-air-catalina . 24802 |======================================== PostgreSQL 15 Scaling Factor: 1 - Clients: 100 - Mode: Read Only - Average Latency ms < Lower Is Better database-macbook-air-catalina . 4.032 |======================================== PostgreSQL 15 Scaling Factor: 1 - Clients: 250 - Mode: Read Only TPS > Higher Is Better PostgreSQL 15 Scaling Factor: 1 - Clients: 50 - Mode: Read Write TPS > Higher Is Better database-macbook-air-catalina . 1678 |========================================= PostgreSQL 15 Scaling Factor: 1 - Clients: 50 - Mode: Read Write - Average Latency ms < Lower Is Better database-macbook-air-catalina . 29.80 |======================================== PostgreSQL 15 Scaling Factor: 1 - Clients: 500 - Mode: Read Only TPS > Higher Is Better PostgreSQL 15 Scaling Factor: 100 - Clients: 1 - Mode: Read Only TPS > Higher Is Better database-macbook-air-catalina . 7040 |========================================= PostgreSQL 15 Scaling Factor: 100 - Clients: 1 - Mode: Read Only - Average Latency ms < Lower Is Better database-macbook-air-catalina . 0.144 |======================================== PostgreSQL 15 Scaling Factor: 1 - Clients: 100 - Mode: Read Write TPS > Higher Is Better database-macbook-air-catalina . 1280 |========================================= PostgreSQL 15 Scaling Factor: 1 - Clients: 100 - Mode: Read Write - Average Latency ms < Lower Is Better database-macbook-air-catalina . 78.16 |======================================== PostgreSQL 15 Scaling Factor: 1 - Clients: 250 - Mode: Read Write TPS > Higher Is Better PostgreSQL 15 Scaling Factor: 1 - Clients: 500 - Mode: Read Write TPS > Higher Is Better PostgreSQL 15 Scaling Factor: 100 - Clients: 1 - Mode: Read Write TPS > Higher Is Better database-macbook-air-catalina . 668 |========================================== PostgreSQL 15 Scaling Factor: 100 - Clients: 1 - Mode: Read Write - Average Latency ms < Lower Is Better database-macbook-air-catalina . 1.498 |======================================== PostgreSQL 15 Scaling Factor: 100 - Clients: 50 - Mode: Read Only TPS > Higher Is Better database-macbook-air-catalina . 16859 |======================================== PostgreSQL 15 Scaling Factor: 100 - Clients: 50 - Mode: Read Only - Average Latency ms < Lower Is Better database-macbook-air-catalina . 2.966 |======================================== PostgreSQL 15 Scaling Factor: 1000 - Clients: 1 - Mode: Read Only TPS > Higher Is Better database-macbook-air-catalina . 846 |========================================== PostgreSQL 15 Scaling Factor: 1000 - Clients: 1 - Mode: Read Only - Average Latency ms < Lower Is Better database-macbook-air-catalina . 1.183 |======================================== PostgreSQL 15 Scaling Factor: 100 - Clients: 100 - Mode: Read Only TPS > Higher Is Better database-macbook-air-catalina . 14346 |======================================== PostgreSQL 15 Scaling Factor: 100 - Clients: 100 - Mode: Read Only - Average Latency ms < Lower Is Better database-macbook-air-catalina . 7.017 |======================================== PostgreSQL 15 Scaling Factor: 100 - Clients: 250 - Mode: Read Only TPS > Higher Is Better PostgreSQL 15 Scaling Factor: 100 - Clients: 50 - Mode: Read Write TPS > Higher Is Better database-macbook-air-catalina . 2847 |========================================= PostgreSQL 15 Scaling Factor: 100 - Clients: 50 - Mode: Read Write - Average Latency ms < Lower Is Better database-macbook-air-catalina . 17.56 |======================================== PostgreSQL 15 Scaling Factor: 100 - Clients: 500 - Mode: Read Only TPS > Higher Is Better PostgreSQL 15 Scaling Factor: 1000 - Clients: 1 - Mode: Read Write TPS > Higher Is Better database-macbook-air-catalina . 353 |========================================== PostgreSQL 15 Scaling Factor: 1000 - Clients: 1 - Mode: Read Write - Average Latency ms < Lower Is Better database-macbook-air-catalina . 2.834 |======================================== PostgreSQL 15 Scaling Factor: 1000 - Clients: 50 - Mode: Read Only TPS > Higher Is Better database-macbook-air-catalina . 9884 |========================================= PostgreSQL 15 Scaling Factor: 1000 - Clients: 50 - Mode: Read Only - Average Latency ms < Lower Is Better database-macbook-air-catalina . 5.059 |======================================== PostgreSQL 15 Scaling Factor: 10000 - Clients: 1 - Mode: Read Only TPS > Higher Is Better PostgreSQL 15 Scaling Factor: 25000 - Clients: 1 - Mode: Read Only TPS > Higher Is Better PostgreSQL 15 Scaling Factor: 100 - Clients: 100 - Mode: Read Write TPS > Higher Is Better database-macbook-air-catalina . 2625 |========================================= PostgreSQL 15 Scaling Factor: 100 - Clients: 100 - Mode: Read Write - Average Latency ms < Lower Is Better database-macbook-air-catalina . 38.10 |======================================== PostgreSQL 15 Scaling Factor: 100 - Clients: 250 - Mode: Read Write TPS > Higher Is Better PostgreSQL 15 Scaling Factor: 100 - Clients: 500 - Mode: Read Write TPS > Higher Is Better PostgreSQL 15 Scaling Factor: 1000 - Clients: 100 - Mode: Read Only TPS > Higher Is Better database-macbook-air-catalina . 8701 |========================================= PostgreSQL 15 Scaling Factor: 1000 - Clients: 100 - Mode: Read Only - Average Latency ms < Lower Is Better database-macbook-air-catalina . 11.49 |======================================== PostgreSQL 15 Scaling Factor: 1000 - Clients: 250 - Mode: Read Only TPS > Higher Is Better PostgreSQL 15 Scaling Factor: 1000 - Clients: 50 - Mode: Read Write TPS > Higher Is Better database-macbook-air-catalina . 1959 |========================================= PostgreSQL 15 Scaling Factor: 1000 - Clients: 50 - Mode: Read Write - Average Latency ms < Lower Is Better database-macbook-air-catalina . 25.67 |======================================== PostgreSQL 15 Scaling Factor: 1000 - Clients: 500 - Mode: Read Only TPS > Higher Is Better PostgreSQL 15 Scaling Factor: 10000 - Clients: 1 - Mode: Read Write TPS > Higher Is Better PostgreSQL 15 Scaling Factor: 10000 - Clients: 50 - Mode: Read Only TPS > Higher Is Better PostgreSQL 15 Scaling Factor: 25000 - Clients: 1 - Mode: Read Write TPS > Higher Is Better PostgreSQL 15 Scaling Factor: 25000 - Clients: 50 - Mode: Read Only TPS > Higher Is Better PostgreSQL 15 Scaling Factor: 1000 - Clients: 100 - Mode: Read Write TPS > Higher Is Better database-macbook-air-catalina . 1951 |========================================= PostgreSQL 15 Scaling Factor: 1000 - Clients: 100 - Mode: Read Write - Average Latency ms < Lower Is Better database-macbook-air-catalina . 51.44 |======================================== PostgreSQL 15 Scaling Factor: 1000 - Clients: 250 - Mode: Read Write TPS > Higher Is Better PostgreSQL 15 Scaling Factor: 1000 - Clients: 500 - Mode: Read Write TPS > Higher Is Better PostgreSQL 15 Scaling Factor: 10000 - Clients: 100 - Mode: Read Only TPS > Higher Is Better PostgreSQL 15 Scaling Factor: 10000 - Clients: 250 - Mode: Read Only TPS > Higher Is Better PostgreSQL 15 Scaling Factor: 10000 - Clients: 50 - Mode: Read Write TPS > Higher Is Better PostgreSQL 15 Scaling Factor: 10000 - Clients: 500 - Mode: Read Only TPS > Higher Is Better PostgreSQL 15 Scaling Factor: 25000 - Clients: 100 - Mode: Read Only TPS > Higher Is Better PostgreSQL 15 Scaling Factor: 25000 - Clients: 250 - Mode: Read Only TPS > Higher Is Better PostgreSQL 15 Scaling Factor: 25000 - Clients: 50 - Mode: Read Write TPS > Higher Is Better PostgreSQL 15 Scaling Factor: 25000 - Clients: 500 - Mode: Read Only TPS > Higher Is Better PostgreSQL 15 Scaling Factor: 10000 - Clients: 100 - Mode: Read Write TPS > Higher Is Better PostgreSQL 15 Scaling Factor: 10000 - Clients: 250 - Mode: Read Write TPS > Higher Is Better PostgreSQL 15 Scaling Factor: 10000 - Clients: 500 - Mode: Read Write TPS > Higher Is Better PostgreSQL 15 Scaling Factor: 25000 - Clients: 100 - Mode: Read Write TPS > Higher Is Better PostgreSQL 15 Scaling Factor: 25000 - Clients: 250 - Mode: Read Write TPS > Higher Is Better PostgreSQL 15 Scaling Factor: 25000 - Clients: 500 - Mode: Read Write TPS > Higher Is Better SQLite Speedtest 3.30 Timed Time - Size 1,000 Seconds < Lower Is Better database-macbook-air-catalina . 145.49 |=======================================