Harrison John

Running pts/pgbench-1.5.2 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 1511249-KH-HARRISONJ67
Jump To Table - Results

View

Do Not Show Noisy Results
Do Not Show Results With Incomplete Data
Do Not Show Results With Little Change/Spread
List Notable Results

Limit displaying results to tests within:

Database Test Suite 2 Tests
Server 2 Tests

Statistics

Show Overall Harmonic Mean(s)
Show Overall Geometric Mean
Show Geometric Means Per-Suite/Category
Show Wins / Losses Counts (Pie Chart)
Normalize Results
Remove Outliers Before Calculating Averages

Graph Settings

Force Line Graphs Where Applicable
Convert To Scalar Where Applicable
Prefer Vertical Bar Graphs

Multi-Way Comparison

Condense Multi-Option Tests Into Single Result Graphs

Table

Show Detailed System Result Table

Run Management

Highlight
Result
Hide
Result
Result
Identifier
Performance Per
Dollar
Date
Run
  Test
  Duration
Benchmarking-Databases
November 21 2015
 
SQLITE Benchmarked
November 24 2015
 
Postgre Database Benchmarked
November 25 2015
 
Invert Hiding All Results Option
 

Only show results where is faster than
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):

Benchmarking-Databases

Compiler Notes: --build=x86_64-linux-gnu --disable-browser-plugin --disable-libmudflap --disable-werror --enable-checking=release --enable-clocale=gnu --enable-gnu-unique-object --enable-gtk-cairo --enable-java-awt=gtk --enable-java-home --enable-languages=c,c++,java,go,d,fortran,objc,obj-c++ --enable-libstdcxx-debug --enable-libstdcxx-time=yes --enable-multiarch --enable-nls --enable-objc-gc --enable-plugin --enable-shared --enable-threads=posix --host=x86_64-linux-gnu --target=x86_64-linux-gnu --with-abi=m64 --with-arch-32=i686 --with-arch-directory=amd64 --with-multilib-list=m32,m64,mx32 --with-tune=generic -v
Disk Notes: DEADLINE / data=ordered,errors=remount-ro,relatime,rw
Processor Notes: Scaling Governor: acpi-cpufreq ondemand
System Notes: Disk Scheduler: DEADLINE.

SQLITE Benchmarked

Postgre Database Benchmarked

Processor: Intel Pentium Dual T2370 @ 1.73GHz (2 Cores), Motherboard: Sony VAIO, Chipset: Intel Mobile PM965/GM965/GL960 + ICH8M, Memory: 2560MB, Disk: 160GB Seagate ST9160821AS, Graphics: Intel Mobile GM965/GL960 IGP (primary), Audio: Intel 82801H, Network: Marvell 88E8039 PCI-E Fast

OS: Ubuntu 14.04, Kernel: 3.19.0-33-generic (x86_64), Desktop: Unity 7.2.5, Display Server: X Server 1.17.1, Display Driver: intel 2.99.917, OpenGL: 2.1 Mesa 10.5.9, Compiler: GCC 4.8.4, File-System: ext4, Screen Resolution: 1280x800

Compiler Notes: --build=x86_64-linux-gnu --disable-browser-plugin --disable-libmudflap --disable-werror --enable-checking=release --enable-clocale=gnu --enable-gnu-unique-object --enable-gtk-cairo --enable-java-awt=gtk --enable-java-home --enable-languages=c,c++,java,go,d,fortran,objc,obj-c++ --enable-libstdcxx-debug --enable-libstdcxx-time=yes --enable-multiarch --enable-nls --enable-objc-gc --enable-plugin --enable-shared --enable-threads=posix --host=x86_64-linux-gnu --target=x86_64-linux-gnu --with-abi=m64 --with-arch-32=i686 --with-arch-directory=amd64 --with-multilib-list=m32,m64,mx32 --with-tune=generic -v
Processor Notes: Scaling Governor: acpi-cpufreq ondemand

Harrison JohnOpenBenchmarking.orgPhoronix Test SuiteIntel Pentium Dual T2370 @ 1.73GHz (2 Cores)Sony VAIOIntel Mobile PM965/GM965/GL960 + ICH8M2560MB160GB Seagate ST9160821ASIntel Mobile GM965/GL960 IGP (primary)Intel 82801HMarvell 88E8039 PCI-E FastUbuntu 14.043.19.0-33-generic (x86_64)Unity 7.2.5X Server 1.17.1intel 2.99.9172.1 Mesa 10.5.9GCC 4.8.4ext41280x800ProcessorMotherboardChipsetMemoryDiskGraphicsAudioNetworkOSKernelDesktopDisplay ServerDisplay DriverOpenGLCompilerFile-SystemScreen ResolutionHarrison John BenchmarksSystem Logs- --build=x86_64-linux-gnu --disable-browser-plugin --disable-libmudflap --disable-werror --enable-checking=release --enable-clocale=gnu --enable-gnu-unique-object --enable-gtk-cairo --enable-java-awt=gtk --enable-java-home --enable-languages=c,c++,java,go,d,fortran,objc,obj-c++ --enable-libstdcxx-debug --enable-libstdcxx-time=yes --enable-multiarch --enable-nls --enable-objc-gc --enable-plugin --enable-shared --enable-threads=posix --host=x86_64-linux-gnu --target=x86_64-linux-gnu --with-abi=m64 --with-arch-32=i686 --with-arch-directory=amd64 --with-multilib-list=m32,m64,mx32 --with-tune=generic -v - Benchmarking-Databases, SQLITE Benchmarked: DEADLINE / data=ordered,errors=remount-ro,relatime,rw - Scaling Governor: acpi-cpufreq ondemand- Benchmarking-Databases, SQLITE Benchmarked: Disk Scheduler: DEADLINE.

