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.

Compare your own system(s) to this result file with the Phoronix Test Suite by running the command: phoronix-test-suite benchmark 2104250-FI-PGBENCHHA16
Jump To Table - Results

Statistics

Remove Outliers Before Calculating Averages

Graph Settings

Prefer Vertical Bar Graphs

Multi-Way Comparison

Condense Multi-Option Tests Into Single Result Graphs

Table

Show Detailed System Result Table
Only show results matching title/arguments (delimit multiple options with a comma):


Pgbench hammerdb xeonOpenBenchmarking.orgPhoronix Test Suite 10.4.0m1Intel Xeon E-2288G @ 5.00GHz (8 Cores / 16 Threads)Compulab SBC-ATCFL v1.2 (ATOP3.PRD.0.29.2 BIOS)Intel Cannon Lake PCH2 x 32 GB DDR4-2667MT/s Samsung M378A4G43MB1-CTDSamsung SSD 970 EVO Plus 250GBNVIDIA Quadro RTX 4000 8GBIntel Cannon Lake PCH cAVSIntel I219-LM + Intel I210Ubuntu 20.105.8.0-41-generic (x86_64)GNOME Shell 3.38.2X Server 1.20.9modesetting 1.20.9OpenCL 1.2 CUDA 11.2.1091.2.155GCC 10.2.0ext41920x1080ProcessorMotherboardChipsetMemoryDiskGraphicsAudioNetworkOSKernelDesktopDisplay ServerDisplay DriverOpenCLVulkanCompilerFile-SystemScreen ResolutionPgbench Hammerdb Xeon BenchmarksSystem Logs- --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 xeonhammerdb-postgresql: 8 - 250hammerdb-postgresql: 8 - 250hammerdb-postgresql: 16 - 250hammerdb-postgresql: 16 - 250hammerdb-postgresql: 32 - 250hammerdb-postgresql: 32 - 2501118443272443546491259482978068481OpenBenchmarking.org

HammerDB - PostgreSQL

This is a benchmark of the PostgreSQL database server, making use of the HammerDB benchmarking / load testing tool. Learn more via the OpenBenchmarking.org test page.

OpenBenchmarking.orgNew Orders Per Minute, More Is BetterHammerDB - PostgreSQL 13Virtual Users: 8 - Warehouses: 250130K60K90K120K150KSE +/- 10293.21, N = 71184431. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

OpenBenchmarking.orgTransactions Per Minute, More Is BetterHammerDB - PostgreSQL 13Virtual Users: 8 - Warehouses: 250160K120K180K240K300KSE +/- 23727.36, N = 72724431. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

OpenBenchmarking.orgNew Orders Per Minute, More Is BetterHammerDB - PostgreSQL 13Virtual Users: 16 - Warehouses: 250112K24K36K48K60KSE +/- 847.04, N = 3546491. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

OpenBenchmarking.orgTransactions Per Minute, More Is BetterHammerDB - PostgreSQL 13Virtual Users: 16 - Warehouses: 250130K60K90K120K150KSE +/- 1938.18, N = 31259481. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

OpenBenchmarking.orgNew Orders Per Minute, More Is BetterHammerDB - PostgreSQL 13Virtual Users: 32 - Warehouses: 25016K12K18K24K30KSE +/- 963.42, N = 9297801. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

OpenBenchmarking.orgTransactions Per Minute, More Is BetterHammerDB - PostgreSQL 13Virtual Users: 32 - Warehouses: 250115K30K45K60K75KSE +/- 2242.21, N = 9684811. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm