hammerdb raptor lake

Intel Core i5-13600K testing with a ASUS PRIME Z790-P WIFI (0602 BIOS) and AMD Radeon RX 6800 XT 16GB on Ubuntu 22.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 2211010-PTS-HAMMERDB99
Jump To Table - Results

View

Do Not Show Noisy Results
Do Not Show Results With Incomplete Data
Do Not Show Results With Little Change/Spread
List Notable Results

Statistics

Show Overall Harmonic Mean(s)
Show Overall Geometric Mean
Show Wins / Losses Counts (Pie Chart)
Normalize Results
Remove Outliers Before Calculating Averages

Graph Settings

Force Line Graphs Where Applicable
Convert To Scalar Where Applicable
Prefer Vertical Bar Graphs

Multi-Way Comparison

Condense Multi-Option Tests Into Single Result Graphs

Table

Show Detailed System Result Table

Run Management

Highlight
Result
Hide
Result
Result
Identifier
Performance Per
Dollar
Date
Run
  Test
  Duration
a
November 01 2022
  5 Hours, 28 Minutes
B
November 01 2022
  5 Hours, 32 Minutes
C
November 01 2022
  5 Hours, 31 Minutes
Invert Hiding All Results Option
  5 Hours, 31 Minutes

Only show results where is faster than
Only show results matching title/arguments (delimit multiple options with a comma):


hammerdb raptor lakeOpenBenchmarking.orgPhoronix Test Suite 10.8.4Intel Core i5-13600K @ 3.80GHz (14 Cores / 20 Threads)ASUS PRIME Z790-P WIFI (0602 BIOS)Intel Device 7a2732GB2000GB Samsung SSD 980 PRO 2TB + 2000GBAMD Radeon RX 6800 XT 16GB (2575/1000MHz)Realtek ALC897ASUS VP28URealtek RTL8125 2.5GbE + Intel Device 7a70Ubuntu 22.046.0.0-060000rc1daily20220820-generic (x86_64)GNOME Shell 42.2X Server 1.21.1.3 + Wayland4.6 Mesa 22.3.0-devel (git-4685385 2022-08-23 jammy-oibaf-ppa) (LLVM 14.0.6 DRM 3.48)1.3.224GCC 12.0.1 20220319ext43840x2160ProcessorMotherboardChipsetMemoryDiskGraphicsAudioMonitorNetworkOSKernelDesktopDisplay ServerOpenGLVulkanCompilerFile-SystemScreen ResolutionHammerdb Raptor Lake BenchmarksSystem Logs- 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-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-12-OcsLtf/gcc-12-12-20220319/debian/tmp-nvptx/usr,amdgcn-amdhsa=/build/gcc-12-OcsLtf/gcc-12-12-20220319/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: 0x10e- itlb_multihit: Not affected + l1tf: Not affected + mds: Not affected + meltdown: Not affected + mmio_stale_data: Not affected + retbleed: 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 Enhanced IBRS IBPB: conditional RSB filling PBRSB-eIBRS: SW sequence + srbds: Not affected + tsx_async_abort: Not affected

aBCResult OverviewPhoronix Test Suite 10.8.4100%167%233%300%367%HammerDB - PostgreSQLHammerDB - PostgreSQLHammerDB - PostgreSQLHammerDB - PostgreSQLHammerDB - PostgreSQLHammerDB - PostgreSQLHammerDB - PostgreSQLHammerDB - PostgreSQLHammerDB - MariaDBHammerDB - MariaDBHammerDB - MariaDBHammerDB - MariaDBHammerDB - MariaDBHammerDB - MariaDBHammerDB - MariaDBHammerDB - MariaDBHammerDB - MariaDBHammerDB - PostgreSQLHammerDB - MariaDBHammerDB - PostgreSQLHammerDB - PostgreSQLHammerDB - PostgreSQLHammerDB - PostgreSQLHammerDB - PostgreSQLHammerDB - PostgreSQLHammerDB - PostgreSQLHammerDB - MariaDBHammerDB - MariaDBHammerDB - MariaDBHammerDB - MariaDBHammerDB - MariaDBHammerDB - MariaDB64 - 10064 - 10064 - 25064 - 25032 - 10032 - 10032 - 25032 - 2508 - 1008 - 1008 - 2508 - 25016 - 10016 - 10016 - 25016 - 25064 - 1008 - 25064 - 1008 - 25016 - 10016 - 1008 - 1008 - 10016 - 25016 - 25064 - 25064 - 25032 - 25032 - 25032 - 10032 - 100

