pgbench-001

AMD Ryzen 9 7950X 16-Core testing with a ASRock X670E Pro RS (1.03 BIOS) and eVGA NVIDIA GeForce GTX 1060 6GB on Ubuntu 22.04 via the Phoronix Test Suite.

HTML result view exported from: https://openbenchmarking.org/result/2301195-NE-PGBENCH0037&grr.

pgbench-001ProcessorMotherboardChipsetMemoryDiskGraphicsAudioMonitorNetworkOSKernelDesktopDisplay ServerDisplay DriverOpenGLVulkanCompilerFile-SystemScreen ResolutionAMD Ryzen 9 7950X 16-Core - eVGA NVIDIA GeForce GTXAMD Ryzen 9 7950X 16-Core @ 5.88GHz (16 Cores / 32 Threads)ASRock X670E Pro RS (1.03 BIOS)AMD Device 14d8128GB2 x 2048GB KINGSTON SKC3000D2048G + 1920GB SDLF1CRR-019T-1HeVGA NVIDIA GeForce GTX 1060 6GBNVIDIA GP106 HD AudioLEN T27i-10Realtek RTL8125 2.5GbE + MEDIATEK Device 0616Ubuntu 22.045.15.0-58-generic (x86_64)GNOME Shell 42.5X Server 1.21.1.3 + Waylandnouveau4.3 Mesa 22.0.51.2.204GCC 11.3.0ext41920x1080OpenBenchmarking.org- Transparent Huge Pages: madvise- --build=x86_64-linux-gnu --disable-vtable-verify --disable-werror --enable-bootstrap --enable-cet --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++,m2 --enable-libphobos-checking=release --enable-libstdcxx-debug --enable-libstdcxx-time=yes --enable-link-serialization=2 --enable-multiarch --enable-multilib --enable-nls --enable-objc-gc=auto --enable-offload-targets=nvptx-none=/build/gcc-11-xKiWfi/gcc-11-11.3.0/debian/tmp-nvptx/usr,amdgcn-amdhsa=/build/gcc-11-xKiWfi/gcc-11-11.3.0/debian/tmp-gcn/usr --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-build-config=bootstrap-lto-lean --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 - Scaling Governor: amd-pstate schedutil (Boost: Enabled) - CPU Microcode: 0xa601201 - 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 and seccomp + 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

pgbench-001pgbench: 1 - 500 - Read Only - Average Latencypgbench: 1 - 500 - Read OnlyAMD Ryzen 9 7950X 16-Core - eVGA NVIDIA GeForce GTX0.2681865446OpenBenchmarking.org

PostgreSQL

Scaling Factor: 1 - Clients: 500 - Mode: Read Only - Average Latency

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 15Scaling Factor: 1 - Clients: 500 - Mode: Read Only - Average LatencyAMD Ryzen 9 7950X 16-Core - eVGA NVIDIA GeForce GTX0.06030.12060.18090.24120.3015SE +/- 0.002, N = 30.2681. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

PostgreSQL

Scaling Factor: 1 - Clients: 500 - Mode: Read Only

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 15Scaling Factor: 1 - Clients: 500 - Mode: Read OnlyAMD Ryzen 9 7950X 16-Core - eVGA NVIDIA GeForce GTX400K800K1200K1600K2000KSE +/- 11629.69, N = 318654461. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

Phoronix Test Suite v10.8.5