pgbench_selective

Intel Core i7-8850H testing with a Dell 0WCMKT (1.7.3 BIOS) and Intel UHD 630 3GB on Fedora 32 via the Phoronix Test Suite.

HTML result view exported from: https://openbenchmarking.org/result/2011150-AS-PGBENCHSE23.

pgbench_selectiveProcessorMotherboardChipsetMemoryDiskGraphicsAudioNetworkOSKernelDesktopDisplay ServerOpenGLCompilerFile-SystemScreen ResolutionIntel Core i7-8850H - Intel UHD 630 3GB - Dell 0WCMKTIntel Core i7-8850H @ 4.30GHz (6 Cores / 12 Threads)Dell 0WCMKT (1.7.3 BIOS)Intel Cannon Lake PCH16384MBPM981 NVMe Samsung 512GB + 31GB Ultra USB 3.0Intel UHD 630 3GB (1150MHz)Realtek ALC3246Intel I219-LM + Qualcomm Atheros QCA6174 802.11acFedora 325.7.8-201.camflow.fc32.x86_64 (x86_64)GNOME Shell 3.36.1X Server + Wayland4.6 Mesa 20.0.4GCC 10.0.1 20200328ext41920x1080OpenBenchmarking.org- MFLAGS= MAKEFLAGS=- --build=x86_64-redhat-linux --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,objc,obj-c++,ada,go,d,lto --enable-multilib --enable-offload-targets=nvptx-none --enable-plugin --enable-shared --enable-threads=posix --mandir=/usr/share/man --with-arch_32=i686 --with-gcc-major-version-only --with-isl --with-linker-hash-style=gnu --with-tune=generic --without-cuda-driver - Scaling Governor: intel_pstate powersave- SELinux + itlb_multihit: KVM: Mitigation of Split huge pages + l1tf: Mitigation of PTE Inversion; VMX: conditional cache flushes SMT vulnerable + mds: Mitigation of Clear buffers; SMT vulnerable + 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: conditional RSB filling + srbds: Vulnerable: No microcode + tsx_async_abort: Mitigation of Clear buffers; SMT vulnerable

pgbench_selectivepgbench: Buffer Test - Single Thread - Read Onlypgbench: Buffer Test - Single Thread - Read WriteIntel Core i7-8850H - Intel UHD 630 3GB - Dell 0WCMKT22499.99377.29OpenBenchmarking.org

PostgreSQL pgbench

Scaling: Buffer Test - Test: Single Thread - Mode: Read Only

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 9.4.3Scaling: Buffer Test - Test: Single Thread - Mode: Read OnlyIntel Core i7-8850H - Intel UHD 630 3GB - Dell 0WCMKT5K10K15K20K25KSE +/- 249.45, N = 1322499.991. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -pthread -lpgcommon -lpgport -lpq -lpthread -lrt -lcrypt -ldl -lm

PostgreSQL pgbench

Scaling: Buffer Test - Test: Single Thread - Mode: Read Write

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 9.4.3Scaling: Buffer Test - Test: Single Thread - Mode: Read WriteIntel Core i7-8850H - Intel UHD 630 3GB - Dell 0WCMKT80160240320400SE +/- 4.03, N = 15377.291. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -pthread -lpgcommon -lpgport -lpq -lpthread -lrt -lcrypt -ldl -lm

Phoronix Test Suite v10.8.4