pgbench_beetroot2

X470

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

Statistics

Remove Outliers Before Calculating Averages

Graph Settings

Prefer Vertical Bar Graphs

Multi-Way Comparison

Condense Multi-Option Tests Into Single Result Graphs

Table

Show Detailed System Result Table

Run Management

Result
Identifier
Performance Per
Dollar
Date
Run
  Test
  Duration
pgbenchbeetroot
March 16 2021
  6 Minutes
Only show results matching title/arguments (delimit multiple options with a comma):
Do not show results matching title/arguments (delimit multiple options with a comma):

pgbenchbeetroot

Processor: AMD Ryzen 7 2700X Eight-Core @ 3.70GHz (8 Cores / 16 Threads), Motherboard: MSI X470 GAMING PLUS MAX (MS-7B79) v3.0 (H.60 BIOS), Chipset: AMD 17h, Memory: 32GB, Disk: Samsung SSD 970 EVO 500GB, Graphics: Sapphire AMD Radeon RX 470/480/570/570X/580/580X 8GB (1366/2000MHz), Audio: AMD Ellesmere, Monitor: LG Ultra HD, Network: Realtek RTL8111/8168/8411 + Mellanox MT27500 + Intel 7265

OS: Ubuntu 18.04, Kernel: 5.3.0-7648-generic (x86_64), Desktop: GNOME Shell 3.28.4, Display Server: X Server 1.20.8, OpenGL: 4.6 Mesa 20.0.8 (LLVM 10.0.0), OpenCL: OpenCL 2.1 AMD-APP (3110.6), Vulkan: 1.2.128, Compiler: GCC 7.5.0 + CUDA 9.2, File-System: ext4, Screen Resolution: 3840x2160

Kernel Notes: amdgpu.ppfeaturemask=0xffffffff - Transparent Huge Pages: madvise
Compiler Notes: --build=x86_64-linux-gnu --disable-vtable-verify --disable-werror --enable-bootstrap --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 performance (Boost: Enabled) - CPU Microcode: 0x800820d
Security Notes: itlb_multihit: Not affected + l1tf: Not affected + mds: Not affected + meltdown: Not affected + spec_store_bypass: Mitigation of SSB disabled via prctl and seccomp + spectre_v1: Mitigation of usercopy/swapgs barriers and __user pointer sanitization + spectre_v2: Mitigation of Full AMD retpoline IBPB: conditional STIBP: disabled RSB filling + tsx_async_abort: Not affected

pgbench_beetroot2OpenBenchmarking.orgPhoronix Test SuiteAMD Ryzen 7 2700X Eight-Core @ 3.70GHz (8 Cores / 16 Threads)MSI X470 GAMING PLUS MAX (MS-7B79) v3.0 (H.60 BIOS)AMD 17h32GBSamsung SSD 970 EVO 500GBSapphire AMD Radeon RX 470/480/570/570X/580/580X 8GB (1366/2000MHz)AMD EllesmereLG Ultra HDRealtek RTL8111/8168/8411 + Mellanox MT27500 + Intel 7265Ubuntu 18.045.3.0-7648-generic (x86_64)GNOME Shell 3.28.4X Server 1.20.84.6 Mesa 20.0.8 (LLVM 10.0.0)OpenCL 2.1 AMD-APP (3110.6)1.2.128GCC 7.5.0 + CUDA 9.2ext43840x2160ProcessorMotherboardChipsetMemoryDiskGraphicsAudioMonitorNetworkOSKernelDesktopDisplay ServerOpenGLOpenCLVulkanCompilerFile-SystemScreen ResolutionPgbench_beetroot2 BenchmarksSystem Logs- amdgpu.ppfeaturemask=0xffffffff - Transparent Huge Pages: madvise- --build=x86_64-linux-gnu --disable-vtable-verify --disable-werror --enable-bootstrap --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 performance (Boost: Enabled) - CPU Microcode: 0x800820d- itlb_multihit: Not affected + l1tf: Not affected + mds: Not affected + meltdown: Not affected + spec_store_bypass: Mitigation of SSB disabled via prctl and seccomp + spectre_v1: Mitigation of usercopy/swapgs barriers and __user pointer sanitization + spectre_v2: Mitigation of Full AMD retpoline IBPB: conditional STIBP: disabled RSB filling + tsx_async_abort: Not affected

pgbench_beetroot2pgbench: 1 - 1 - Read Onlypgbench: 1 - 1 - Read Only - Average Latencypgbench: 1 - 1 - Read Writepgbench: 1 - 1 - Read Write - Average Latencypgbenchbeetroot180170.0558211.218OpenBenchmarking.org

PostgreSQL pgbench

This is a benchmark of PostgreSQL using pgbench for facilitating the database benchmarks. Learn more via the OpenBenchmarking.org test page.

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 13.0Scaling Factor: 1 - Clients: 1 - Mode: Read Onlypgbenchbeetroot4K8K12K16K20KSE +/- 130.02, N = 3180171. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL pgbench 13.0Scaling Factor: 1 - Clients: 1 - Mode: Read Only - Average Latencypgbenchbeetroot0.01240.02480.03720.04960.062SE +/- 0.000, N = 30.0551. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 13.0Scaling Factor: 1 - Clients: 1 - Mode: Read Writepgbenchbeetroot2004006008001000SE +/- 1.43, N = 38211. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL pgbench 13.0Scaling Factor: 1 - Clients: 1 - Mode: Read Write - Average Latencypgbenchbeetroot0.27410.54820.82231.09641.3705SE +/- 0.002, N = 31.2181. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

pgbenchbeetroot

Processor: AMD Ryzen 7 2700X Eight-Core @ 3.70GHz (8 Cores / 16 Threads), Motherboard: MSI X470 GAMING PLUS MAX (MS-7B79) v3.0 (H.60 BIOS), Chipset: AMD 17h, Memory: 32GB, Disk: Samsung SSD 970 EVO 500GB, Graphics: Sapphire AMD Radeon RX 470/480/570/570X/580/580X 8GB (1366/2000MHz), Audio: AMD Ellesmere, Monitor: LG Ultra HD, Network: Realtek RTL8111/8168/8411 + Mellanox MT27500 + Intel 7265

OS: Ubuntu 18.04, Kernel: 5.3.0-7648-generic (x86_64), Desktop: GNOME Shell 3.28.4, Display Server: X Server 1.20.8, OpenGL: 4.6 Mesa 20.0.8 (LLVM 10.0.0), OpenCL: OpenCL 2.1 AMD-APP (3110.6), Vulkan: 1.2.128, Compiler: GCC 7.5.0 + CUDA 9.2, File-System: ext4, Screen Resolution: 3840x2160

Kernel Notes: amdgpu.ppfeaturemask=0xffffffff - Transparent Huge Pages: madvise
Compiler Notes: --build=x86_64-linux-gnu --disable-vtable-verify --disable-werror --enable-bootstrap --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 performance (Boost: Enabled) - CPU Microcode: 0x800820d
Security Notes: itlb_multihit: Not affected + l1tf: Not affected + mds: Not affected + meltdown: Not affected + spec_store_bypass: Mitigation of SSB disabled via prctl and seccomp + spectre_v1: Mitigation of usercopy/swapgs barriers and __user pointer sanitization + spectre_v2: Mitigation of Full AMD retpoline IBPB: conditional STIBP: disabled RSB filling + tsx_async_abort: Not affected

Testing initiated at 16 March 2021 16:33 by user beetroot.