bare2psql

Intel Xeon E-2286G testing with a Supermicro SYS-5039MC-H12TRF X11SCE-F v1.02 (1.8.V1 BIOS) and ASPEED on Ubuntu 24.04 via the Phoronix Test Suite.

HTML result view exported from: https://openbenchmarking.org/result/2407270-NE-BARE2PSQL24&grr.

bare2psqlProcessorMotherboardChipsetMemoryDiskGraphicsNetworkOSKernelCompilerFile-SystemScreen ResolutionIntel Xeon E-2286G - ASPEED - SupermicroIntel Xeon E-2286G @ 4.90GHz (6 Cores / 12 Threads)Supermicro SYS-5039MC-H12TRF X11SCE-F v1.02 (1.8.V1 BIOS)Intel Cannon Lake PCH2 x 16 GB DDR4-2667MT/s Micron 18ADF2G72AZ-2G6E12 x 960GB INTEL SSDSC2KG96ASPEED2 x Intel 82599ES 10-Gigabit SFI/SFP+Ubuntu 24.046.8.0-38-generic (x86_64)GCC 13.2.0ext41024x768OpenBenchmarking.org- mpt3sas.max_queue_depth=1000 - Transparent Huge Pages: madvise- --build=x86_64-linux-gnu --disable-vtable-verify --disable-werror --enable-cet --enable-checking=release --enable-clocale=gnu --enable-default-pie --enable-gnu-unique-object --enable-languages=c,ada,c++,go,d,fortran,objc,obj-c++,m2 --enable-libphobos-checking=release --enable-libstdcxx-backtrace --enable-libstdcxx-debug --enable-libstdcxx-time=yes --enable-multiarch --enable-multilib --enable-nls --enable-objc-gc=auto --enable-offload-defaulted --enable-offload-targets=nvptx-none=/build/gcc-13-uJ7kn6/gcc-13-13.2.0/debian/tmp-nvptx/usr,amdgcn-amdhsa=/build/gcc-13-uJ7kn6/gcc-13-13.2.0/debian/tmp-gcn/usr --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 (EPP: balance_performance) - CPU Microcode: 0xf6 - Thermald 2.5.6 - gather_data_sampling: Mitigation of Microcode + itlb_multihit: KVM: Mitigation of VMX disabled + l1tf: Mitigation of PTE Inversion; VMX: conditional cache flushes SMT vulnerable + mds: Mitigation of Clear buffers; SMT vulnerable + meltdown: Mitigation of PTI + mmio_stale_data: Mitigation of Clear buffers; SMT vulnerable + reg_file_data_sampling: Not affected + retbleed: Mitigation of IBRS + spec_rstack_overflow: Not affected + spec_store_bypass: Mitigation of SSB disabled via prctl + spectre_v1: Mitigation of usercopy/swapgs barriers and __user pointer sanitization + spectre_v2: Mitigation of IBRS; IBPB: conditional; STIBP: conditional; RSB filling; PBRSB-eIBRS: Not affected; BHI: Not affected + srbds: Mitigation of Microcode + tsx_async_abort: Mitigation of TSX disabled

bare2psqlhammerdb-postgresql: 8 - 1000hammerdb-postgresql: 8 - 1000hammerdb-postgresql: 8 - 500hammerdb-postgresql: 8 - 500hammerdb-postgresql: 64 - 500hammerdb-postgresql: 64 - 500hammerdb-postgresql: 16 - 500hammerdb-postgresql: 16 - 500hammerdb-postgresql: 32 - 500hammerdb-postgresql: 32 - 500hammerdb-postgresql: 16 - 250hammerdb-postgresql: 16 - 250hammerdb-postgresql: 8 - 250hammerdb-postgresql: 8 - 250hammerdb-postgresql: 64 - 250hammerdb-postgresql: 64 - 250hammerdb-postgresql: 32 - 250hammerdb-postgresql: 32 - 250hammerdb-postgresql: 8 - 100hammerdb-postgresql: 8 - 100hammerdb-postgresql: 16 - 100hammerdb-postgresql: 16 - 100hammerdb-postgresql: 32 - 100hammerdb-postgresql: 32 - 100hammerdb-postgresql: 64 - 100hammerdb-postgresql: 64 - 100Intel Xeon E-2286G - ASPEED - Supermicro71014830860684814836874692111539998810631284627649863354271561068619464202872302376918947054411060100712743576689775938894811057864815671031614448660949838411680OpenBenchmarking.org

HammerDB - PostgreSQL

