PostgreSQL 11.0 benchmarks including of new LLVM JIT. Benchmarks by Michael Larabel.
Compare your own system(s) to this result file with the
Phoronix Test Suite by running the command:
phoronix-test-suite benchmark 1810191-SK-POSTGRESQ55 PostgreSQL 11.0 Benchmarks - Phoronix Test Suite 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&sro&grr .
PostgreSQL 11.0 Benchmarks Processor Motherboard Chipset Memory Disk Graphics Monitor Network OS Kernel Compiler File-System Screen Resolution PostgreSQL 10.5 PostgreSQL 11.0 PostgreSQL 11.0 + LLVM JIT 2 x AMD EPYC 7601 32-Core @ 3.05GHz (64 Cores / 128 Threads) Dell 02MJ3T (1.2.5 BIOS) AMD Family 17h 516096MB 20 x 500GB Samsung SSD 860 + 120GB SSDSCKJB120G7R Matrox Matrox G200eW3 VE228 Broadcom and subsidiaries BCM57416 NetXtreme-E Dual-Media 10G RDMA Ubuntu 18.10 4.18.0-8-generic (x86_64) GCC 8.2.0 ext4 1600x1200 2 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.0 OpenBenchmarking.org Compiler 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 Benchmarks pgbench: Single Thread - Read Write pgbench: Single Thread - Read Only pgbench: Normal Load - Read Write pgbench: Normal Load - Read Only PostgreSQL 10.5 PostgreSQL 11.0 PostgreSQL 11.0 + LLVM JIT 1150 14941 5396 530485 1142 15411 5473 537465 1174 15685 5677 538269 OpenBenchmarking.org
PostgreSQL pgbench Test: Single Thread - Mode: Read Write OpenBenchmarking.org TPS, More Is Better PostgreSQL pgbench Test: Single Thread - Mode: Read Write PostgreSQL 10.5 PostgreSQL 11.0 PostgreSQL 11.0 + LLVM JIT 300 600 900 1200 1500 SE +/- 17.69, N = 3 SE +/- 16.01, N = 5 SE +/- 12.61, N = 3 1150 1142 1174
PostgreSQL pgbench Test: Single Thread - Mode: Read Only OpenBenchmarking.org TPS, More Is Better PostgreSQL pgbench Test: Single Thread - Mode: Read Only PostgreSQL 10.5 PostgreSQL 11.0 PostgreSQL 11.0 + LLVM JIT 3K 6K 9K 12K 15K SE +/- 171.14, N = 3 SE +/- 264.76, N = 4 SE +/- 10.59, N = 3 14941 15411 15685
PostgreSQL pgbench Test: Normal Load - Mode: Read Write OpenBenchmarking.org TPS, More Is Better PostgreSQL pgbench Test: Normal Load - Mode: Read Write PostgreSQL 10.5 PostgreSQL 11.0 PostgreSQL 11.0 + LLVM JIT 1200 2400 3600 4800 6000 SE +/- 23.48, N = 3 SE +/- 79.19, N = 3 SE +/- 55.94, N = 3 5396 5473 5677
PostgreSQL pgbench Test: Normal Load - Mode: Read Only OpenBenchmarking.org TPS, More Is Better PostgreSQL pgbench Test: Normal Load - Mode: Read Only PostgreSQL 10.5 PostgreSQL 11.0 PostgreSQL 11.0 + LLVM JIT 120K 240K 360K 480K 600K SE +/- 3535.56, N = 3 SE +/- 6846.38, N = 3 SE +/- 4931.36, N = 3 530485 537465 538269
Phoronix Test Suite v10.8.4