pgbench_results

AMD Ryzen 7 5700G testing with a GIGABYTE MC12-LE0-00 v01000100 (F13 BIOS) and ASPEED on Ubuntu 24.04 via the Phoronix Test Suite.

HTML result view exported from: https://openbenchmarking.org/result/2410296-NE-PGBENCHRE84&grr.

pgbench_resultsProcessorMotherboardChipsetMemoryDiskGraphicsAudioMonitorNetworkOSKernelCompilerFile-SystemScreen ResolutionAMD Ryzen 7 5700G - ASPEED - GIGABYTE MC12-LE0-00AMD Ryzen 7 5700G @ 4.67GHz (8 Cores / 16 Threads)GIGABYTE MC12-LE0-00 v01000100 (F13 BIOS)AMD Renoir/Cezanne4 x 16 GB DDR4-2133MT/s CMK32GX4M2D3600C18400GB INTEL SSDPEDMD400G4 + 2 x 1000GB Western Digital WD1003FBYX-0ASPEEDAMD 17h/19hA201P12 x Intel I210Ubuntu 24.046.8.0-47-generic (x86_64)GCC 13.2.0ext41280x1024OpenBenchmarking.org- Transparent Huge Pages: madvise- --build=x86_64-linux-gnu --disable-vtable-verify --disable-werror --enable-cet --enable-checking=release --enable-clocale=gnu --enable-default-pie --enable-gnu-unique-object --enable-languages=c,ada,c++,go,d,fortran,objc,obj-c++,m2 --enable-libphobos-checking=release --enable-libstdcxx-backtrace --enable-libstdcxx-debug --enable-libstdcxx-time=yes --enable-multiarch --enable-multilib --enable-nls --enable-objc-gc=auto --enable-offload-defaulted --enable-offload-targets=nvptx-none=/build/gcc-13-uJ7kn6/gcc-13-13.2.0/debian/tmp-nvptx/usr,amdgcn-amdhsa=/build/gcc-13-uJ7kn6/gcc-13-13.2.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-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-epp powersave (EPP: performance) - CPU Microcode: 0xa50000f - gather_data_sampling: Not affected + itlb_multihit: Not affected + l1tf: Not affected + mds: Not affected + meltdown: Not affected + mmio_stale_data: Not affected + reg_file_data_sampling: Not affected + retbleed: Not affected + spec_rstack_overflow: Mitigation of Safe RET + 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; BHI: Not affected + srbds: Not affected + tsx_async_abort: Not affected

pgbench_resultspgbench: 10000 - 1000 - Read Write - Average Latencypgbench: 10000 - 1000 - Read Writepgbench: 10000 - 1000 - Read Only - Average Latencypgbench: 10000 - 1000 - Read OnlyAMD Ryzen 7 5700G - ASPEED - GIGABYTE MC12-LE0-00126.054793610.12298798OpenBenchmarking.org

PostgreSQL

Scaling Factor: 10000 - Clients: 1000 - Mode: Read Write - Average Latency

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 17Scaling Factor: 10000 - Clients: 1000 - Mode: Read Write - Average LatencyAMD Ryzen 7 5700G - ASPEED - GIGABYTE MC12-LE0-00306090120150SE +/- 1.46, N = 4126.051. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpq -lpgcommon -lpgport -lm

PostgreSQL

Scaling Factor: 10000 - Clients: 1000 - Mode: Read Write

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 17Scaling Factor: 10000 - Clients: 1000 - Mode: Read WriteAMD Ryzen 7 5700G - ASPEED - GIGABYTE MC12-LE0-002K4K6K8K10KSE +/- 93.38, N = 479361. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpq -lpgcommon -lpgport -lm

PostgreSQL

Scaling Factor: 10000 - Clients: 1000 - Mode: Read Only - Average Latency

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 17Scaling Factor: 10000 - Clients: 1000 - Mode: Read Only - Average LatencyAMD Ryzen 7 5700G - ASPEED - GIGABYTE MC12-LE0-003691215SE +/- 0.02, N = 310.121. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpq -lpgcommon -lpgport -lm

PostgreSQL

Scaling Factor: 10000 - Clients: 1000 - Mode: Read Only

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 17Scaling Factor: 10000 - Clients: 1000 - Mode: Read OnlyAMD Ryzen 7 5700G - ASPEED - GIGABYTE MC12-LE0-0020K40K60K80K100KSE +/- 154.94, N = 3987981. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpq -lpgcommon -lpgport -lm

Phoronix Test Suite v10.8.5