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&grs&sro .
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 - 100 hammerdb-postgresql: 8 - 100 hammerdb-postgresql: 8 - 250 hammerdb-postgresql: 8 - 250 hammerdb-mariadb: 8 - 100 hammerdb-mariadb: 8 - 100 hammerdb-mariadb: 32 - 250 hammerdb-mariadb: 32 - 250 hammerdb-mariadb: 64 - 250 hammerdb-mariadb: 64 - 250 hammerdb-mariadb: 16 - 100 hammerdb-mariadb: 16 - 100 hammerdb-mariadb: 64 - 100 hammerdb-mariadb: 64 - 100 hammerdb-mariadb: 8 - 250 hammerdb-mariadb: 8 - 250 hammerdb-mariadb: 16 - 250 hammerdb-mariadb: 16 - 250 hammerdb-mariadb: 32 - 100 hammerdb-mariadb: 32 - 100 a B C 844030 1943197 872758 2008916 996196 2292429 1050877 2416190 1021621 2347144 1009575 2320409 792468 1823531 787876 1811820 86412 37198 35109 81678 33867 78646 86639 37235 87781 37736 80690 34674 84840 36521 85003 36463 364027 842407 342794 797031 818219 1885655 804743 1855573 714307 1647672 942793 2165945 530072 1226297 603233 1390404 76117 32805 33011 76642 32625 75727 80629 34743 86141 37040 77999 33531 82210 35419 83595 36066 107894 251104 143162 332187 211215 490059 303395 705566 339166 790004 384768 894625 353482 827648 404394 942726 78847 33997 31861 74153 31148 72332 80709 34743 83611 36009 77690 33391 82426 35474 82769 35625 OpenBenchmarking.org
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 - 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
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: 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: 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: 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: 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: 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: 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: 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: 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: 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: 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: 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 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: 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 - 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: 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: 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: 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: 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 - 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 - 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: 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: 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: 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: 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: 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: 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: 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 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: 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
Phoronix Test Suite v10.8.5