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.

Compare your own system(s) to this result file with the Phoronix Test Suite by running the command: phoronix-test-suite benchmark 2407270-NE-BARE2PSQL24
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

Run Management

Result
Identifier
Performance Per
Dollar
Date
Run
  Test
  Duration
Intel Xeon E-2286G - ASPEED - Supermicro
July 25
  9 Hours, 57 Minutes
Only show results matching title/arguments (delimit multiple options with a comma):
Do not show results matching title/arguments (delimit multiple options with a comma):

Intel Xeon E-2286G - ASPEED - Supermicro

Processor: Intel Xeon E-2286G @ 4.90GHz (6 Cores / 12 Threads), Motherboard: Supermicro SYS-5039MC-H12TRF X11SCE-F v1.02 (1.8.V1 BIOS), Chipset: Intel Cannon Lake PCH, Memory: 2 x 16 GB DDR4-2667MT/s Micron 18ADF2G72AZ-2G6E1, Disk: 2 x 960GB INTEL SSDSC2KG96, Graphics: ASPEED, Network: 2 x Intel 82599ES 10-Gigabit SFI/SFP+

OS: Ubuntu 24.04, Kernel: 6.8.0-38-generic (x86_64), Compiler: GCC 13.2.0, File-System: ext4, Screen Resolution: 1024x768

Kernel Notes: mpt3sas.max_queue_depth=1000 - Transparent Huge Pages: madvise
Compiler Notes: --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
Processor Notes: Scaling Governor: intel_pstate powersave (EPP: balance_performance) - CPU Microcode: 0xf6 - Thermald 2.5.6
Security Notes: 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

bare2psqlOpenBenchmarking.orgPhoronix Test SuiteIntel 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.0ext41024x768ProcessorMotherboardChipsetMemoryDiskGraphicsNetworkOSKernelCompilerFile-SystemScreen ResolutionBare2psql BenchmarksSystem Logs- 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: 32 - 250hammerdb-postgresql: 8 - 100hammerdb-postgresql: 32 - 250hammerdb-postgresql: 64 - 500hammerdb-postgresql: 8 - 1000hammerdb-postgresql: 64 - 100hammerdb-postgresql: 64 - 250hammerdb-postgresql: 16 - 100hammerdb-postgresql: 16 - 250hammerdb-postgresql: 8 - 500hammerdb-postgresql: 16 - 100hammerdb-postgresql: 8 - 500hammerdb-postgresql: 8 - 250hammerdb-postgresql: 8 - 250hammerdb-postgresql: 32 - 500hammerdb-postgresql: 16 - 250hammerdb-postgresql: 32 - 500hammerdb-postgresql: 16 - 500hammerdb-postgresql: 64 - 100hammerdb-postgresql: 16 - 500hammerdb-postgresql: 64 - 250hammerdb-postgresql: 32 - 100hammerdb-postgresql: 64 - 500hammerdb-postgresql: 32 - 100hammerdb-postgresql: 8 - 1000hammerdb-postgresql: 8 - 100Intel Xeon E-2286G - ASPEED - Supermicro10071278977594357663999883086064116804110601105786464202848148481567368746872302376918427156106861998633546276494983810631289470544486609211151031614710148388948OpenBenchmarking.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.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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

26 Results Shown

HammerDB - PostgreSQL:
  32 - 250
  8 - 100
  32 - 250
  64 - 500
  8 - 1000
  64 - 100
  64 - 250
  16 - 100
  16 - 250
  8 - 500
  16 - 100
  8 - 500
  8 - 250
  8 - 250
  32 - 500
  16 - 250
  32 - 500
  16 - 500
  64 - 100
  16 - 500
  64 - 250
  32 - 100
  64 - 500
  32 - 100
  8 - 1000
  8 - 100

Intel Xeon E-2286G - ASPEED - Supermicro

Processor: Intel Xeon E-2286G @ 4.90GHz (6 Cores / 12 Threads), Motherboard: Supermicro SYS-5039MC-H12TRF X11SCE-F v1.02 (1.8.V1 BIOS), Chipset: Intel Cannon Lake PCH, Memory: 2 x 16 GB DDR4-2667MT/s Micron 18ADF2G72AZ-2G6E1, Disk: 2 x 960GB INTEL SSDSC2KG96, Graphics: ASPEED, Network: 2 x Intel 82599ES 10-Gigabit SFI/SFP+

OS: Ubuntu 24.04, Kernel: 6.8.0-38-generic (x86_64), Compiler: GCC 13.2.0, File-System: ext4, Screen Resolution: 1024x768

Kernel Notes: mpt3sas.max_queue_depth=1000 - Transparent Huge Pages: madvise
Compiler Notes: --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
Processor Notes: Scaling Governor: intel_pstate powersave (EPP: balance_performance) - CPU Microcode: 0xf6 - Thermald 2.5.6
Security Notes: 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

Testing initiated at 25 July 2024 08:36 by user root.