database performance

test database performance

HTML result view exported from: https://openbenchmarking.org/result/1508095-BE-1508076BE48.

database performanceProcessorMotherboardChipsetMemoryDiskGraphicsNetworkOSKernelDesktopDisplay DriverCompilerFile-SystemScreen Resolutionold bclinux6new bclinux62 x Intel Xeon E5-2650 v2 @ 2.60GHz (32 Cores)Inspur NF5270M3 v00001Intel Xeon E5 v2/Core8 x 16384 MB DDR3-1333MHz Samsung480GB MR ROMB + 6000GB MR ROMBASPEED ASPEED FamilyIntel 82599ES 10-Gigabit SFI/SFP+BCLinux 6.52.6.32-431.el6.x86_64 (x86_64)GNOMEmodesetting 0.5.0GCC 4.4.7 20120313ext42 x Intel Xeon E5-2650 v2 @ 3.40GHz (32 Cores)3.10.79-1.el6.bclinux.x86_64 (x86_64)1024x768OpenBenchmarking.orgCompiler Details- --build=x86_64-redhat-linux --disable-dssi --disable-libjava-multilib --disable-libunwind-exceptions --enable-__cxa_atexit --enable-bootstrap --enable-checking=release --enable-gnu-unique-object --enable-java-awt=gtk --enable-java-maintainer-mode --enable-languages=c,c++,objc,obj-c++,java,fortran,ada --enable-libgcj-multifile --enable-shared --enable-threads=posix --mandir=/usr/share/man --with-arch_32=i686 --with-cloog --with-ppl --with-tune=generic Disk Details- old bclinux6: CFQ / barrier=1,data=ordered,relatime,rw,seclabel- new bclinux6: CFQ / data=ordered,relatime,rw,seclabelProcessor Details- old bclinux6: Scaling Governor: acpi-cpufreq ondemand- new bclinux6: Scaling Governor: intel_pstate powersaveSystem Details- Disk Scheduler: CFQ. SELinux: Enabled.

database performancesqlite: Default Test Directorypgbench: On-Disk - Normal Load - Read Onlypgbench: On-Disk - Normal Load - Read Writepgbench: Mostly RAM - Normal Load - Read Onlypgbench: Buffer Test - Normal Load - Read Onlypgbench: Mostly RAM - Normal Load - Read Writepgbench: Buffer Test - Normal Load - Read Writeold bclinux6new bclinux69.23340608.30480.24120538.17131366.206998.076290.668.69333143.67479.41140609.34147113.808690.566233.08OpenBenchmarking.org

SQLite

Test Target: Default Test Directory

OpenBenchmarking.orgSeconds, Fewer Is BetterSQLite 3.8.10.2Test Target: Default Test Directoryold bclinux6new bclinux63691215SE +/- 0.10, N = 3SE +/- 0.39, N = 69.238.691. (CC) gcc options: -O2 -ldl -lpthread

PostgreSQL pgbench

Scaling: On-Disk - Test: Normal Load - Mode: Read Only

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 9.4.3Scaling: On-Disk - Test: Normal Load - Mode: Read Onlyold bclinux6new bclinux670K140K210K280K350KSE +/- 513.34, N = 3SE +/- 368.92, N = 3340608.30333143.671. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -pthread -lpgcommon -lpgport -lpq -lpthread -lrt -lcrypt -ldl -lm

PostgreSQL pgbench

Scaling: On-Disk - Test: Normal Load - Mode: Read Write

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 9.4.3Scaling: On-Disk - Test: Normal Load - Mode: Read Writeold bclinux6new bclinux6100200300400500SE +/- 0.08, N = 3SE +/- 0.02, N = 3480.24479.411. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -pthread -lpgcommon -lpgport -lpq -lpthread -lrt -lcrypt -ldl -lm

PostgreSQL pgbench

Scaling: Mostly RAM - Test: Normal Load - Mode: Read Only

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 9.4.3Scaling: Mostly RAM - Test: Normal Load - Mode: Read Onlyold bclinux6new bclinux630K60K90K120K150KSE +/- 479.78, N = 3SE +/- 775.63, N = 3120538.17140609.341. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -pthread -lpgcommon -lpgport -lpq -lpthread -lrt -lcrypt -ldl -lm

PostgreSQL pgbench

Scaling: Buffer Test - Test: Normal Load - Mode: Read Only

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 9.4.3Scaling: Buffer Test - Test: Normal Load - Mode: Read Onlyold bclinux6new bclinux630K60K90K120K150KSE +/- 379.00, N = 3SE +/- 610.93, N = 3131366.20147113.801. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -pthread -lpgcommon -lpgport -lpq -lpthread -lrt -lcrypt -ldl -lm

PostgreSQL pgbench

Scaling: Mostly RAM - Test: Normal Load - Mode: Read Write

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 9.4.3Scaling: Mostly RAM - Test: Normal Load - Mode: Read Writeold bclinux6new bclinux62K4K6K8K10KSE +/- 298.78, N = 6SE +/- 76.31, N = 36998.078690.561. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -pthread -lpgcommon -lpgport -lpq -lpthread -lrt -lcrypt -ldl -lm

PostgreSQL pgbench

Scaling: Buffer Test - Test: Normal Load - Mode: Read Write

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 9.4.3Scaling: Buffer Test - Test: Normal Load - Mode: Read Writeold bclinux6new bclinux613002600390052006500SE +/- 216.83, N = 6SE +/- 294.24, N = 66290.666233.081. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -pthread -lpgcommon -lpgport -lpq -lpthread -lrt -lcrypt -ldl -lm

Phoronix Test Suite v10.8.4