Harrison Johnsqlite: Timed SQLite Insertionssqlite: Default Test Directorypgbench: On-Disk - Normal Load - Read Onlypgbench: On-Disk - Normal Load - Read Writepgbench: On-Disk - Single Thread - Read Onlypgbench: Mostly RAM - Normal Load - Read Onlypgbench: On-Disk - Single Thread - Read Writepgbench: Buffer Test - Normal Load - Read Onlypgbench: Mostly RAM - Normal Load - Read Writepgbench: Buffer Test - Normal Load - Read Writepgbench: Mostly RAM - Single Thread - Read Onlypgbench: On-Disk - Heavy Contention - Read Onlypgbench: Buffer Test - Single Thread - Read Onlypgbench: Mostly RAM - Single Thread - Read Writepgbench: On-Disk - Heavy Contention - Read Writepgbench: Buffer Test - Single Thread - Read Writepgbench: Mostly RAM - Heavy Contention - Read Onlypgbench: Buffer Test - Heavy Contention - Read Onlypgbench: Mostly RAM - Heavy Contention - Read Writepgbench: Buffer Test - Heavy Contention - Read WriteBenchmarking-DatabasesSQLITE BenchmarkedPostgre Database Benchmarked499.82514.009682.65335.195064.155736.9833.446969.66181.52190.853723.958888.714275.8775.71512.1269.405475.596579.76195.56258.84OpenBenchmarking.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.2Timed SQLite InsertionsBenchmarking-Databases110220330440550SE +/- 2.71, N = 3499.821. (CC) gcc options: -O2 -ldl -lpthread

OpenBenchmarking.orgSeconds, Fewer Is BetterSQLite 3.8.10.2Test Target: Default Test DirectorySQLITE Benchmarked110220330440550SE +/- 3.03, N = 3514.001. (CC) gcc options: -O2 -ldl -lpthread

PostgreSQL pgbench

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 9.4.3Scaling: On-Disk - Test: Normal Load - Mode: Read OnlyPostgre Database Benchmarked2K4K6K8K10KSE +/- 59.05, N = 39682.651. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -pthread -lpgcommon -lpgport -lpq -lpthread -lrt -lcrypt -ldl -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 9.4.3Scaling: On-Disk - Test: Normal Load - Mode: Read WritePostgre Database Benchmarked70140210280350SE +/- 2.26, N = 3335.191. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -pthread -lpgcommon -lpgport -lpq -lpthread -lrt -lcrypt -ldl -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 9.4.3Scaling: On-Disk - Test: Single Thread - Mode: Read OnlyPostgre Database Benchmarked11002200330044005500SE +/- 87.49, N = 35064.151. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -pthread -lpgcommon -lpgport -lpq -lpthread -lrt -lcrypt -ldl -lm

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

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 9.4.3Scaling: On-Disk - Test: Single Thread - Mode: Read WritePostgre Database Benchmarked816243240SE +/- 3.47, N = 633.441. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -pthread -lpgcommon -lpgport -lpq -lpthread -lrt -lcrypt -ldl -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 9.4.3Scaling: Buffer Test - Test: Normal Load - Mode: Read OnlyPostgre Database Benchmarked15003000450060007500SE +/- 10.67, N = 36969.661. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -pthread -lpgcommon -lpgport -lpq -lpthread -lrt -lcrypt -ldl -lm

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

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 9.4.3Scaling: Buffer Test - Test: Normal Load - Mode: Read WritePostgre Database Benchmarked4080120160200SE +/- 2.56, N = 6190.851. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -pthread -lpgcommon -lpgport -lpq -lpthread -lrt -lcrypt -ldl -lm

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

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 9.4.3Scaling: On-Disk - Test: Heavy Contention - Mode: Read OnlyPostgre Database Benchmarked2K4K6K8K10KSE +/- 51.37, N = 38888.711. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -pthread -lpgcommon -lpgport -lpq -lpthread -lrt -lcrypt -ldl -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 9.4.3Scaling: Buffer Test - Test: Single Thread - Mode: Read OnlyPostgre Database Benchmarked9001800270036004500SE +/- 33.61, N = 34275.871. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -pthread -lpgcommon -lpgport -lpq -lpthread -lrt -lcrypt -ldl -lm

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

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 9.4.3Scaling: On-Disk - Test: Heavy Contention - Mode: Read WritePostgre Database Benchmarked110220330440550SE +/- 1.87, N = 3512.121. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -pthread -lpgcommon -lpgport -lpq -lpthread -lrt -lcrypt -ldl -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 9.4.3Scaling: Buffer Test - Test: Single Thread - Mode: Read WritePostgre Database Benchmarked1530456075SE +/- 0.63, N = 369.401. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -pthread -lpgcommon -lpgport -lpq -lpthread -lrt -lcrypt -ldl -lm

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

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 9.4.3Scaling: Buffer Test - Test: Heavy Contention - Mode: Read OnlyPostgre Database Benchmarked14002800420056007000SE +/- 30.53, N = 36579.761. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -pthread -lpgcommon -lpgport -lpq -lpthread -lrt -lcrypt -ldl -lm

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

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 9.4.3Scaling: Buffer Test - Test: Heavy Contention - Mode: Read WritePostgre Database Benchmarked60120180240300SE +/- 2.55, N = 3258.841. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -pthread -lpgcommon -lpgport -lpq -lpthread -lrt -lcrypt -ldl -lm

