PostgreSQL 11.0 Benchmarks

PostgreSQL 11.0 benchmarks including of new LLVM JIT. Benchmarks by Michael Larabel.

HTML result view exported from: https://openbenchmarking.org/result/1903051-SP-1810191SK83.

PostgreSQL 11.0 BenchmarksProcessorMotherboardChipsetMemoryDiskGraphicsMonitorNetworkOSKernelCompilerFile-SystemScreen ResolutionSystem LayerPostgreSQL 10.5PostgreSQL 11.0PostgreSQL 11.0 + LLVM JITPG10_11_JIT_201903052 x AMD EPYC 7601 32-Core @ 3.05GHz (64 Cores / 128 Threads)Dell 02MJ3T (1.2.5 BIOS)AMD Family 17h516096MB20 x 500GB Samsung SSD 860 + 120GB SSDSCKJB120G7RMatrox Matrox G200eW3VE228Broadcom and subsidiaries BCM57416 NetXtreme-E Dual-Media 10G RDMAUbuntu 18.104.18.0-8-generic (x86_64)GCC 8.2.0ext41600x12002 x AMD EPYC 7601 32-Core @ 3.11GHz (64 Cores / 128 Threads)2 x AMD EPYC 7601 32-Core @ 3.13GHz (64 Cores / 128 Threads)GCC 8.2.0 + LLVM 7.0.0Intel Xeon E5-2630 v4 (8 Cores)QEMU Standard PC (i440FX + PIIX 1996) (rel-1.11.0-0-g63451fca13-prebuilt.qemu-project.org BIOS)30720MB859GB QEMU HDDEFI VGAClear Linux OS 276004.18.0-10-generic (x86_64)GCC 8.2.1 20180502 + Clang 7.0.1 + LLVM 7.0.1overlayfs800x600KVMOpenBenchmarking.orgCompiler Details- PostgreSQL 10.5: --build=x86_64-linux-gnu --disable-vtable-verify --disable-werror --enable-checking=release --enable-clocale=gnu --enable-default-pie --enable-gnu-unique-object --enable-languages=c,ada,c++,go,brig,d,fortran,objc,obj-c++ --enable-libmpx --enable-libstdcxx-debug --enable-libstdcxx-time=yes --enable-multiarch --enable-multilib --enable-nls --enable-objc-gc=auto --enable-offload-targets=nvptx-none --enable-plugin --enable-shared --enable-threads=posix --host=x86_64-linux-gnu --program-prefix=x86_64-linux-gnu- --target=x86_64-linux-gnu --with-abi=m64 --with-arch-32=i686 --with-default-libstdcxx-abi=new --with-gcc-major-version-only --with-multilib-list=m32,m64,mx32 --with-target-system-zlib --with-tune=generic --without-cuda-driver -v - PostgreSQL 11.0: --build=x86_64-linux-gnu --disable-vtable-verify --disable-werror --enable-checking=release --enable-clocale=gnu --enable-default-pie --enable-gnu-unique-object --enable-languages=c,ada,c++,go,brig,d,fortran,objc,obj-c++ --enable-libmpx --enable-libstdcxx-debug --enable-libstdcxx-time=yes --enable-multiarch --enable-multilib --enable-nls --enable-objc-gc=auto --enable-offload-targets=nvptx-none --enable-plugin --enable-shared --enable-threads=posix --host=x86_64-linux-gnu --program-prefix=x86_64-linux-gnu- --target=x86_64-linux-gnu --with-abi=m64 --with-arch-32=i686 --with-default-libstdcxx-abi=new --with-gcc-major-version-only --with-multilib-list=m32,m64,mx32 --with-target-system-zlib --with-tune=generic --without-cuda-driver -v - PostgreSQL 11.0 + LLVM JIT: --build=x86_64-linux-gnu --disable-vtable-verify --disable-werror --enable-checking=release --enable-clocale=gnu --enable-default-pie --enable-gnu-unique-object --enable-languages=c,ada,c++,go,brig,d,fortran,objc,obj-c++ --enable-libmpx --enable-libstdcxx-debug --enable-libstdcxx-time=yes --enable-multiarch --enable-multilib --enable-nls --enable-objc-gc=auto --enable-offload-targets=nvptx-none --enable-plugin --enable-shared --enable-threads=posix --host=x86_64-linux-gnu --program-prefix=x86_64-linux-gnu- --target=x86_64-linux-gnu --with-abi=m64 --with-arch-32=i686 --with-default-libstdcxx-abi=new --with-gcc-major-version-only --with-multilib-list=m32,m64,mx32 --with-target-system-zlib --with-tune=generic --without-cuda-driver -v - PG10_11_JIT_20190305: --build=x86_64-generic-linux --disable-libmpx --disable-libunwind-exceptions --disable-multiarch --disable-vtable-verify --enable-__cxa_atexit --enable-bootstrap --enable-clocale=gnu --enable-gnu-indirect-function --enable-languages=c,c++,fortran,go --enable-ld=default --enable-libstdcxx-pch --enable-lto --enable-multilib --enable-plugin --enable-shared --enable-threads=posix --exec-prefix=/usr --includedir=/usr/include --target=x86_64-generic-linux --with-arch=westmere --with-glibc-version=2.19 --with-gnu-ld --with-isl --with-ppl=yes --with-tune=haswell Security Details- PostgreSQL 10.5: __user pointer sanitization + Full AMD retpoline IBPB + SSB disabled via prctl and seccomp- PostgreSQL 11.0: __user pointer sanitization + Full AMD retpoline IBPB + SSB disabled via prctl and seccomp- PostgreSQL 11.0 + LLVM JIT: __user pointer sanitization + Full AMD retpoline IBPB + SSB disabled via prctl and seccomp- PG10_11_JIT_20190305: KPTI + __user pointer sanitization + Full generic retpoline IBPB IBRS_FW + SSB disabled via prctl and seccomp + PTE Inversion

