SQLTESTS_DELL_22042024_2046hrs

Intel Xeon Gold 5416S testing with a Dell 075K3T (1.8.0 BIOS) and Matrox G200eW3 on Ubuntu 22.04 via the Phoronix Test Suite.

HTML result view exported from: https://openbenchmarking.org/result/2404226-NE-SQLTESTSD78&grt.

SQLTESTS_DELL_22042024_2046hrsProcessorMotherboardChipsetMemoryDiskGraphicsMonitorNetworkOSKernelVulkanCompilerFile-SystemScreen ResolutionIntel Xeon Gold 5416S - Matrox G200eW3 - Dell 075K3TIntel Xeon Gold 5416S (16 Cores / 32 Threads)Dell 075K3T (1.8.0 BIOS)Intel Device 1bce64GB2 x 480GB Dell BOSS-N1 + 4 x 800GB KPM7XVUG800GMatrox G200eW3DELL MR24164 x Broadcom NetXtreme BCM5720 PCIe + 4 x Broadcom BCM57504 NetXtreme-E 10Gb/25Gb/40Gb/50Gb/100Gb/200GbUbuntu 22.045.15.0-105-generic (x86_64)1.3.255GCC 11.4.0ext41920x1200OpenBenchmarking.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-XeT9lY/gcc-11-11.4.0/debian/tmp-nvptx/usr,amdgcn-amdhsa=/build/gcc-11-XeT9lY/gcc-11-11.4.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 - CPU Microcode: 0x2b000571- gather_data_sampling: Not affected + itlb_multihit: Not affected + l1tf: Not affected + mds: Not affected + meltdown: Not affected + mmio_stale_data: Not affected + retbleed: Not affected + spec_rstack_overflow: 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 Enhanced IBRS IBPB: conditional RSB filling PBRSB-eIBRS: SW sequence + srbds: Not affected + tsx_async_abort: Not affected

SQLTESTS_DELL_22042024_2046hrspgbench: 1000 - 500 - Read Onlypgbench: 1000 - 500 - Read Only - Average Latencypgbench: 1000 - 500 - Read Writepgbench: 1000 - 500 - Read Write - Average Latencyredis: GET - 1000redis: SET - 1000redis: LPOP - 1000redis: SADD - 1000redis: LPUSH - 1000sysbench: RAM / Memorysysbench: CPUIntel Xeon Gold 5416S - Matrox G200eW3 - Dell 075K3T7627660.6551755928.4773180539.442153040.333173407.752450870.021914850.6714409.5840041.63OpenBenchmarking.org

PostgreSQL

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

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 16Scaling Factor: 1000 - Clients: 500 - Mode: Read OnlyIntel Xeon Gold 5416S - Matrox G200eW3 - Dell 075K3T160K320K480K640K800KSE +/- 1004.85, N = 37627661. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

PostgreSQL

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

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 16Scaling Factor: 1000 - Clients: 500 - Mode: Read Only - Average LatencyIntel Xeon Gold 5416S - Matrox G200eW3 - Dell 075K3T0.14740.29480.44220.58960.737SE +/- 0.001, N = 30.6551. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

PostgreSQL

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

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 16Scaling Factor: 1000 - Clients: 500 - Mode: Read WriteIntel Xeon Gold 5416S - Matrox G200eW3 - Dell 075K3T4K8K12K16K20KSE +/- 84.30, N = 3175591. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

PostgreSQL

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

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 16Scaling Factor: 1000 - Clients: 500 - Mode: Read Write - Average LatencyIntel Xeon Gold 5416S - Matrox G200eW3 - Dell 075K3T714212835SE +/- 0.14, N = 328.481. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

Redis

Test: GET - Parallel Connections: 1000

OpenBenchmarking.orgRequests Per Second, More Is BetterRedis 7.0.4Test: GET - Parallel Connections: 1000Intel Xeon Gold 5416S - Matrox G200eW3 - Dell 075K3T700K1400K2100K2800K3500KSE +/- 29557.67, N = 123180539.441. (CXX) g++ options: -MM -MT -g3 -fvisibility=hidden -O3

Redis

Test: SET - Parallel Connections: 1000

OpenBenchmarking.orgRequests Per Second, More Is BetterRedis 7.0.4Test: SET - Parallel Connections: 1000Intel Xeon Gold 5416S - Matrox G200eW3 - Dell 075K3T500K1000K1500K2000K2500KSE +/- 3995.45, N = 32153040.331. (CXX) g++ options: -MM -MT -g3 -fvisibility=hidden -O3

Redis

Test: LPOP - Parallel Connections: 1000

OpenBenchmarking.orgRequests Per Second, More Is BetterRedis 7.0.4Test: LPOP - Parallel Connections: 1000Intel Xeon Gold 5416S - Matrox G200eW3 - Dell 075K3T700K1400K2100K2800K3500KSE +/- 33033.84, N = 33173407.751. (CXX) g++ options: -MM -MT -g3 -fvisibility=hidden -O3

Redis

Test: SADD - Parallel Connections: 1000

OpenBenchmarking.orgRequests Per Second, More Is BetterRedis 7.0.4Test: SADD - Parallel Connections: 1000Intel Xeon Gold 5416S - Matrox G200eW3 - Dell 075K3T500K1000K1500K2000K2500KSE +/- 18212.14, N = 152450870.021. (CXX) g++ options: -MM -MT -g3 -fvisibility=hidden -O3

Redis

Test: LPUSH - Parallel Connections: 1000

OpenBenchmarking.orgRequests Per Second, More Is BetterRedis 7.0.4Test: LPUSH - Parallel Connections: 1000Intel Xeon Gold 5416S - Matrox G200eW3 - Dell 075K3T400K800K1200K1600K2000KSE +/- 9042.37, N = 31914850.671. (CXX) g++ options: -MM -MT -g3 -fvisibility=hidden -O3

Sysbench

Test: RAM / Memory

OpenBenchmarking.orgMiB/sec, More Is BetterSysbench 1.0.20Test: RAM / MemoryIntel Xeon Gold 5416S - Matrox G200eW3 - Dell 075K3T3K6K9K12K15KSE +/- 59.37, N = 314409.581. (CC) gcc options: -O2 -funroll-loops -rdynamic -ldl -laio -lm

Sysbench

Test: CPU

OpenBenchmarking.orgEvents Per Second, More Is BetterSysbench 1.0.20Test: CPUIntel Xeon Gold 5416S - Matrox G200eW3 - Dell 075K3T9K18K27K36K45KSE +/- 0.85, N = 340041.631. (CC) gcc options: -O2 -funroll-loops -rdynamic -ldl -laio -lm

Phoronix Test Suite v10.8.5