Pgbench hammerdb xeon Intel Xeon E-2288G testing with a Compulab SBC-ATCFL v1.2 (ATOP3.PRD.0.29.2 BIOS) and NVIDIA Quadro RTX 4000 8GB on Ubuntu 20.10 via the Phoronix Test Suite.
HTML result view exported from: https://openbenchmarking.org/result/2104250-FI-PGBENCHHA16 .
Pgbench hammerdb xeon Processor Motherboard Chipset Memory Disk Graphics Audio Network OS Kernel Desktop Display Server Display Driver OpenCL Vulkan Compiler File-System Screen Resolution 1 Intel Xeon E-2288G @ 5.00GHz (8 Cores / 16 Threads) Compulab SBC-ATCFL v1.2 (ATOP3.PRD.0.29.2 BIOS) Intel Cannon Lake PCH 2 x 32 GB DDR4-2667MT/s Samsung M378A4G43MB1-CTD Samsung SSD 970 EVO Plus 250GB NVIDIA Quadro RTX 4000 8GB Intel Cannon Lake PCH cAVS Intel I219-LM + Intel I210 Ubuntu 20.10 5.8.0-41-generic (x86_64) GNOME Shell 3.38.2 X Server 1.20.9 modesetting 1.20.9 OpenCL 1.2 CUDA 11.2.109 1.2.155 GCC 10.2.0 ext4 1920x1080 OpenBenchmarking.org - --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++,m2 --enable-libphobos-checking=release --enable-libstdcxx-debug --enable-libstdcxx-time=yes --enable-multiarch --enable-multilib --enable-nls --enable-objc-gc=auto --enable-offload-targets=nvptx-none=/build/gcc-10-JvwpWM/gcc-10-10.2.0/debian/tmp-nvptx/usr,amdgcn-amdhsa=/build/gcc-10-JvwpWM/gcc-10-10.2.0/debian/tmp-gcn/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: 0xde - 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: Mitigation of TSX disabled + tsx_async_abort: Mitigation of TSX disabled
Pgbench hammerdb xeon hammerdb-postgresql: 8 - 250 hammerdb-postgresql: 8 - 250 hammerdb-postgresql: 16 - 250 hammerdb-postgresql: 16 - 250 hammerdb-postgresql: 32 - 250 hammerdb-postgresql: 32 - 250 1 118443 272443 54649 125948 29780 68481 OpenBenchmarking.org
HammerDB - PostgreSQL Virtual Users: 8 - Warehouses: 250 OpenBenchmarking.org New Orders Per Minute, More Is Better HammerDB - PostgreSQL 13 Virtual Users: 8 - Warehouses: 250 1 30K 60K 90K 120K 150K SE +/- 10293.21, N = 7 118443 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
HammerDB - PostgreSQL Virtual Users: 8 - Warehouses: 250 OpenBenchmarking.org Transactions Per Minute, More Is Better HammerDB - PostgreSQL 13 Virtual Users: 8 - Warehouses: 250 1 60K 120K 180K 240K 300K SE +/- 23727.36, N = 7 272443 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
HammerDB - PostgreSQL Virtual Users: 16 - Warehouses: 250 OpenBenchmarking.org New Orders Per Minute, More Is Better HammerDB - PostgreSQL 13 Virtual Users: 16 - Warehouses: 250 1 12K 24K 36K 48K 60K SE +/- 847.04, N = 3 54649 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
HammerDB - PostgreSQL Virtual Users: 16 - Warehouses: 250 OpenBenchmarking.org Transactions Per Minute, More Is Better HammerDB - PostgreSQL 13 Virtual Users: 16 - Warehouses: 250 1 30K 60K 90K 120K 150K SE +/- 1938.18, N = 3 125948 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
HammerDB - PostgreSQL Virtual Users: 32 - Warehouses: 250 OpenBenchmarking.org New Orders Per Minute, More Is Better HammerDB - PostgreSQL 13 Virtual Users: 32 - Warehouses: 250 1 6K 12K 18K 24K 30K SE +/- 963.42, N = 9 29780 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
HammerDB - PostgreSQL Virtual Users: 32 - Warehouses: 250 OpenBenchmarking.org Transactions Per Minute, More Is Better HammerDB - PostgreSQL 13 Virtual Users: 32 - Warehouses: 250 1 15K 30K 45K 60K 75K SE +/- 2242.21, N = 9 68481 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
Phoronix Test Suite v10.8.4