5950x_pgbench

Docker testing on Ubuntu 20.04.4 LTS via the Phoronix Test Suite.

HTML result view exported from: https://openbenchmarking.org/result/2307180-NE-2307168NE34.

5950x_pgbenchProcessorMotherboardChipsetMemoryDiskGraphicsAudioMonitorNetworkOSKernelDisplay ServerDisplay DriverOpenGLCompilerFile-SystemScreen ResolutionSystem Layer5950x Arch LinuxEBS-GP3AMD Ryzen 9 5950X 16-Core @ 3.40GHz (16 Cores / 32 Threads)ASUS PRIME X570-PRO (4802 BIOS)AMD Starship/Matisse128GB2000GB Samsung SSD 970 EVO Plus 2TB + Samsung SSD 950 PRO 512GB + 2 x 2000GB Samsung SSD 980 PRO 2TBeVGA NVIDIA GeForce RTX 2080 8GBNVIDIA TU104 HD AudioDell S2716DGIntel I211Arch rolling6.4.3-zen1-1-zen (x86_64)X Server 1.21.1.8NVIDIA 535.54.034.6.0GCC 13.1.1 20230429 + Clang 15.0.7 + CUDA 12.2ext45120x1440AMD EPYC 7571 (4 Cores / 8 Threads)Amazon EC2 t3a.2xlarge (1.0 BIOS)32GB322GB Amazon Elastic Block StoreUbuntu 20.04.4 LTS5.4.0-1103-aws (x86_64)GCC 9.4.0aufsDockerOpenBenchmarking.orgKernel Details- 5950x Arch Linux: Transparent Huge Pages: always- EBS-GP3: Transparent Huge Pages: madviseCompiler Details- 5950x Arch Linux: --disable-libssp --disable-libstdcxx-pch --disable-werror --enable-__cxa_atexit --enable-bootstrap --enable-cet=auto --enable-checking=release --enable-clocale=gnu --enable-default-pie --enable-default-ssp --enable-gnu-indirect-function --enable-gnu-unique-object --enable-languages=ada,c,c++,d,fortran,go,lto,objc,obj-c++ --enable-libstdcxx-backtrace --enable-link-serialization=1 --enable-lto --enable-multilib --enable-plugin --enable-shared --enable-threads=posix --mandir=/usr/share/man --with-build-config=bootstrap-lto --with-linker-hash-style=gnu - EBS-GP3: --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++,gm2 --enable-libstdcxx-debug --enable-libstdcxx-time=yes --enable-multiarch --enable-multilib --enable-nls --enable-objc-gc=auto --enable-offload-targets=nvptx-none=/build/gcc-9-Av3uEd/gcc-9-9.4.0/debian/tmp-nvptx/usr,hsa --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=auto --with-tune=generic --without-cuda-driver -v Processor Details- 5950x Arch Linux: Scaling Governor: acpi-cpufreq schedutil (Boost: Enabled) - CPU Microcode: 0xa20120a- EBS-GP3: CPU Microcode: 0x800126eSecurity Details- 5950x Arch Linux: itlb_multihit: Not affected + l1tf: Not affected + mds: Not affected + meltdown: Not affected + mmio_stale_data: Not affected + retbleed: Not affected + spec_store_bypass: Mitigation of SSB disabled via prctl + spectre_v1: Mitigation of usercopy/swapgs barriers and __user pointer sanitization + spectre_v2: Mitigation of Retpolines IBPB: conditional IBRS_FW STIBP: always-on RSB filling PBRSB-eIBRS: Not affected + srbds: Not affected + tsx_async_abort: Not affected - EBS-GP3: itlb_multihit: Not affected + l1tf: Not affected + mds: Not affected + meltdown: Not affected + mmio_stale_data: Not affected + retbleed: Vulnerable + spec_store_bypass: Vulnerable + spectre_v1: Mitigation of usercopy/swapgs barriers and __user pointer sanitization + spectre_v2: Mitigation of Retpolines STIBP: disabled RSB filling PBRSB-eIBRS: Not affected + srbds: Not affected + tsx_async_abort: Not affected

5950x_pgbenchpgbench: 100 - 100 - Read Onlypgbench: 100 - 100 - Read Only - Average Latencypgbench: 100 - 100 - Read Writepgbench: 100 - 100 - Read Write - Average Latency5950x Arch LinuxEBS-GP311554640.086117668.499890891.123549518.388OpenBenchmarking.org

PostgreSQL

Scaling Factor: 100 - Clients: 100 - Mode: Read Only

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 15Scaling Factor: 100 - Clients: 100 - Mode: Read Only5950x Arch LinuxEBS-GP3200K400K600K800K1000KSE +/- 4094.18, N = 3SE +/- 1076.28, N = 31155464890891. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

PostgreSQL

Scaling Factor: 100 - Clients: 100 - Mode: Read Only - Average Latency

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 15Scaling Factor: 100 - Clients: 100 - Mode: Read Only - Average Latency5950x Arch LinuxEBS-GP30.25270.50540.75811.01081.2635SE +/- 0.000, N = 3SE +/- 0.014, N = 30.0861.123-lpthread -lrt -ldl1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

PostgreSQL

Scaling Factor: 100 - Clients: 100 - Mode: Read Write

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 15Scaling Factor: 100 - Clients: 100 - Mode: Read Write5950x Arch LinuxEBS-GP33K6K9K12K15KSE +/- 20.85, N = 3SE +/- 150.14, N = 12117665495-lpthread -lrt -ldl1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

PostgreSQL

Scaling Factor: 100 - Clients: 100 - Mode: Read Write - Average Latency

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 15Scaling Factor: 100 - Clients: 100 - Mode: Read Write - Average Latency5950x Arch LinuxEBS-GP3510152025SE +/- 0.015, N = 3SE +/- 0.634, N = 128.49918.388-lpthread -lrt -ldl1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

Phoronix Test Suite v10.8.4