database performance

2 x Intel Xeon E5-2650 v2 testing with a Inspur NF5270M3 v00001 and ASPEED ASPEED Family on BCLinux 6.5 via the Phoronix Test Suite.

HTML result view exported from: https://openbenchmarking.org/result/1508061-BE-1508052BE59.

database performanceProcessorMotherboardChipsetMemoryDiskGraphicsNetworkOSKernelDesktopDisplay DriverCompilerFile-Systembclinux 62 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 20120313ext4OpenBenchmarking.org- --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 - CFQ / barrier=1,data=ordered,relatime,rw,seclabel- Scaling Governor: acpi-cpufreq ondemand- 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 Writebclinux 68.84333048.13479.32140688.05147187.258817.167006.05OpenBenchmarking.org

SQLite

Test Target: Default Test Directory

OpenBenchmarking.orgSeconds, Fewer Is BetterSQLite 3.8.10.2Test Target: Default Test Directorybclinux 63691215SE +/- 0.10, N = 39.231. (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 Onlybclinux 670K140K210K280K350KSE +/- 513.34, N = 3340608.301. (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 Writebclinux 6100200300400500SE +/- 0.08, N = 3480.241. (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 Onlybclinux 630K60K90K120K150KSE +/- 479.78, N = 3120538.171. (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 Onlybclinux 630K60K90K120K150KSE +/- 379.00, N = 3131366.201. (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 Writebclinux 62K4K6K8K10KSE +/- 298.78, N = 66998.071. (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 Writebclinux 615003000450060007500SE +/- 216.83, N = 66290.661. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -pthread -lpgcommon -lpgport -lpq -lpthread -lrt -lcrypt -ldl -lm

Phoronix Test Suite v10.8.4