Virtual Users: 8 - Warehouses: 1000

OpenBenchmarking.orgTransactions Per Minute, More Is BetterHammerDB - PostgreSQL 15Virtual Users: 8 - Warehouses: 1000Intel Xeon E-2286G - ASPEED - Supermicro150K300K450K600K750K7101481. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

HammerDB - PostgreSQL

Virtual Users: 8 - Warehouses: 1000

OpenBenchmarking.orgNew Orders Per Minute, More Is BetterHammerDB - PostgreSQL 15Virtual Users: 8 - Warehouses: 1000Intel Xeon E-2286G - ASPEED - Supermicro70K140K210K280K350K3086061. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

HammerDB - PostgreSQL

Virtual Users: 8 - Warehouses: 500

OpenBenchmarking.orgTransactions Per Minute, More Is BetterHammerDB - PostgreSQL 15Virtual Users: 8 - Warehouses: 500Intel Xeon E-2286G - ASPEED - Supermicro200K400K600K800K1000K8481481. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

HammerDB - PostgreSQL

Virtual Users: 8 - Warehouses: 500

OpenBenchmarking.orgNew Orders Per Minute, More Is BetterHammerDB - PostgreSQL 15Virtual Users: 8 - Warehouses: 500Intel Xeon E-2286G - ASPEED - Supermicro80K160K240K320K400K3687461. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

HammerDB - PostgreSQL

Virtual Users: 64 - Warehouses: 500

OpenBenchmarking.orgTransactions Per Minute, More Is BetterHammerDB - PostgreSQL 15Virtual Users: 64 - Warehouses: 500Intel Xeon E-2286G - ASPEED - Supermicro200K400K600K800K1000K9211151. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

HammerDB - PostgreSQL

Virtual Users: 64 - Warehouses: 500

OpenBenchmarking.orgNew Orders Per Minute, More Is BetterHammerDB - PostgreSQL 15Virtual Users: 64 - Warehouses: 500Intel Xeon E-2286G - ASPEED - Supermicro90K180K270K360K450K3999881. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

HammerDB - PostgreSQL

Virtual Users: 16 - Warehouses: 500

OpenBenchmarking.orgTransactions Per Minute, More Is BetterHammerDB - PostgreSQL 15Virtual Users: 16 - Warehouses: 500Intel Xeon E-2286G - ASPEED - Supermicro200K400K600K800K1000K10631281. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

HammerDB - PostgreSQL

Virtual Users: 16 - Warehouses: 500

OpenBenchmarking.orgNew Orders Per Minute, More Is BetterHammerDB - PostgreSQL 15Virtual Users: 16 - Warehouses: 500Intel Xeon E-2286G - ASPEED - Supermicro100K200K300K400K500K4627641. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

HammerDB - PostgreSQL

Virtual Users: 32 - Warehouses: 500

OpenBenchmarking.orgTransactions Per Minute, More Is BetterHammerDB - PostgreSQL 15Virtual Users: 32 - Warehouses: 500Intel Xeon E-2286G - ASPEED - Supermicro200K400K600K800K1000K9863351. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

HammerDB - PostgreSQL

Virtual Users: 32 - Warehouses: 500

OpenBenchmarking.orgNew Orders Per Minute, More Is BetterHammerDB - PostgreSQL 15Virtual Users: 32 - Warehouses: 500Intel Xeon E-2286G - ASPEED - Supermicro90K180K270K360K450K4271561. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

HammerDB - PostgreSQL

Virtual Users: 16 - Warehouses: 250

OpenBenchmarking.orgTransactions Per Minute, More Is BetterHammerDB - PostgreSQL 15Virtual Users: 16 - Warehouses: 250Intel Xeon E-2286G - ASPEED - Supermicro200K400K600K800K1000K10686191. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

HammerDB - PostgreSQL

Virtual Users: 16 - Warehouses: 250

OpenBenchmarking.orgNew Orders Per Minute, More Is BetterHammerDB - PostgreSQL 15Virtual Users: 16 - Warehouses: 250Intel Xeon E-2286G - ASPEED - Supermicro100K200K300K400K500K4642021. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

HammerDB - PostgreSQL

Virtual Users: 8 - Warehouses: 250

OpenBenchmarking.orgTransactions Per Minute, More Is BetterHammerDB - PostgreSQL 15Virtual Users: 8 - Warehouses: 250Intel Xeon E-2286G - ASPEED - Supermicro200K400K600K800K1000K8723021. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

HammerDB - PostgreSQL

