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.

HTML result view exported from: https://openbenchmarking.org/result/2211010-PTS-HAMMERDB99&grw.

hammerdb raptor lakeProcessorMotherboardChipsetMemoryDiskGraphicsAudioMonitorNetworkOSKernelDesktopDisplay ServerOpenGLVulkanCompilerFile-SystemScreen ResolutionaBCIntel 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 20220319ext43840x2160OpenBenchmarking.orgKernel Details- Transparent Huge Pages: madviseCompiler Details- --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 Processor Details- Scaling Governor: intel_pstate powersave (EPP: balance_performance) - CPU Microcode: 0x10eSecurity Details- 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

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

HammerDB - PostgreSQL

Virtual Users: 64 - Warehouses: 250

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

HammerDB - PostgreSQL

Virtual Users: 32 - Warehouses: 250

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

HammerDB - PostgreSQL

Virtual Users: 64 - Warehouses: 100

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

HammerDB - PostgreSQL

Virtual Users: 16 - Warehouses: 250

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

HammerDB - PostgreSQL

Virtual Users: 32 - Warehouses: 100

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

HammerDB - PostgreSQL

Virtual Users: 8 - Warehouses: 250

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

HammerDB - PostgreSQL

Virtual Users: 16 - Warehouses: 100

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

HammerDB - MariaDB

Virtual Users: 16 - Warehouses: 250

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

HammerDB - MariaDB

Virtual Users: 32 - Warehouses: 100

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

HammerDB - MariaDB

Virtual Users: 16 - Warehouses: 100

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

HammerDB - MariaDB

Virtual Users: 16 - Warehouses: 250

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

HammerDB - MariaDB

Virtual Users: 16 - Warehouses: 100

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

HammerDB - MariaDB

Virtual Users: 8 - Warehouses: 250

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

HammerDB - MariaDB

Virtual Users: 8 - Warehouses: 250

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

HammerDB - MariaDB

Virtual Users: 8 - Warehouses: 100

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

HammerDB - MariaDB

Virtual Users: 32 - Warehouses: 100

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

HammerDB - PostgreSQL

Virtual Users: 8 - Warehouses: 100

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

HammerDB - MariaDB

Virtual Users: 32 - Warehouses: 250

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

HammerDB - PostgreSQL

Virtual Users: 8 - Warehouses: 250

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

HammerDB - MariaDB

Virtual Users: 32 - Warehouses: 250

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

HammerDB - PostgreSQL

Virtual Users: 16 - Warehouses: 100

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

HammerDB - MariaDB

Virtual Users: 64 - Warehouses: 100

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

HammerDB - PostgreSQL

Virtual Users: 16 - Warehouses: 250

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

HammerDB - MariaDB

Virtual Users: 64 - Warehouses: 100

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

HammerDB - PostgreSQL

Virtual Users: 32 - Warehouses: 100

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

HammerDB - MariaDB

Virtual Users: 64 - Warehouses: 250

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

HammerDB - PostgreSQL

Virtual Users: 32 - Warehouses: 250

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

HammerDB - MariaDB

Virtual Users: 64 - Warehouses: 250

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

Virtual Users: 64 - Warehouses: 100

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

HammerDB - PostgreSQL

Virtual Users: 8 - Warehouses: 100

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

HammerDB - PostgreSQL

Virtual Users: 64 - Warehouses: 250

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

HammerDB - MariaDB

Virtual Users: 8 - Warehouses: 100

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

Phoronix Test Suite v10.8.5