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.

Compare your own system(s) to this result file with the Phoronix Test Suite by running the command: phoronix-test-suite benchmark 1806301-AR-AMDEPYCPO35
Jump To Table - Results

View

Do Not Show Noisy Results
Do Not Show Results With Incomplete Data
Do Not Show Results With Little Change/Spread
List Notable Results

Statistics

Show Overall Harmonic Mean(s)
Show Overall Geometric Mean
Show Wins / Losses Counts (Pie Chart)
Normalize Results
Remove Outliers Before Calculating Averages

Graph Settings

Force Line Graphs Where Applicable
Convert To Scalar Where Applicable
Prefer Vertical Bar Graphs

Multi-Way Comparison

Condense Multi-Option Tests Into Single Result Graphs

Table

Show Detailed System Result Table

Run Management

Highlight
Result
Hide
Result
Result
Identifier
Perf-Per
Dollar
Date
Triggered
  Test
  Duration
PostgreSQL 10.3
June 30 2018
  26 Minutes
PostgreSQL 10.4
June 30 2018
  26 Minutes
PostgreSQL 9.6.9
June 30 2018
  25 Minutes
PostgreSQL 11.0 Beta 2
June 30 2018
  26 Minutes
Invert Hiding All Results Option
  26 Minutes
Only show results where is faster than
Only show results matching title/arguments (delimit multiple options with a comma):

PostgreSQL 10.3

PostgreSQL 10.4

PostgreSQL 9.6.9

PostgreSQL 11.0 Beta 2

Processor: AMD EPYC 7601 32-Core @ 2.20GHz (32 Cores / 64 Threads), Motherboard: TYAN B8026T70AE24HR (V1.02.B10 BIOS), Chipset: AMD Family 17h, Memory: 129024MB, Disk: 280GB INTEL SSDPE21D280GA, Graphics: ASPEED ASPEED Family, Monitor: VE228, Network: Broadcom Limited NetXtreme BCM5720 Gigabit PCIe

OS: Ubuntu 18.10, Kernel: 4.17.0-041700-generic (x86_64), Compiler: GCC 8.1.0, File-System: ext4, Screen Resolution: 1920x1080

Compiler Notes: --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 Notes: Scaling Governor: acpi-cpufreq ondemand
Security Notes: __user pointer sanitization + Full AMD retpoline IBPB + SSB disabled via prctl and seccomp Protection

AMD EPYC PostgreSQL BenchmarkingOpenBenchmarking.orgPhoronix Test Suite 10.4.0m1AMD 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.0ext41920x1080ProcessorMotherboardChipsetMemoryDiskGraphicsMonitorNetworkOSKernelCompilerFile-SystemScreen ResolutionAMD EPYC PostgreSQL Benchmarking PerformanceSystem Logs- --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 - Scaling Governor: acpi-cpufreq ondemand- __user pointer sanitization + Full AMD retpoline IBPB + SSB disabled via prctl and seccomp Protection

PostgreSQL 10.3PostgreSQL 10.4PostgreSQL 9.6.9PostgreSQL 11.0 Beta 2Result OverviewPhoronix Test Suite 10.4.0m1100%113%125%138%150%PostgreSQL pgbenchPostgreSQL pgbenchPostgreSQL pgbenchPostgreSQL pgbenchBuffer Test - Normal Load - Read WriteBuffer Test - Normal Load - Read OnlyBuffer Test - Single Thread - Read OnlyBuffer Test - Single Thread - Read Write

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

This is a simple benchmark of PostgreSQL using pgbench. Learn more via the OpenBenchmarking.org test page.

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 10.3Scaling: Buffer Test - Test: Normal Load - Mode: Read OnlyPostgreSQL 10.3PostgreSQL 10.4PostgreSQL 9.6.9PostgreSQL 11.0 Beta 290K180K270K360K450KSE +/- 7191.89, N = 3SE +/- 2879.68, N = 3SE +/- 5028.23, N = 3SE +/- 4575.77, N = 3385532.97394697.62405330.21417754.75-lpq -lpthread-lpq -lpthread-fPIC-lpq -lpthread1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lrt -lcrypt -ldl -lm
OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 10.3Scaling: Buffer Test - Test: Normal Load - Mode: Read OnlyPostgreSQL 10.3PostgreSQL 10.4PostgreSQL 9.6.9PostgreSQL 11.0 Beta 270K140K210K280K350KMin: 372133.9 / Avg: 385532.97 / Max: 396762.22Min: 389158.88 / Avg: 394697.62 / Max: 398834.26Min: 395703.31 / Avg: 405330.21 / Max: 412661.88Min: 409257.75 / Avg: 417754.75 / Max: 424946.681. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lrt -lcrypt -ldl -lm

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
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 26K12K18K24K30KMin: 37056.33 / Avg: 37191.91 / Max: 37354.49Min: 36675.59 / Avg: 36737.54 / Max: 36784.22Min: 30821.67 / Avg: 31048.94 / Max: 31167.97Min: 24641.88 / Avg: 24758.61 / Max: 24826.191. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lrt -lcrypt -ldl -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 10.3Scaling: Buffer Test - Test: Single Thread - Mode: Read OnlyPostgreSQL 10.3PostgreSQL 10.4PostgreSQL 9.6.9PostgreSQL 11.0 Beta 23K6K9K12K15KSE +/- 111.85, N = 3SE +/- 87.97, N = 3SE +/- 47.43, N = 3SE +/- 97.15, N = 314467.1514404.2114847.8114800.23-lpq -lpthread-lpq -lpthread-fPIC-lpq -lpthread1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lrt -lcrypt -ldl -lm
OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 10.3Scaling: Buffer Test - Test: Single Thread - Mode: Read OnlyPostgreSQL 10.3PostgreSQL 10.4PostgreSQL 9.6.9PostgreSQL 11.0 Beta 23K6K9K12K15KMin: 14255.87 / Avg: 14467.15 / Max: 14636.41Min: 14303.01 / Avg: 14404.21 / Max: 14579.45Min: 14774.24 / Avg: 14847.81 / Max: 14936.45Min: 14675.29 / Avg: 14800.23 / Max: 14991.571. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lrt -lcrypt -ldl -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 10.3Scaling: Buffer Test - Test: Single Thread - Mode: Read WritePostgreSQL 10.3PostgreSQL 10.4PostgreSQL 9.6.9PostgreSQL 11.0 Beta 25001000150020002500SE +/- 7.49, N = 3SE +/- 28.41, N = 3SE +/- 22.44, N = 3SE +/- 9.94, N = 32081.432107.972045.732079.72-lpq -lpthread-lpq -lpthread-fPIC-lpq -lpthread1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lrt -lcrypt -ldl -lm
OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 10.3Scaling: Buffer Test - Test: Single Thread - Mode: Read WritePostgreSQL 10.3PostgreSQL 10.4PostgreSQL 9.6.9PostgreSQL 11.0 Beta 2400800120016002000Min: 2066.45 / Avg: 2081.43 / Max: 2089.14Min: 2066.88 / Avg: 2107.97 / Max: 2162.5Min: 2013.9 / Avg: 2045.73 / Max: 2089.03Min: 2060.84 / Avg: 2079.72 / Max: 2094.541. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lrt -lcrypt -ldl -lm