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.

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 9.6.3PostgreSQL 10.0 Beta 140K80K120K160K200KSE +/- 1184.33, N = 3SE +/- 10.96, N = 3185598.27184213.98-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 9.6.3PostgreSQL 10.0 Beta 130060090012001500SE +/- 3.56, N = 3SE +/- 16.03, N = 31194.171391.65-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 9.6.3PostgreSQL 10.0 Beta 130K60K90K120K150KSE +/- 107.94, N = 3SE +/- 189.53, N = 3126711.14120952.24-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 9.6.3PostgreSQL 10.0 Beta 15001000150020002500SE +/- 738.96, N = 6SE +/- 23.94, N = 31657.062326.75-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 9.6.3PostgreSQL 10.0 Beta 140K80K120K160K200KSE +/- 210.62, N = 3SE +/- 348.36, N = 3157553.04172121.85-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 9.6.3PostgreSQL 10.0 Beta 130060090012001500SE +/- 4.14, N = 3SE +/- 9.43, N = 31190.231377.40-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 9.6.3PostgreSQL 10.0 Beta 130K60K90K120K150KSE +/- 2251.72, N = 3SE +/- 775.06, N = 3117563.06115252.14-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 9.6.3PostgreSQL 10.0 Beta 16001200180024003000SE +/- 1115.15, N = 5SE +/- 83.33, N = 62734.092897.34-lpthread1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -fpic -lpgcommon -lpgport -lrt -lcrypt -ldl -lm

Phoronix Test Suite v10.8.4