pgbench-results

Intel Core i5-6600K testing with a Gigabyte Z170XP-SLI-CF (F22f BIOS) and eVGA NVIDIA GeForce GTX 1060 6GB on ManjaroLinux 20.2.1 via the Phoronix Test Suite.

HTML result view exported from: https://openbenchmarking.org/result/2103123-HA-2103125HA75.

pgbench-resultsProcessorMotherboardChipsetMemoryDiskGraphicsAudioMonitorNetworkOSKernelDisplay ServerCompilerFile-SystemScreen ResolutionDesktopDisplay DriverIntel Xeon Silver 4210R - AMD Radeon PRO WX 3200 -Intel Core i5-6600K - eVGA NVIDIA GeForce GTX 1060Intel Xeon Silver 4210R @ 3.20GHz (10 Cores / 20 Threads)Dell 0804P1 (2.12.0 BIOS)Intel Sky Lake-E DMI3 Registers32GBPM981a NVMe Samsung 1024GB + 1000GB Western Digital WD10EZEX-75W + 16GB USB 2.0 FD + 0GB SD/MMC CRWAMD Radeon PRO WX 3200 (1295/1500MHz)Realtek ALC3234DELL P1913SIntel I219-LMArch Linux5.11.2-arch1-1 (x86_64)X Server 1.20.10GCC 10.2.0xfs1280x1024Intel Core i5-6600K @ 3.90GHz (4 Cores)Gigabyte Z170XP-SLI-CF (F22f BIOS)Intel Xeon E3-1200 v5/E3-150016GB512GB INTEL SSDPEKNW512G8eVGA NVIDIA GeForce GTX 1060 6GBRealtek ALC1150Intel I219-V + 2 x Intel 82599ES 10-Gigabit SFI/SFP+ManjaroLinux 20.2.15.4.101-1-MANJARO (x86_64)Cinnamon 4.8.6NVIDIAGCC 10.2.0 + Clang 11.1.0 + LLVM 11.1.0ext41024x768OpenBenchmarking.orgKernel Details- Transparent Huge Pages: madviseCompiler Details- --disable-libssp --disable-libstdcxx-pch --disable-libunwind-exceptions --disable-werror --enable-__cxa_atexit --enable-cet=auto --enable-checking=release --enable-clocale=gnu --enable-default-pie --enable-default-ssp --enable-gnu-indirect-function --enable-gnu-unique-object --enable-install-libiberty --enable-languages=c,c++,ada,fortran,go,lto,objc,obj-c++,d --enable-lto --enable-multilib --enable-plugin --enable-shared --enable-threads=posix --mandir=/usr/share/man --with-isl --with-linker-hash-style=gnu Processor Details- Intel Xeon Silver 4210R - AMD Radeon PRO WX 3200 -: Scaling Governor: intel_pstate powersave - CPU Microcode: 0x5003006- Intel Core i5-6600K - eVGA NVIDIA GeForce GTX 1060: Scaling Governor: intel_pstate powersave - CPU Microcode: 0xe2Security Details- Intel Xeon Silver 4210R - AMD Radeon PRO WX 3200 -: itlb_multihit: KVM: Mitigation of VMX disabled + l1tf: Not affected + mds: Not affected + meltdown: 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 + srbds: Not affected + tsx_async_abort: Mitigation of TSX disabled - Intel Core i5-6600K - eVGA NVIDIA GeForce GTX 1060: itlb_multihit: KVM: Mitigation of Split huge pages + l1tf: Mitigation of PTE Inversion; VMX: conditional cache flushes SMT disabled + mds: Mitigation of Clear buffers; SMT disabled + meltdown: Mitigation of PTI + 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 Full generic retpoline IBPB: conditional IBRS_FW STIBP: disabled RSB filling + srbds: Mitigation of Microcode + tsx_async_abort: Mitigation of Clear buffers; SMT disabled

pgbench-resultspgbench: 1 - 50 - Read Writepgbench: 1 - 50 - Read Write - Average LatencyIntel Xeon Silver 4210R - AMD Radeon PRO WX 3200 -Intel Core i5-6600K - eVGA NVIDIA GeForce GTX 106069472.08667873.784OpenBenchmarking.org

PostgreSQL pgbench

Scaling Factor: 1 - Clients: 50 - Mode: Read Write

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 13.0Scaling Factor: 1 - Clients: 50 - Mode: Read WriteIntel Xeon Silver 4210R - AMD Radeon PRO WX 3200 -Intel Core i5-6600K - eVGA NVIDIA GeForce GTX 1060150300450600750SE +/- 2.19, N = 3SE +/- 4.76, N = 36946781. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

PostgreSQL pgbench

Scaling Factor: 1 - Clients: 50 - Mode: Read Write - Average Latency

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL pgbench 13.0Scaling Factor: 1 - Clients: 50 - Mode: Read Write - Average LatencyIntel Xeon Silver 4210R - AMD Radeon PRO WX 3200 -Intel Core i5-6600K - eVGA NVIDIA GeForce GTX 10601632486480SE +/- 0.23, N = 3SE +/- 0.52, N = 372.0973.781. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm


Phoronix Test Suite v10.8.4