testpgbench

Intel Core i9-10900K testing with a ASUS ROG STRIX Z490-F GAMING (1003 BIOS) and Gigabyte NVIDIA GeForce RTX 2080 Ti 11GB on Ubuntu 20.04 via the Phoronix Test Suite.

HTML result view exported from: https://openbenchmarking.org/result/2103212-HA-TESTPGBEN98.

testpgbenchProcessorMotherboardChipsetMemoryDiskGraphicsAudioMonitorNetworkOSKernelDesktopDisplay ServerDisplay DriverOpenGLOpenCLVulkanCompilerFile-SystemScreen ResolutionIntel Core i9-10900K - Gigabyte NVIDIA GeForce RTXIntel Core i9-10900K @ 5.30GHz (10 Cores / 20 Threads)ASUS ROG STRIX Z490-F GAMING (1003 BIOS)Intel Comet Lake PCH2 x 16384 MB DDR4-3600MT/s1000GB AS Velocity G4 1TB + 1000GB Western Digital WD10EZEX-00WGigabyte NVIDIA GeForce RTX 2080 Ti 11GBRealtek ALC1220X315 PROIntel Device 15f3 + Intel Wi-Fi 6 AX200Ubuntu 20.045.8.0-45-generic (x86_64)GNOME Shell 3.36.4X Server 1.20.9NVIDIA 460.394.6.0OpenCL 1.2 CUDA 11.2.1361.2.155GCC 9.3.0ext42560x1440OpenBenchmarking.org- Transparent Huge Pages: madvise- --build=x86_64-linux-gnu --disable-vtable-verify --disable-werror --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++,gm2 --enable-libstdcxx-debug --enable-libstdcxx-time=yes --enable-multiarch --enable-multilib --enable-nls --enable-objc-gc=auto --enable-offload-targets=nvptx-none=/build/gcc-9-HskZEa/gcc-9-9.3.0/debian/tmp-nvptx/usr,hsa --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: intel_pstate powersave - CPU Microcode: 0xe2 - Thermald 1.9.1- itlb_multihit: KVM: Mitigation of VMX unsupported + 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: Not affected

testpgbenchpgbench: 1000 - 250 - Read Onlypgbench: 1000 - 250 - Read Only - Average Latencypgbench: 1000 - 250 - Read Writepgbench: 1000 - 250 - Read Write - Average LatencyIntel Core i9-10900K - Gigabyte NVIDIA GeForce RTX2574100.972481659.161OpenBenchmarking.org

PostgreSQL pgbench

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

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 13.0Scaling Factor: 1000 - Clients: 250 - Mode: Read OnlyIntel Core i9-10900K - Gigabyte NVIDIA GeForce RTX60K120K180K240K300KSE +/- 1161.45, N = 32574101. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

PostgreSQL pgbench

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

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL pgbench 13.0Scaling Factor: 1000 - Clients: 250 - Mode: Read Only - Average LatencyIntel Core i9-10900K - Gigabyte NVIDIA GeForce RTX0.21870.43740.65610.87481.0935SE +/- 0.004, N = 30.9721. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

PostgreSQL pgbench

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

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 13.0Scaling Factor: 1000 - Clients: 250 - Mode: Read WriteIntel Core i9-10900K - Gigabyte NVIDIA GeForce RTX10002000300040005000SE +/- 733.64, N = 948161. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

PostgreSQL pgbench

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

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL pgbench 13.0Scaling Factor: 1000 - Clients: 250 - Mode: Read Write - Average LatencyIntel Core i9-10900K - Gigabyte NVIDIA GeForce RTX1326395265SE +/- 6.19, N = 959.161. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

Phoronix Test Suite v10.8.4