hammerdb zen 4 AMD Ryzen 7 7700X 8-Core testing with a ASRock X670E PG Lightning (1.11 BIOS) and XFX AMD Radeon RX 6400 4GB on Ubuntu 22.10 via the Phoronix Test Suite.
HTML result view exported from: https://openbenchmarking.org/result/2211019-NE-HAMMERDBZ84&sro&gru .
hammerdb zen 4 Processor Motherboard Chipset Memory Disk Graphics Audio Monitor Network OS Kernel Desktop Display Server OpenGL Vulkan Compiler File-System Screen Resolution a B C AMD Ryzen 7 7700X 8-Core @ 5.57GHz (8 Cores / 16 Threads) ASRock X670E PG Lightning (1.11 BIOS) AMD Device 14d8 32GB 1000GB Western Digital WDS100T1X0E-00AFY0 XFX AMD Radeon RX 6400 4GB (2320/1000MHz) AMD Navi 21/23 ASUS MG28U Realtek RTL8125 2.5GbE Ubuntu 22.10 5.19.0-23-generic (x86_64) GNOME Shell 43.0 X Server + Wayland 4.6 Mesa 22.2.1 (LLVM 15.0.2 DRM 3.47) 1.3.224 GCC 12.2.0 ext4 3840x2160 OpenBenchmarking.org Kernel Details - Transparent Huge Pages: madvise Compiler 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-U8K4Qv/gcc-12-12.2.0/debian/tmp-nvptx/usr,amdgcn-amdhsa=/build/gcc-12-U8K4Qv/gcc-12-12.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 Details - Scaling Governor: amd-pstate schedutil (Boost: Enabled) - CPU Microcode: 0xa601203 Security 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 Retpolines IBPB: conditional IBRS_FW STIBP: always-on RSB filling PBRSB-eIBRS: Not affected + srbds: Not affected + tsx_async_abort: Not affected
hammerdb zen 4 hammerdb-mariadb: 8 - 100 hammerdb-mariadb: 8 - 250 hammerdb-mariadb: 16 - 100 hammerdb-mariadb: 16 - 250 hammerdb-mariadb: 32 - 100 hammerdb-mariadb: 32 - 250 hammerdb-mariadb: 64 - 100 hammerdb-mariadb: 64 - 250 hammerdb-postgresql: 8 - 100 hammerdb-postgresql: 8 - 250 hammerdb-postgresql: 16 - 100 hammerdb-postgresql: 16 - 250 hammerdb-postgresql: 32 - 100 hammerdb-postgresql: 32 - 250 hammerdb-postgresql: 64 - 100 hammerdb-postgresql: 64 - 250 hammerdb-mariadb: 8 - 100 hammerdb-mariadb: 8 - 250 hammerdb-mariadb: 16 - 100 hammerdb-mariadb: 16 - 250 hammerdb-mariadb: 32 - 100 hammerdb-mariadb: 32 - 250 hammerdb-mariadb: 64 - 100 hammerdb-mariadb: 64 - 250 hammerdb-postgresql: 8 - 100 hammerdb-postgresql: 8 - 250 hammerdb-postgresql: 16 - 100 hammerdb-postgresql: 16 - 250 hammerdb-postgresql: 32 - 100 hammerdb-postgresql: 32 - 250 hammerdb-postgresql: 64 - 100 hammerdb-postgresql: 64 - 250 a B C 37198 34674 37235 36521 36463 35109 37736 33867 792468 787876 1009575 1021621 1050877 996196 872758 844030 86412 80690 86639 84840 85003 81678 87781 78646 1823531 1811820 2320409 2347144 2416190 2292429 2008916 1943197 32805 33531 34743 35419 36066 33011 37040 32625 530072 603233 942793 714307 804743 818219 342794 364027 76117 77999 80629 82210 83595 76642 86141 75727 1226297 1390404 2165945 1647672 1855573 1885655 797031 842407 33997 33391 34743 35474 35625 31861 36009 31148 353482 404394 384768 339166 303395 211215 143162 107894 78847 77690 80709 82426 82769 74153 83611 72332 827648 942726 894625 790004 705566 490059 332187 251104 OpenBenchmarking.org
HammerDB - MariaDB Virtual Users: 8 - Warehouses: 100 OpenBenchmarking.org New Orders Per Minute, More Is Better HammerDB - MariaDB 10.9.3 Virtual Users: 8 - Warehouses: 100 B C a 8K 16K 24K 32K 40K 32805 33997 37198 1. (CXX) g++ options: -pie -fPIC -fstack-protector -O2 -lnuma -lcrypt -lz -lm -lssl -lcrypto -lpthread -ldl
HammerDB - MariaDB Virtual Users: 8 - Warehouses: 250 OpenBenchmarking.org New Orders Per Minute, More Is Better HammerDB - MariaDB 10.9.3 Virtual Users: 8 - Warehouses: 250 B C a 7K 14K 21K 28K 35K 33531 33391 34674 1. (CXX) g++ options: -pie -fPIC -fstack-protector -O2 -lnuma -lcrypt -lz -lm -lssl -lcrypto -lpthread -ldl
HammerDB - MariaDB Virtual Users: 16 - Warehouses: 100 OpenBenchmarking.org New Orders Per Minute, More Is Better HammerDB - MariaDB 10.9.3 Virtual Users: 16 - Warehouses: 100 B C a 8K 16K 24K 32K 40K 34743 34743 37235 1. (CXX) g++ options: -pie -fPIC -fstack-protector -O2 -lnuma -lcrypt -lz -lm -lssl -lcrypto -lpthread -ldl
HammerDB - MariaDB Virtual Users: 16 - Warehouses: 250 OpenBenchmarking.org New Orders Per Minute, More Is Better HammerDB - MariaDB 10.9.3 Virtual Users: 16 - Warehouses: 250 B C a 8K 16K 24K 32K 40K 35419 35474 36521 1. (CXX) g++ options: -pie -fPIC -fstack-protector -O2 -lnuma -lcrypt -lz -lm -lssl -lcrypto -lpthread -ldl
HammerDB - MariaDB Virtual Users: 32 - Warehouses: 100 OpenBenchmarking.org New Orders Per Minute, More Is Better HammerDB - MariaDB 10.9.3 Virtual Users: 32 - Warehouses: 100 B C a 8K 16K 24K 32K 40K 36066 35625 36463 1. (CXX) g++ options: -pie -fPIC -fstack-protector -O2 -lnuma -lcrypt -lz -lm -lssl -lcrypto -lpthread -ldl
HammerDB - MariaDB Virtual Users: 32 - Warehouses: 250 OpenBenchmarking.org New Orders Per Minute, More Is Better HammerDB - MariaDB 10.9.3 Virtual Users: 32 - Warehouses: 250 B C a 8K 16K 24K 32K 40K 33011 31861 35109 1. (CXX) g++ options: -pie -fPIC -fstack-protector -O2 -lnuma -lcrypt -lz -lm -lssl -lcrypto -lpthread -ldl
HammerDB - MariaDB Virtual Users: 64 - Warehouses: 100 OpenBenchmarking.org New Orders Per Minute, More Is Better HammerDB - MariaDB 10.9.3 Virtual Users: 64 - Warehouses: 100 B C a 8K 16K 24K 32K 40K 37040 36009 37736 1. (CXX) g++ options: -pie -fPIC -fstack-protector -O2 -lnuma -lcrypt -lz -lm -lssl -lcrypto -lpthread -ldl
HammerDB - MariaDB Virtual Users: 64 - Warehouses: 250 OpenBenchmarking.org New Orders Per Minute, More Is Better HammerDB - MariaDB 10.9.3 Virtual Users: 64 - Warehouses: 250 B C a 7K 14K 21K 28K 35K 32625 31148 33867 1. (CXX) g++ options: -pie -fPIC -fstack-protector -O2 -lnuma -lcrypt -lz -lm -lssl -lcrypto -lpthread -ldl
HammerDB - PostgreSQL Virtual Users: 8 - Warehouses: 100 OpenBenchmarking.org New Orders Per Minute, More Is Better HammerDB - PostgreSQL 15 Virtual Users: 8 - Warehouses: 100 B C a 200K 400K 600K 800K 1000K 530072 353482 792468 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
HammerDB - PostgreSQL Virtual Users: 8 - Warehouses: 250 OpenBenchmarking.org New Orders Per Minute, More Is Better HammerDB - PostgreSQL 15 Virtual Users: 8 - Warehouses: 250 B C a 200K 400K 600K 800K 1000K 603233 404394 787876 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
HammerDB - PostgreSQL Virtual Users: 16 - Warehouses: 100 OpenBenchmarking.org New Orders Per Minute, More Is Better HammerDB - PostgreSQL 15 Virtual Users: 16 - Warehouses: 100 B C a 200K 400K 600K 800K 1000K 942793 384768 1009575 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
HammerDB - PostgreSQL Virtual Users: 16 - Warehouses: 250 OpenBenchmarking.org New Orders Per Minute, More Is Better HammerDB - PostgreSQL 15 Virtual Users: 16 - Warehouses: 250 B C a 200K 400K 600K 800K 1000K 714307 339166 1021621 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
HammerDB - PostgreSQL Virtual Users: 32 - Warehouses: 100 OpenBenchmarking.org New Orders Per Minute, More Is Better HammerDB - PostgreSQL 15 Virtual Users: 32 - Warehouses: 100 B C a 200K 400K 600K 800K 1000K 804743 303395 1050877 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
HammerDB - PostgreSQL Virtual Users: 32 - Warehouses: 250 OpenBenchmarking.org New Orders Per Minute, More Is Better HammerDB - PostgreSQL 15 Virtual Users: 32 - Warehouses: 250 B C a 200K 400K 600K 800K 1000K 818219 211215 996196 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
HammerDB - PostgreSQL Virtual Users: 64 - Warehouses: 100 OpenBenchmarking.org New Orders Per Minute, More Is Better HammerDB - PostgreSQL 15 Virtual Users: 64 - Warehouses: 100 B C a 200K 400K 600K 800K 1000K 342794 143162 872758 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
HammerDB - PostgreSQL Virtual Users: 64 - Warehouses: 250 OpenBenchmarking.org New Orders Per Minute, More Is Better HammerDB - PostgreSQL 15 Virtual Users: 64 - Warehouses: 250 B C a 200K 400K 600K 800K 1000K 364027 107894 844030 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
HammerDB - MariaDB Virtual Users: 8 - Warehouses: 100 OpenBenchmarking.org Transactions Per Minute, More Is Better HammerDB - MariaDB 10.9.3 Virtual Users: 8 - Warehouses: 100 B C a 20K 40K 60K 80K 100K 76117 78847 86412 1. (CXX) g++ options: -pie -fPIC -fstack-protector -O2 -lnuma -lcrypt -lz -lm -lssl -lcrypto -lpthread -ldl
HammerDB - MariaDB Virtual Users: 8 - Warehouses: 250 OpenBenchmarking.org Transactions Per Minute, More Is Better HammerDB - MariaDB 10.9.3 Virtual Users: 8 - Warehouses: 250 B C a 20K 40K 60K 80K 100K 77999 77690 80690 1. (CXX) g++ options: -pie -fPIC -fstack-protector -O2 -lnuma -lcrypt -lz -lm -lssl -lcrypto -lpthread -ldl
HammerDB - MariaDB Virtual Users: 16 - Warehouses: 100 OpenBenchmarking.org Transactions Per Minute, More Is Better HammerDB - MariaDB 10.9.3 Virtual Users: 16 - Warehouses: 100 B C a 20K 40K 60K 80K 100K 80629 80709 86639 1. (CXX) g++ options: -pie -fPIC -fstack-protector -O2 -lnuma -lcrypt -lz -lm -lssl -lcrypto -lpthread -ldl
HammerDB - MariaDB Virtual Users: 16 - Warehouses: 250 OpenBenchmarking.org Transactions Per Minute, More Is Better HammerDB - MariaDB 10.9.3 Virtual Users: 16 - Warehouses: 250 B C a 20K 40K 60K 80K 100K 82210 82426 84840 1. (CXX) g++ options: -pie -fPIC -fstack-protector -O2 -lnuma -lcrypt -lz -lm -lssl -lcrypto -lpthread -ldl
HammerDB - MariaDB Virtual Users: 32 - Warehouses: 100 OpenBenchmarking.org Transactions Per Minute, More Is Better HammerDB - MariaDB 10.9.3 Virtual Users: 32 - Warehouses: 100 B C a 20K 40K 60K 80K 100K 83595 82769 85003 1. (CXX) g++ options: -pie -fPIC -fstack-protector -O2 -lnuma -lcrypt -lz -lm -lssl -lcrypto -lpthread -ldl
HammerDB - MariaDB Virtual Users: 32 - Warehouses: 250 OpenBenchmarking.org Transactions Per Minute, More Is Better HammerDB - MariaDB 10.9.3 Virtual Users: 32 - Warehouses: 250 B C a 20K 40K 60K 80K 100K 76642 74153 81678 1. (CXX) g++ options: -pie -fPIC -fstack-protector -O2 -lnuma -lcrypt -lz -lm -lssl -lcrypto -lpthread -ldl
HammerDB - MariaDB Virtual Users: 64 - Warehouses: 100 OpenBenchmarking.org Transactions Per Minute, More Is Better HammerDB - MariaDB 10.9.3 Virtual Users: 64 - Warehouses: 100 B C a 20K 40K 60K 80K 100K 86141 83611 87781 1. (CXX) g++ options: -pie -fPIC -fstack-protector -O2 -lnuma -lcrypt -lz -lm -lssl -lcrypto -lpthread -ldl
HammerDB - MariaDB Virtual Users: 64 - Warehouses: 250 OpenBenchmarking.org Transactions Per Minute, More Is Better HammerDB - MariaDB 10.9.3 Virtual Users: 64 - Warehouses: 250 B C a 20K 40K 60K 80K 100K 75727 72332 78646 1. (CXX) g++ options: -pie -fPIC -fstack-protector -O2 -lnuma -lcrypt -lz -lm -lssl -lcrypto -lpthread -ldl
HammerDB - PostgreSQL Virtual Users: 8 - Warehouses: 100 OpenBenchmarking.org Transactions Per Minute, More Is Better HammerDB - PostgreSQL 15 Virtual Users: 8 - Warehouses: 100 B C a 400K 800K 1200K 1600K 2000K 1226297 827648 1823531 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
HammerDB - PostgreSQL Virtual Users: 8 - Warehouses: 250 OpenBenchmarking.org Transactions Per Minute, More Is Better HammerDB - PostgreSQL 15 Virtual Users: 8 - Warehouses: 250 B C a 400K 800K 1200K 1600K 2000K 1390404 942726 1811820 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
HammerDB - PostgreSQL Virtual Users: 16 - Warehouses: 100 OpenBenchmarking.org Transactions Per Minute, More Is Better HammerDB - PostgreSQL 15 Virtual Users: 16 - Warehouses: 100 B C a 500K 1000K 1500K 2000K 2500K 2165945 894625 2320409 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
HammerDB - PostgreSQL Virtual Users: 16 - Warehouses: 250 OpenBenchmarking.org Transactions Per Minute, More Is Better HammerDB - PostgreSQL 15 Virtual Users: 16 - Warehouses: 250 B C a 500K 1000K 1500K 2000K 2500K 1647672 790004 2347144 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
HammerDB - PostgreSQL Virtual Users: 32 - Warehouses: 100 OpenBenchmarking.org Transactions Per Minute, More Is Better HammerDB - PostgreSQL 15 Virtual Users: 32 - Warehouses: 100 B C a 500K 1000K 1500K 2000K 2500K 1855573 705566 2416190 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
HammerDB - PostgreSQL Virtual Users: 32 - Warehouses: 250 OpenBenchmarking.org Transactions Per Minute, More Is Better HammerDB - PostgreSQL 15 Virtual Users: 32 - Warehouses: 250 B C a 500K 1000K 1500K 2000K 2500K 1885655 490059 2292429 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
HammerDB - PostgreSQL Virtual Users: 64 - Warehouses: 100 OpenBenchmarking.org Transactions Per Minute, More Is Better HammerDB - PostgreSQL 15 Virtual Users: 64 - Warehouses: 100 B C a 400K 800K 1200K 1600K 2000K 797031 332187 2008916 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
HammerDB - PostgreSQL Virtual Users: 64 - Warehouses: 250 OpenBenchmarking.org Transactions Per Minute, More Is Better HammerDB - PostgreSQL 15 Virtual Users: 64 - Warehouses: 250 B C a 400K 800K 1200K 1600K 2000K 842407 251104 1943197 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
Phoronix Test Suite v10.8.5