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&grr&rdt .
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-postgresql: 64 - 250 hammerdb-postgresql: 64 - 250 hammerdb-postgresql: 64 - 100 hammerdb-postgresql: 64 - 100 hammerdb-postgresql: 32 - 250 hammerdb-postgresql: 32 - 250 hammerdb-postgresql: 32 - 100 hammerdb-postgresql: 32 - 100 hammerdb-postgresql: 16 - 250 hammerdb-postgresql: 16 - 250 hammerdb-postgresql: 16 - 100 hammerdb-postgresql: 16 - 100 hammerdb-postgresql: 8 - 250 hammerdb-postgresql: 8 - 250 hammerdb-postgresql: 8 - 100 hammerdb-postgresql: 8 - 100 hammerdb-mariadb: 64 - 250 hammerdb-mariadb: 64 - 250 hammerdb-mariadb: 64 - 100 hammerdb-mariadb: 64 - 100 hammerdb-mariadb: 32 - 250 hammerdb-mariadb: 32 - 250 hammerdb-mariadb: 32 - 100 hammerdb-mariadb: 32 - 100 hammerdb-mariadb: 16 - 250 hammerdb-mariadb: 16 - 250 hammerdb-mariadb: 16 - 100 hammerdb-mariadb: 16 - 100 hammerdb-mariadb: 8 - 250 hammerdb-mariadb: 8 - 250 hammerdb-mariadb: 8 - 100 hammerdb-mariadb: 8 - 100 a B C 1943197 844030 2008916 872758 2292429 996196 2416190 1050877 2347144 1021621 2320409 1009575 1811820 787876 1823531 792468 78646 33867 87781 37736 81678 35109 85003 36463 84840 36521 86639 37235 80690 34674 86412 37198 842407 364027 797031 342794 1885655 818219 1855573 804743 1647672 714307 2165945 942793 1390404 603233 1226297 530072 75727 32625 86141 37040 76642 33011 83595 36066 82210 35419 80629 34743 77999 33531 76117 32805 251104 107894 332187 143162 490059 211215 705566 303395 790004 339166 894625 384768 942726 404394 827648 353482 72332 31148 83611 36009 74153 31861 82769 35625 82426 35474 80709 34743 77690 33391 78847 33997 OpenBenchmarking.org
HammerDB - PostgreSQL Virtual Users: 64 - Warehouses: 250 OpenBenchmarking.org Transactions Per Minute, More Is Better HammerDB - PostgreSQL 15 Virtual Users: 64 - Warehouses: 250 a B C 400K 800K 1200K 1600K 2000K 1943197 842407 251104 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 a B C 200K 400K 600K 800K 1000K 844030 364027 107894 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 a B C 400K 800K 1200K 1600K 2000K 2008916 797031 332187 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 a B C 200K 400K 600K 800K 1000K 872758 342794 143162 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 a B C 500K 1000K 1500K 2000K 2500K 2292429 1885655 490059 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 a B C 200K 400K 600K 800K 1000K 996196 818219 211215 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 a B C 500K 1000K 1500K 2000K 2500K 2416190 1855573 705566 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 a B C 200K 400K 600K 800K 1000K 1050877 804743 303395 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 a B C 500K 1000K 1500K 2000K 2500K 2347144 1647672 790004 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 a B C 200K 400K 600K 800K 1000K 1021621 714307 339166 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 a B C 500K 1000K 1500K 2000K 2500K 2320409 2165945 894625 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 a B C 200K 400K 600K 800K 1000K 1009575 942793 384768 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 a B C 400K 800K 1200K 1600K 2000K 1811820 1390404 942726 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 a B C 200K 400K 600K 800K 1000K 787876 603233 404394 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
HammerDB - PostgreSQL Virtual Users: 8 - Warehouses: 100 OpenBenchmarking.org Transactions Per Minute, More Is Better HammerDB - PostgreSQL 15 Virtual Users: 8 - Warehouses: 100 a B C 400K 800K 1200K 1600K 2000K 1823531 1226297 827648 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
HammerDB - PostgreSQL Virtual Users: 8 - Warehouses: 100 OpenBenchmarking.org New Orders Per Minute, More Is Better HammerDB - PostgreSQL 15 Virtual Users: 8 - Warehouses: 100 a B C 200K 400K 600K 800K 1000K 792468 530072 353482 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
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 a B C 20K 40K 60K 80K 100K 78646 75727 72332 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 a B C 7K 14K 21K 28K 35K 33867 32625 31148 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 a B C 20K 40K 60K 80K 100K 87781 86141 83611 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 a B C 8K 16K 24K 32K 40K 37736 37040 36009 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 a B C 20K 40K 60K 80K 100K 81678 76642 74153 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 a B C 8K 16K 24K 32K 40K 35109 33011 31861 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 a B C 20K 40K 60K 80K 100K 85003 83595 82769 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 a B C 8K 16K 24K 32K 40K 36463 36066 35625 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 a B C 20K 40K 60K 80K 100K 84840 82210 82426 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 a B C 8K 16K 24K 32K 40K 36521 35419 35474 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 a B C 20K 40K 60K 80K 100K 86639 80629 80709 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 a B C 8K 16K 24K 32K 40K 37235 34743 34743 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 a B C 20K 40K 60K 80K 100K 80690 77999 77690 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 a B C 7K 14K 21K 28K 35K 34674 33531 33391 1. (CXX) g++ options: -pie -fPIC -fstack-protector -O2 -lnuma -lcrypt -lz -lm -lssl -lcrypto -lpthread -ldl
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 a B C 20K 40K 60K 80K 100K 86412 76117 78847 1. (CXX) g++ options: -pie -fPIC -fstack-protector -O2 -lnuma -lcrypt -lz -lm -lssl -lcrypto -lpthread -ldl
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 a B C 8K 16K 24K 32K 40K 37198 32805 33997 1. (CXX) g++ options: -pie -fPIC -fstack-protector -O2 -lnuma -lcrypt -lz -lm -lssl -lcrypto -lpthread -ldl
Phoronix Test Suite v10.8.5