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&sro&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: 250BCa200K400K600K800K1000K7345353630529642301. (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: 250BCa300K600K900K1200K1500K83073155700411946081. (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: 100BCa200K400K600K800K1000K6249212688839862091. (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: 250BCa200K400K600K800K1000K926436100872110700731. (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: 100BCa300K600K900K1200K1500K54650977805712061091. (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: 250BCa160K320K480K640K800K5689025599057339181. (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: 100BCa200K400K600K800K1000K85425592301510156041. (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: 250BCa4K8K12K16K20K1235111998169451. (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: 100BCa110022003300440055005149522250561. (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: 100BCa4K8K12K16K20K1247513014195471. (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: 250BCa160032004800640080005315515172711. (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: 100BCa2K4K6K8K10K5392558383651. (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: 250BCa4K8K12K16K20K1081211068174701. (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: 250BCa160032004800640080004658474175011. (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: 100BCa4K8K12K16K20K1038010182184501. (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: 100BCa3K6K9K12K15K1200312103116811. (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: 100BCa400K800K1200K1600K2000K1520324149176617510091. (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: 250BCa110022003300440055005082529050671. (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: 250BCa400K800K1200K1600K2000K1312897128874716860341. (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: 250BCa3K6K9K12K15K1175112310117131. (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: 100BCa500K1000K1500K2000K2500K1965073212238523346171. (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: 100BCa160032004800640080005636574973791. (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: 250BCa500K1000K1500K2000K2500K2133658232217924604401. (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: 100BCa4K8K12K16K20K1305913413171411. (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: 100BCa600K1200K1800K2400K3000K1265187179394327730521. (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: 250BCa120024003600480060005482561450381. (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: 250BCa600K1200K1800K2400K3000K1923161128761527477841. (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: 250BCa3K6K9K12K15K1272813080117351. (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: 100BCa500K1000K1500K2000K2500K144022162212922792711. (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: 100BCa160K320K480K640K800K6614166496027605671. (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: 250BCa500K1000K1500K2000K2500K169398283651822211161. (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: 100BCa2K4K6K8K10K4452438579081. (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