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/1810191-SK-POSTGRESQ55.

PostgreSQL 11.0 BenchmarksProcessorMotherboardChipsetMemoryDiskGraphicsMonitorNetworkOSKernelCompilerFile-SystemScreen ResolutionPostgreSQL 10.5PostgreSQL 11.0PostgreSQL 11.0 + LLVM JIT2 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.0OpenBenchmarking.orgCompiler Details- --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 Security Details- __user pointer sanitization + Full AMD retpoline IBPB + SSB disabled via prctl and seccomp

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 JIT530485539614941115053746554731541111425382695677156851174OpenBenchmarking.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 JIT120K240K360K480K600KSE +/- 3535.56, N = 3SE +/- 6846.38, N = 3SE +/- 4931.36, N = 3530485537465538269

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 JIT12002400360048006000SE +/- 23.48, N = 3SE +/- 79.19, N = 3SE +/- 55.94, N = 3539654735677

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 JIT3K6K9K12K15KSE +/- 171.14, N = 3SE +/- 264.76, N = 4SE +/- 10.59, N = 3149411541115685

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 JIT30060090012001500SE +/- 17.69, N = 3SE +/- 16.01, N = 5SE +/- 12.61, N = 3115011421174

Phoronix Test Suite v10.8.5