Virtual Users: 8 - Warehouses: 250

OpenBenchmarking.orgNew Orders Per Minute, More Is BetterHammerDB - PostgreSQL 15Virtual Users: 8 - Warehouses: 250Intel Xeon E-2286G - ASPEED - Supermicro80K160K240K320K400K3769181. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

HammerDB - PostgreSQL

Virtual Users: 64 - Warehouses: 250

OpenBenchmarking.orgTransactions Per Minute, More Is BetterHammerDB - PostgreSQL 15Virtual Users: 64 - Warehouses: 250Intel Xeon E-2286G - ASPEED - Supermicro200K400K600K800K1000K9470541. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

HammerDB - PostgreSQL

Virtual Users: 64 - Warehouses: 250

OpenBenchmarking.orgNew Orders Per Minute, More Is BetterHammerDB - PostgreSQL 15Virtual Users: 64 - Warehouses: 250Intel Xeon E-2286G - ASPEED - Supermicro90K180K270K360K450K4110601. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

HammerDB - PostgreSQL

Virtual Users: 32 - Warehouses: 250

OpenBenchmarking.orgTransactions Per Minute, More Is BetterHammerDB - PostgreSQL 15Virtual Users: 32 - Warehouses: 250Intel Xeon E-2286G - ASPEED - Supermicro200K400K600K800K1000K10071271. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

HammerDB - PostgreSQL

Virtual Users: 32 - Warehouses: 250

OpenBenchmarking.orgNew Orders Per Minute, More Is BetterHammerDB - PostgreSQL 15Virtual Users: 32 - Warehouses: 250Intel Xeon E-2286G - ASPEED - Supermicro90K180K270K360K450K4357661. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

HammerDB - PostgreSQL

Virtual Users: 8 - Warehouses: 100

OpenBenchmarking.orgTransactions Per Minute, More Is BetterHammerDB - PostgreSQL 15Virtual Users: 8 - Warehouses: 100Intel Xeon E-2286G - ASPEED - Supermicro200K400K600K800K1000K8977591. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

HammerDB - PostgreSQL

Virtual Users: 8 - Warehouses: 100

OpenBenchmarking.orgNew Orders Per Minute, More Is BetterHammerDB - PostgreSQL 15Virtual Users: 8 - Warehouses: 100Intel Xeon E-2286G - ASPEED - Supermicro80K160K240K320K400K3889481. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

HammerDB - PostgreSQL

Virtual Users: 16 - Warehouses: 100

OpenBenchmarking.orgTransactions Per Minute, More Is BetterHammerDB - PostgreSQL 15Virtual Users: 16 - Warehouses: 100Intel Xeon E-2286G - ASPEED - Supermicro200K400K600K800K1000K11057861. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

HammerDB - PostgreSQL

Virtual Users: 16 - Warehouses: 100

OpenBenchmarking.orgNew Orders Per Minute, More Is BetterHammerDB - PostgreSQL 15Virtual Users: 16 - Warehouses: 100Intel Xeon E-2286G - ASPEED - Supermicro100K200K300K400K500K4815671. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

HammerDB - PostgreSQL

Virtual Users: 32 - Warehouses: 100

OpenBenchmarking.orgTransactions Per Minute, More Is BetterHammerDB - PostgreSQL 15Virtual Users: 32 - Warehouses: 100Intel Xeon E-2286G - ASPEED - Supermicro200K400K600K800K1000K10316141. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

HammerDB - PostgreSQL

Virtual Users: 32 - Warehouses: 100

OpenBenchmarking.orgNew Orders Per Minute, More Is BetterHammerDB - PostgreSQL 15Virtual Users: 32 - Warehouses: 100Intel Xeon E-2286G - ASPEED - Supermicro100K200K300K400K500K4486601. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

HammerDB - PostgreSQL

Virtual Users: 64 - Warehouses: 100

OpenBenchmarking.orgTransactions Per Minute, More Is BetterHammerDB - PostgreSQL 15Virtual Users: 64 - Warehouses: 100Intel Xeon E-2286G - ASPEED - Supermicro200K400K600K800K1000K9498381. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

HammerDB - PostgreSQL

Virtual Users: 64 - Warehouses: 100

OpenBenchmarking.orgNew Orders Per Minute, More Is BetterHammerDB - PostgreSQL 15Virtual Users: 64 - Warehouses: 100Intel Xeon E-2286G - ASPEED - Supermicro90K180K270K360K450K4116801. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

Phoronix Test Suite v10.8.5