hammerdb raptor lakehammerdb-mariadb: 8 - 100hammerdb-mariadb: 8 - 100hammerdb-mariadb: 8 - 250hammerdb-mariadb: 8 - 250hammerdb-mariadb: 16 - 100hammerdb-mariadb: 16 - 100hammerdb-mariadb: 16 - 250hammerdb-mariadb: 16 - 250hammerdb-mariadb: 32 - 100hammerdb-mariadb: 32 - 100hammerdb-mariadb: 32 - 250hammerdb-mariadb: 32 - 250hammerdb-mariadb: 64 - 100hammerdb-mariadb: 64 - 100hammerdb-mariadb: 64 - 250hammerdb-mariadb: 64 - 250hammerdb-postgresql: 8 - 100hammerdb-postgresql: 8 - 100hammerdb-postgresql: 8 - 250hammerdb-postgresql: 8 - 250hammerdb-postgresql: 16 - 100hammerdb-postgresql: 16 - 100hammerdb-postgresql: 16 - 250hammerdb-postgresql: 16 - 250hammerdb-postgresql: 32 - 100hammerdb-postgresql: 32 - 100hammerdb-postgresql: 32 - 250hammerdb-postgresql: 32 - 250hammerdb-postgresql: 64 - 100hammerdb-postgresql: 64 - 100hammerdb-postgresql: 64 - 250hammerdb-postgresql: 64 - 250aBC790818450750117470836519547727116945505611681506711713737917141503811735760567175100973391816860341015604233461710700732460440120610927730521194608274778498620922792719642302221116445210380465810812539212475531512351514912003508211751563613059548212728661416152032456890213128978542551965073926436213365854650912651878307311923161624921144022173453516939824385101824741110685583130145151119985222121035290123105749134135614130806496021491766559905128874792301521223851008721232217977805717939435570041287615268883622129363052836518OpenBenchmarking.org

HammerDB - MariaDB

OpenBenchmarking.orgNew Orders Per Minute, More Is BetterHammerDB - MariaDB 10.9.3Virtual Users: 8 - Warehouses: 100aBC2K4K6K8K10K7908445243851. (CXX) g++ options: -pie -fPIC -fstack-protector -O2 -lnuma -lpcre2-8 -lcrypt -laio -lz -lm -lssl -lcrypto -lpthread -ldl

OpenBenchmarking.orgTransactions Per Minute, More Is BetterHammerDB - MariaDB 10.9.3Virtual Users: 8 - Warehouses: 100aBC4K8K12K16K20K1845010380101821. (CXX) g++ options: -pie -fPIC -fstack-protector -O2 -lnuma -lpcre2-8 -lcrypt -laio -lz -lm -lssl -lcrypto -lpthread -ldl

OpenBenchmarking.orgNew Orders Per Minute, More Is BetterHammerDB - MariaDB 10.9.3Virtual Users: 8 - Warehouses: 250aBC160032004800640080007501465847411. (CXX) g++ options: -pie -fPIC -fstack-protector -O2 -lnuma -lpcre2-8 -lcrypt -laio -lz -lm -lssl -lcrypto -lpthread -ldl

OpenBenchmarking.orgTransactions Per Minute, More Is BetterHammerDB - MariaDB 10.9.3Virtual Users: 8 - Warehouses: 250aBC4K8K12K16K20K1747010812110681. (CXX) g++ options: -pie -fPIC -fstack-protector -O2 -lnuma -lpcre2-8 -lcrypt -laio -lz -lm -lssl -lcrypto -lpthread -ldl

