DB Testing With Clang

Intel Core i5-4250U testing with a Apple Mac-35C1E88140C3E6CF and Intel Haswell-ULT IGP on Ubuntu 15.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 1506093-BE-DBTESTING23
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
Clanged
June 09 2015
 
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):

Clanged

Processor: Intel Core i5-4250U @ 2.60GHz (4 Cores), Motherboard: Apple Mac-35C1E88140C3E6CF, Chipset: Intel Haswell-ULT DRAM, Memory: 2 x 2048 MB DDR3-1600MHz, Disk: 121GB APPLE SSD SD0128, Graphics: Intel Haswell-ULT IGP (1000MHz), Audio: Intel Haswell-ULT HD Audio, Monitor: Color LCD, Network: Broadcom BCM4360 802.11ac Wireless

OS: Ubuntu 15.04, Kernel: 3.19.0-18-generic (x86_64), Desktop: Unity 7.3.2, Display Driver: intel 2.99.917, Compiler: GCC 4.2.1 + Clang 3.7.0-svn239385-1~exp1, File-System: ext4, Screen Resolution: 1366x768

Disk Notes: DEADLINE / data=ordered,errors=remount-ro,relatime,rw
Processor Notes: Scaling Governor: intel_pstate powersave
System Notes: Disk Scheduler: DEADLINE.

DB Testing With ClangOpenBenchmarking.orgPhoronix Test SuiteIntel Core i5-4250U @ 2.60GHz (4 Cores)Apple Mac-35C1E88140C3E6CFIntel Haswell-ULT DRAM2 x 2048 MB DDR3-1600MHz121GB APPLE SSD SD0128Intel Haswell-ULT IGP (1000MHz)Intel Haswell-ULT HD AudioColor LCDBroadcom BCM4360 802.11ac WirelessUbuntu 15.043.19.0-18-generic (x86_64)Unity 7.3.2intel 2.99.917GCC 4.2.1 + Clang 3.7.0-svn239385-1~exp1ext41366x768ProcessorMotherboardChipsetMemoryDiskGraphicsAudioMonitorNetworkOSKernelDesktopDisplay DriverCompilerFile-SystemScreen ResolutionDB Testing With Clang BenchmarksSystem Logs- DEADLINE / data=ordered,errors=remount-ro,relatime,rw- Scaling Governor: intel_pstate powersave- Disk Scheduler: DEADLINE.

DB Testing With Clangsqlite: Default Test Directorypgbench: Mostly RAM - Normal Load - Read Onlypgbench: Mostly RAM - Normal Load - Read Writepgbench: Mostly RAM - Single Thread - Read Onlypgbench: Mostly RAM - Single Thread - Read Writepgbench: Mostly RAM - Heavy Contention - Read Onlypgbench: Mostly RAM - Heavy Contention - Read WriteClanged23.5723956.361903.0311852.78504.1120809.882250.97OpenBenchmarking.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.8.10.2Test Target: Default Test DirectoryClanged612182430SE +/- 0.27, N = 323.571. (CC) gcc options: -O2 -ldl -lpthread

PostgreSQL pgbench

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 9.4.3Scaling: Mostly RAM - Test: Normal Load - Mode: Read OnlyClanged5K10K15K20K25KSE +/- 51.41, N = 323956.361. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -pthread -pthreads -lpgcommon -lpgport -lpq -lpthread -lrt -lcrypt -ldl -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 9.4.3Scaling: Mostly RAM - Test: Normal Load - Mode: Read WriteClanged400800120016002000SE +/- 35.37, N = 31903.031. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -pthread -pthreads -lpgcommon -lpgport -lpq -lpthread -lrt -lcrypt -ldl -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 9.4.3Scaling: Mostly RAM - Test: Single Thread - Mode: Read OnlyClanged3K6K9K12K15KSE +/- 52.24, N = 311852.781. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -pthread -pthreads -lpgcommon -lpgport -lpq -lpthread -lrt -lcrypt -ldl -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 9.4.3Scaling: Mostly RAM - Test: Single Thread - Mode: Read WriteClanged110220330440550SE +/- 6.40, N = 3504.111. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -pthread -pthreads -lpgcommon -lpgport -lpq -lpthread -lrt -lcrypt -ldl -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 9.4.3Scaling: Mostly RAM - Test: Heavy Contention - Mode: Read OnlyClanged4K8K12K16K20KSE +/- 75.91, N = 320809.881. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -pthread -pthreads -lpgcommon -lpgport -lpq -lpthread -lrt -lcrypt -ldl -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 9.4.3Scaling: Mostly RAM - Test: Heavy Contention - Mode: Read WriteClanged5001000150020002500SE +/- 20.23, N = 32250.971. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -pthread -pthreads -lpgcommon -lpgport -lpq -lpthread -lrt -lcrypt -ldl -lm

Clanged

Processor: Intel Core i5-4250U @ 2.60GHz (4 Cores), Motherboard: Apple Mac-35C1E88140C3E6CF, Chipset: Intel Haswell-ULT DRAM, Memory: 2 x 2048 MB DDR3-1600MHz, Disk: 121GB APPLE SSD SD0128, Graphics: Intel Haswell-ULT IGP (1000MHz), Audio: Intel Haswell-ULT HD Audio, Monitor: Color LCD, Network: Broadcom BCM4360 802.11ac Wireless

OS: Ubuntu 15.04, Kernel: 3.19.0-18-generic (x86_64), Desktop: Unity 7.3.2, Display Driver: intel 2.99.917, Compiler: GCC 4.2.1 + Clang 3.7.0-svn239385-1~exp1, File-System: ext4, Screen Resolution: 1366x768

Disk Notes: DEADLINE / data=ordered,errors=remount-ro,relatime,rw
Processor Notes: Scaling Governor: intel_pstate powersave
System Notes: Disk Scheduler: DEADLINE.

Testing initiated at 9 June 2015 22:08 by user root.