Benchmarking-Databases

Compiler Notes: --build=x86_64-linux-gnu --disable-browser-plugin --disable-libmudflap --disable-werror --enable-checking=release --enable-clocale=gnu --enable-gnu-unique-object --enable-gtk-cairo --enable-java-awt=gtk --enable-java-home --enable-languages=c,c++,java,go,d,fortran,objc,obj-c++ --enable-libstdcxx-debug --enable-libstdcxx-time=yes --enable-multiarch --enable-nls --enable-objc-gc --enable-plugin --enable-shared --enable-threads=posix --host=x86_64-linux-gnu --target=x86_64-linux-gnu --with-abi=m64 --with-arch-32=i686 --with-arch-directory=amd64 --with-multilib-list=m32,m64,mx32 --with-tune=generic -v
Disk Notes: DEADLINE / data=ordered,errors=remount-ro,relatime,rw
Processor Notes: Scaling Governor: acpi-cpufreq ondemand
System Notes: Disk Scheduler: DEADLINE.

Testing initiated at 21 November 2015 11:50 by user harrison.

SQLITE Benchmarked

Compiler Notes: --build=x86_64-linux-gnu --disable-browser-plugin --disable-libmudflap --disable-werror --enable-checking=release --enable-clocale=gnu --enable-gnu-unique-object --enable-gtk-cairo --enable-java-awt=gtk --enable-java-home --enable-languages=c,c++,java,go,d,fortran,objc,obj-c++ --enable-libstdcxx-debug --enable-libstdcxx-time=yes --enable-multiarch --enable-nls --enable-objc-gc --enable-plugin --enable-shared --enable-threads=posix --host=x86_64-linux-gnu --target=x86_64-linux-gnu --with-abi=m64 --with-arch-32=i686 --with-arch-directory=amd64 --with-multilib-list=m32,m64,mx32 --with-tune=generic -v
Disk Notes: DEADLINE / data=ordered,errors=remount-ro,relatime,rw
Processor Notes: Scaling Governor: acpi-cpufreq ondemand
System Notes: Disk Scheduler: DEADLINE.

Testing initiated at 24 November 2015 23:16 by user harrison.

Postgre Database Benchmarked

Processor: Intel Pentium Dual T2370 @ 1.73GHz (2 Cores), Motherboard: Sony VAIO, Chipset: Intel Mobile PM965/GM965/GL960 + ICH8M, Memory: 2560MB, Disk: 160GB Seagate ST9160821AS, Graphics: Intel Mobile GM965/GL960 IGP (primary), Audio: Intel 82801H, Network: Marvell 88E8039 PCI-E Fast

OS: Ubuntu 14.04, Kernel: 3.19.0-33-generic (x86_64), Desktop: Unity 7.2.5, Display Server: X Server 1.17.1, Display Driver: intel 2.99.917, OpenGL: 2.1 Mesa 10.5.9, Compiler: GCC 4.8.4, File-System: ext4, Screen Resolution: 1280x800

Compiler Notes: --build=x86_64-linux-gnu --disable-browser-plugin --disable-libmudflap --disable-werror --enable-checking=release --enable-clocale=gnu --enable-gnu-unique-object --enable-gtk-cairo --enable-java-awt=gtk --enable-java-home --enable-languages=c,c++,java,go,d,fortran,objc,obj-c++ --enable-libstdcxx-debug --enable-libstdcxx-time=yes --enable-multiarch --enable-nls --enable-objc-gc --enable-plugin --enable-shared --enable-threads=posix --host=x86_64-linux-gnu --target=x86_64-linux-gnu --with-abi=m64 --with-arch-32=i686 --with-arch-directory=amd64 --with-multilib-list=m32,m64,mx32 --with-tune=generic -v
Processor Notes: Scaling Governor: acpi-cpufreq ondemand

Testing initiated at 25 November 2015 00:34 by user harrison.