OpenBenchmarking.orgNew Orders Per Minute, More Is BetterHammerDB - MariaDB 10.9.3Virtual Users: 16 - Warehouses: 100aBC2K4K6K8K10K8365539255831. (CXX) g++ options: -pie -fPIC -fstack-protector -O2 -lnuma -lpcre2-8 -lcrypt -laio -lz -lm -lssl -lcrypto -lpthread -ldl

OpenBenchmarking.orgTransactions Per Minute, More Is BetterHammerDB - MariaDB 10.9.3Virtual Users: 16 - Warehouses: 100aBC4K8K12K16K20K1954712475130141. (CXX) g++ options: -pie -fPIC -fstack-protector -O2 -lnuma -lpcre2-8 -lcrypt -laio -lz -lm -lssl -lcrypto -lpthread -ldl

OpenBenchmarking.orgNew Orders Per Minute, More Is BetterHammerDB - MariaDB 10.9.3Virtual Users: 16 - Warehouses: 250aBC160032004800640080007271531551511. (CXX) g++ options: -pie -fPIC -fstack-protector -O2 -lnuma -lpcre2-8 -lcrypt -laio -lz -lm -lssl -lcrypto -lpthread -ldl

OpenBenchmarking.orgTransactions Per Minute, More Is BetterHammerDB - MariaDB 10.9.3Virtual Users: 16 - Warehouses: 250aBC4K8K12K16K20K1694512351119981. (CXX) g++ options: -pie -fPIC -fstack-protector -O2 -lnuma -lpcre2-8 -lcrypt -laio -lz -lm -lssl -lcrypto -lpthread -ldl

OpenBenchmarking.orgNew Orders Per Minute, More Is BetterHammerDB - MariaDB 10.9.3Virtual Users: 32 - Warehouses: 100aBC110022003300440055005056514952221. (CXX) g++ options: -pie -fPIC -fstack-protector -O2 -lnuma -lpcre2-8 -lcrypt -laio -lz -lm -lssl -lcrypto -lpthread -ldl

OpenBenchmarking.orgTransactions Per Minute, More Is BetterHammerDB - MariaDB 10.9.3Virtual Users: 32 - Warehouses: 100aBC3K6K9K12K15K1168112003121031. (CXX) g++ options: -pie -fPIC -fstack-protector -O2 -lnuma -lpcre2-8 -lcrypt -laio -lz -lm -lssl -lcrypto -lpthread -ldl

OpenBenchmarking.orgNew Orders Per Minute, More Is BetterHammerDB - MariaDB 10.9.3Virtual Users: 32 - Warehouses: 250aBC110022003300440055005067508252901. (CXX) g++ options: -pie -fPIC -fstack-protector -O2 -lnuma -lpcre2-8 -lcrypt -laio -lz -lm -lssl -lcrypto -lpthread -ldl

OpenBenchmarking.orgTransactions Per Minute, More Is BetterHammerDB - MariaDB 10.9.3Virtual Users: 32 - Warehouses: 250aBC3K6K9K12K15K1171311751123101. (CXX) g++ options: -pie -fPIC -fstack-protector -O2 -lnuma -lpcre2-8 -lcrypt -laio -lz -lm -lssl -lcrypto -lpthread -ldl

OpenBenchmarking.orgNew Orders Per Minute, More Is BetterHammerDB - MariaDB 10.9.3Virtual Users: 64 - Warehouses: 100aBC160032004800640080007379563657491. (CXX) g++ options: -pie -fPIC -fstack-protector -O2 -lnuma -lpcre2-8 -lcrypt -laio -lz -lm -lssl -lcrypto -lpthread -ldl

OpenBenchmarking.orgTransactions Per Minute, More Is BetterHammerDB - MariaDB 10.9.3Virtual Users: 64 - Warehouses: 100aBC4K8K12K16K20K1714113059134131. (CXX) g++ options: -pie -fPIC -fstack-protector -O2 -lnuma -lpcre2-8 -lcrypt -laio -lz -lm -lssl -lcrypto -lpthread -ldl