PostgreSQL 11.0 Benchmarkspgbench: Normal Load - Read Onlypgbench: Normal Load - Read Writepgbench: Single Thread - Read Onlypgbench: Single Thread - Read WritePostgreSQL 10.5PostgreSQL 11.0PostgreSQL 11.0 + LLVM JITPG10_11_JIT_201903055304855396149411150537465547315411114253826956771568511744563548058434898OpenBenchmarking.org

PostgreSQL pgbench

Test: Normal Load - Mode: Read Only

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbenchTest: Normal Load - Mode: Read OnlyPostgreSQL 10.5PostgreSQL 11.0PostgreSQL 11.0 + LLVM JITPG10_11_JIT_20190305120K240K360K480K600KSE +/- 3535.56, N = 3SE +/- 6846.38, N = 3SE +/- 4931.36, N = 3SE +/- 530.40, N = 853048553746553826945635

PostgreSQL pgbench

Test: Normal Load - Mode: Read Write

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbenchTest: Normal Load - Mode: Read WritePostgreSQL 10.5PostgreSQL 11.0PostgreSQL 11.0 + LLVM JITPG10_11_JIT_2019030512002400360048006000SE +/- 23.48, N = 3SE +/- 79.19, N = 3SE +/- 55.94, N = 3SE +/- 58.59, N = 35396547356774805

PostgreSQL pgbench

Test: Single Thread - Mode: Read Only

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbenchTest: Single Thread - Mode: Read OnlyPostgreSQL 10.5PostgreSQL 11.0PostgreSQL 11.0 + LLVM JITPG10_11_JIT_201903053K6K9K12K15KSE +/- 171.14, N = 3SE +/- 264.76, N = 4SE +/- 10.59, N = 3SE +/- 129.87, N = 51494115411156858434

PostgreSQL pgbench

Test: Single Thread - Mode: Read Write

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbenchTest: Single Thread - Mode: Read WritePostgreSQL 10.5PostgreSQL 11.0PostgreSQL 11.0 + LLVM JITPG10_11_JIT_2019030530060090012001500SE +/- 17.69, N = 3SE +/- 16.01, N = 5SE +/- 12.61, N = 3SE +/- 10.19, N = 12115011421174898

Phoronix Test Suite v10.8.4