phoronix-pgbench-100_500

AMD EPYC 7313P 16-Core testing with a Supermicro H12SSW-NTR v1.02 (2.5 BIOS) and ASPEED on Rocky Linux 8.6 via the Phoronix Test Suite.

HTML result view exported from: https://openbenchmarking.org/result/2305150-NE-PHORONIXP23.

phoronix-pgbench-100_500ProcessorMotherboardChipsetMemoryDiskGraphicsNetworkOSKernelCompilerFile-SystemScreen ResolutionAMD EPYC 7313P 16-Core - ASPEED - SupermicroAMD EPYC 7313P 16-Core @ 3.00GHz (16 Cores / 32 Threads)Supermicro H12SSW-NTR v1.02 (2.5 BIOS)AMD Starship/Matisse8 x 32 GB DDR4-3200MT/s 18ASF4G72PDZ-3G2F13 x 3841GB KCM6XRUL3T84 + 2 x 960GB Micron_7450_MTFDKBA960TFRASPEED2 x Broadcom BCM57416 NetXtreme-E Dual-Media 10G RDMARocky Linux 8.64.18.0-372.32.1.el8_6.x86_64 (x86_64)GCC 8.5.0 20210514xfs1024x768OpenBenchmarking.org- Transparent Huge Pages: always- --build=x86_64-redhat-linux --disable-libmpx --disable-libunwind-exceptions --enable-__cxa_atexit --enable-bootstrap --enable-cet --enable-checking=release --enable-gnu-indirect-function --enable-gnu-unique-object --enable-initfini-array --enable-languages=c,c++,fortran,lto --enable-multilib --enable-offload-targets=nvptx-none --enable-plugin --enable-shared --enable-threads=posix --mandir=/usr/share/man --with-arch_32=x86-64 --with-gcc-major-version-only --with-isl --with-linker-hash-style=gnu --with-tune=generic --without-cuda-driver - Scaling Governor: acpi-cpufreq performance (Boost: Enabled) - CPU Microcode: 0xa001173 - 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 + srbds: Not affected + tsx_async_abort: Not affected

phoronix-pgbench-100_500pgbench: 100 - 500 - Read Onlypgbench: 100 - 500 - Read Only - Average Latencypgbench: 100 - 500 - Read Writepgbench: 100 - 500 - Read Write - Average LatencyAMD EPYC 7313P 16-Core - ASPEED - Supermicro10431420.4804116312.147OpenBenchmarking.org

PostgreSQL

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

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 15Scaling Factor: 100 - Clients: 500 - Mode: Read OnlyAMD EPYC 7313P 16-Core - ASPEED - Supermicro200K400K600K800K1000KSE +/- 6472.06, N = 310431421. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

PostgreSQL

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

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 15Scaling Factor: 100 - Clients: 500 - Mode: Read Only - Average LatencyAMD EPYC 7313P 16-Core - ASPEED - Supermicro0.1080.2160.3240.4320.54SE +/- 0.003, N = 30.4801. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

PostgreSQL

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

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 15Scaling Factor: 100 - Clients: 500 - Mode: Read WriteAMD EPYC 7313P 16-Core - ASPEED - Supermicro9K18K27K36K45KSE +/- 157.53, N = 3411631. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

PostgreSQL

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

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 15Scaling Factor: 100 - Clients: 500 - Mode: Read Write - Average LatencyAMD EPYC 7313P 16-Core - ASPEED - Supermicro3691215SE +/- 0.05, N = 312.151. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

Phoronix Test Suite v10.8.4