OpenBenchmarking.orgNew Orders Per Minute, More Is BetterHammerDB - MariaDB 10.9.3Virtual Users: 64 - Warehouses: 250aBC120024003600480060005038548256141. (CXX) g++ options: -pie -fPIC -fstack-protector -O2 -lnuma -lpcre2-8 -lcrypt -laio -lz -lm -lssl -lcrypto -lpthread -ldl

OpenBenchmarking.orgTransactions Per Minute, More Is BetterHammerDB - MariaDB 10.9.3Virtual Users: 64 - Warehouses: 250aBC3K6K9K12K15K1173512728130801. (CXX) g++ options: -pie -fPIC -fstack-protector -O2 -lnuma -lpcre2-8 -lcrypt -laio -lz -lm -lssl -lcrypto -lpthread -ldl

HammerDB - PostgreSQL

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

OpenBenchmarking.orgTransactions Per Minute, More Is BetterHammerDB - PostgreSQL 15Virtual Users: 8 - Warehouses: 100aBC400K800K1200K1600K2000K1751009152032414917661. (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: 250aBC160K320K480K640K800K7339185689025599051. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

OpenBenchmarking.orgTransactions Per Minute, More Is BetterHammerDB - PostgreSQL 15Virtual Users: 8 - Warehouses: 250aBC400K800K1200K1600K2000K1686034131289712887471. (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: 100aBC200K400K600K800K1000K10156048542559230151. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

OpenBenchmarking.orgTransactions Per Minute, More Is BetterHammerDB - PostgreSQL 15Virtual Users: 16 - Warehouses: 100aBC500K1000K1500K2000K2500K2334617196507321223851. (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: 250aBC200K400K600K800K1000K107007392643610087211. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

OpenBenchmarking.orgTransactions Per Minute, More Is BetterHammerDB - PostgreSQL 15Virtual Users: 16 - Warehouses: 250aBC500K1000K1500K2000K2500K2460440213365823221791. (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: 100aBC300K600K900K1200K1500K12061095465097780571. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

OpenBenchmarking.orgTransactions Per Minute, More Is BetterHammerDB - PostgreSQL 15Virtual Users: 32 - Warehouses: 100aBC600K1200K1800K2400K3000K2773052126518717939431. (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: 250aBC300K600K900K1200K1500K11946088307315570041. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

OpenBenchmarking.orgTransactions Per Minute, More Is BetterHammerDB - PostgreSQL 15Virtual Users: 32 - Warehouses: 250aBC600K1200K1800K2400K3000K2747784192316112876151. (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: 100aBC200K400K600K800K1000K9862096249212688831. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

OpenBenchmarking.orgTransactions Per Minute, More Is BetterHammerDB - PostgreSQL 15Virtual Users: 64 - Warehouses: 100aBC500K1000K1500K2000K2500K227927114402216221291. (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: 250aBC200K400K600K800K1000K9642307345353630521. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

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

32 Results Shown

HammerDB - MariaDB:
  8 - 100:
    New Orders Per Minute
    Transactions Per Minute
  8 - 250:
    New Orders Per Minute
    Transactions Per Minute
  16 - 100:
    New Orders Per Minute
    Transactions Per Minute
  16 - 250:
    New Orders Per Minute
    Transactions Per Minute
  32 - 100:
    New Orders Per Minute
    Transactions Per Minute
  32 - 250:
    New Orders Per Minute
    Transactions Per Minute
  64 - 100:
    New Orders Per Minute
    Transactions Per Minute
  64 - 250:
    New Orders Per Minute
    Transactions Per Minute
HammerDB - PostgreSQL:
  8 - 100:
    New Orders Per Minute
    Transactions Per Minute
  8 - 250:
    New Orders Per Minute
    Transactions Per Minute
  16 - 100:
    New Orders Per Minute
    Transactions Per Minute
  16 - 250:
    New Orders Per Minute
    Transactions Per Minute
  32 - 100:
    New Orders Per Minute
    Transactions Per Minute
  32 - 250:
    New Orders Per Minute
    Transactions Per Minute
  64 - 100:
    New Orders Per Minute
    Transactions Per Minute
  64 - 250:
    New Orders Per Minute
    Transactions Per Minute