PostgreSQL 10 Beta Benchmarking

Some early benchmarks of PostgreSQL 10 Beta 1. Tests by Michael Larabel

HTML result view exported from: https://openbenchmarking.org/result/1705198-TR-POSTGRESQ35&sro.

PostgreSQL 10 Beta BenchmarkingProcessorMotherboardChipsetMemoryDiskGraphicsAudioMonitorNetworkOSKernelDesktopDisplay ServerDisplay DriverOpenGLVulkanCompilerFile-SystemScreen ResolutionPostgreSQL 9.6.3PostgreSQL 10.0 Beta 1Intel Xeon E3-1280 v5 @ 4.00GHz (8 Cores)MSI C236A WORKSTATION (MS-7998) v1.0Intel Sky Lake16384MB256GB TOSHIBA-RD400Sapphire AMD POLARIS10 4096MBRealtek ALC1150DELL P2415QIntel ConnectionUbuntu 16.044.12.0-999-generic (x86_64) 20170517Unity 7.4.0X Server 1.18.4modesetting 1.18.44.5 Mesa 17.2.0-devel- padoka PPA Gallium 0.4 (LLVM 5.0.0)1.0.21GCC 5.4.0 20160609ext43840x2160OpenBenchmarking.orgCompiler Details- --build=x86_64-linux-gnu --disable-browser-plugin --disable-vtable-verify --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,ada,c++,java,go,d,fortran,objc,obj-c++ --enable-libmpx --enable-libstdcxx-debug --enable-libstdcxx-time=yes --enable-multiarch --enable-multilib --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-default-libstdcxx-abi=new --with-multilib-list=m32,m64,mx32 --with-tune=generic -v Processor Details- Scaling Governor: intel_pstate performance

PostgreSQL 10 Beta Benchmarkingpgbench: On-Disk - Normal Load - Read Onlypgbench: On-Disk - Normal Load - Read Writepgbench: Buffer Test - Normal Load - Read Onlypgbench: Buffer Test - Normal Load - Read Writepgbench: On-Disk - Heavy Contention - Read Onlypgbench: On-Disk - Heavy Contention - Read Writepgbench: Buffer Test - Heavy Contention - Read Onlypgbench: Buffer Test - Heavy Contention - Read WritePostgreSQL 9.6.3PostgreSQL 10.0 Beta 1185598.271194.17126711.141657.06157553.041190.23117563.062734.09184213.981391.65120952.242326.75172121.851377.40115252.142897.34OpenBenchmarking.org

PostgreSQL pgbench

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

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbenchScaling: On-Disk - Test: Normal Load - Mode: Read OnlyPostgreSQL 10.0 Beta 1PostgreSQL 9.6.340K80K120K160K200KSE +/- 10.96, N = 3SE +/- 1184.33, N = 3184213.98185598.27-lpthread1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -fpic -lpgcommon -lpgport -lrt -lcrypt -ldl -lm

PostgreSQL pgbench

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

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbenchScaling: On-Disk - Test: Normal Load - Mode: Read WritePostgreSQL 10.0 Beta 1PostgreSQL 9.6.330060090012001500SE +/- 16.03, N = 3SE +/- 3.56, N = 31391.651194.17-lpthread1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -fpic -lpgcommon -lpgport -lrt -lcrypt -ldl -lm

PostgreSQL pgbench

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

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbenchScaling: Buffer Test - Test: Normal Load - Mode: Read OnlyPostgreSQL 10.0 Beta 1PostgreSQL 9.6.330K60K90K120K150KSE +/- 189.53, N = 3SE +/- 107.94, N = 3120952.24126711.14-lpthread1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -fpic -lpgcommon -lpgport -lrt -lcrypt -ldl -lm

PostgreSQL pgbench

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

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbenchScaling: Buffer Test - Test: Normal Load - Mode: Read WritePostgreSQL 10.0 Beta 1PostgreSQL 9.6.35001000150020002500SE +/- 23.94, N = 3SE +/- 738.96, N = 62326.751657.06-lpthread1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -fpic -lpgcommon -lpgport -lrt -lcrypt -ldl -lm

PostgreSQL pgbench

Scaling: On-Disk - Test: Heavy Contention - Mode: Read Only

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbenchScaling: On-Disk - Test: Heavy Contention - Mode: Read OnlyPostgreSQL 10.0 Beta 1PostgreSQL 9.6.340K80K120K160K200KSE +/- 348.36, N = 3SE +/- 210.62, N = 3172121.85157553.04-lpthread1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -fpic -lpgcommon -lpgport -lrt -lcrypt -ldl -lm

PostgreSQL pgbench

Scaling: On-Disk - Test: Heavy Contention - Mode: Read Write

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbenchScaling: On-Disk - Test: Heavy Contention - Mode: Read WritePostgreSQL 10.0 Beta 1PostgreSQL 9.6.330060090012001500SE +/- 9.43, N = 3SE +/- 4.14, N = 31377.401190.23-lpthread1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -fpic -lpgcommon -lpgport -lrt -lcrypt -ldl -lm

PostgreSQL pgbench

Scaling: Buffer Test - Test: Heavy Contention - Mode: Read Only

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbenchScaling: Buffer Test - Test: Heavy Contention - Mode: Read OnlyPostgreSQL 10.0 Beta 1PostgreSQL 9.6.330K60K90K120K150KSE +/- 775.06, N = 3SE +/- 2251.72, N = 3115252.14117563.06-lpthread1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -fpic -lpgcommon -lpgport -lrt -lcrypt -ldl -lm

PostgreSQL pgbench

Scaling: Buffer Test - Test: Heavy Contention - Mode: Read Write

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbenchScaling: Buffer Test - Test: Heavy Contention - Mode: Read WritePostgreSQL 10.0 Beta 1PostgreSQL 9.6.36001200180024003000SE +/- 83.33, N = 6SE +/- 1115.15, N = 52897.342734.09-lpthread1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -fpic -lpgcommon -lpgport -lrt -lcrypt -ldl -lm

Phoronix Test Suite v10.8.4