AMD EPYC PostgreSQL Benchmarking

AMD EPYC 7601 32-Core testing with a TYAN B8026T70AE24HR (V1.02.B10 BIOS) and ASPEED ASPEED Family on Ubuntu 18.10 via the Phoronix Test Suite.

HTML result view exported from: https://openbenchmarking.org/result/1806301-AR-AMDEPYCPO35&sor.

AMD EPYC PostgreSQL BenchmarkingProcessorMotherboardChipsetMemoryDiskGraphicsMonitorNetworkOSKernelCompilerFile-SystemScreen ResolutionPostgreSQL 10.3PostgreSQL 10.4PostgreSQL 9.6.9PostgreSQL 11.0 Beta 2AMD EPYC 7601 32-Core @ 2.20GHz (32 Cores / 64 Threads)TYAN B8026T70AE24HR (V1.02.B10 BIOS)AMD Family 17h129024MB280GB INTEL SSDPE21D280GAASPEED ASPEED FamilyVE228Broadcom Limited NetXtreme BCM5720 Gigabit PCIeUbuntu 18.104.17.0-041700-generic (x86_64)GCC 8.1.0ext41920x1080OpenBenchmarking.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 Processor Details- Scaling Governor: acpi-cpufreq ondemandSecurity Details- __user pointer sanitization + Full AMD retpoline IBPB + SSB disabled via prctl and seccomp Protection

AMD EPYC PostgreSQL Benchmarkingpgbench: Buffer Test - Normal Load - Read Onlypgbench: Buffer Test - Normal Load - Read Writepgbench: Buffer Test - Single Thread - Read Onlypgbench: Buffer Test - Single Thread - Read WritePostgreSQL 10.3PostgreSQL 10.4PostgreSQL 9.6.9PostgreSQL 11.0 Beta 2385532.9737191.9114467.152081.43394697.6236737.5414404.212107.97405330.2131048.9414847.812045.73417754.7524758.6114800.232079.72OpenBenchmarking.org

PostgreSQL pgbench

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

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 10.3Scaling: Buffer Test - Test: Normal Load - Mode: Read OnlyPostgreSQL 11.0 Beta 2PostgreSQL 9.6.9PostgreSQL 10.4PostgreSQL 10.390K180K270K360K450KSE +/- 4575.77, N = 3SE +/- 5028.23, N = 3SE +/- 2879.68, N = 3SE +/- 7191.89, N = 3417754.75405330.21394697.62385532.97-lpq -lpthread-fPIC-lpq -lpthread-lpq -lpthread1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lrt -lcrypt -ldl -lm

PostgreSQL pgbench

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

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 10.3Scaling: Buffer Test - Test: Normal Load - Mode: Read WritePostgreSQL 10.3PostgreSQL 10.4PostgreSQL 9.6.9PostgreSQL 11.0 Beta 28K16K24K32K40KSE +/- 87.12, N = 3SE +/- 32.28, N = 3SE +/- 113.68, N = 3SE +/- 58.61, N = 337191.9136737.5431048.9424758.61-lpq -lpthread-lpq -lpthread-fPIC-lpq -lpthread1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lrt -lcrypt -ldl -lm

PostgreSQL pgbench

Scaling: Buffer Test - Test: Single Thread - Mode: Read Only

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 10.3Scaling: Buffer Test - Test: Single Thread - Mode: Read OnlyPostgreSQL 9.6.9PostgreSQL 11.0 Beta 2PostgreSQL 10.3PostgreSQL 10.43K6K9K12K15KSE +/- 47.43, N = 3SE +/- 97.15, N = 3SE +/- 111.85, N = 3SE +/- 87.97, N = 314847.8114800.2314467.1514404.21-fPIC-lpq -lpthread-lpq -lpthread-lpq -lpthread1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lrt -lcrypt -ldl -lm

PostgreSQL pgbench

Scaling: Buffer Test - Test: Single Thread - Mode: Read Write

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 10.3Scaling: Buffer Test - Test: Single Thread - Mode: Read WritePostgreSQL 10.4PostgreSQL 10.3PostgreSQL 11.0 Beta 2PostgreSQL 9.6.95001000150020002500SE +/- 28.41, N = 3SE +/- 7.49, N = 3SE +/- 9.94, N = 3SE +/- 22.44, N = 32107.972081.432079.722045.73-lpq -lpthread-lpq -lpthread-lpq -lpthread-fPIC1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lrt -lcrypt -ldl -lm

Phoronix Test Suite v10.8.4