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&sor .
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 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: 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: 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: 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: 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: 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: 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: 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: 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: 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: 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: 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: 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 - 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: 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: 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 - 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 C B 20K 40K 60K 80K 100K 86412 78847 76117 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 C B 8K 16K 24K 32K 40K 37198 33997 32805 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: 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: 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: 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: 16 - Warehouses: 100 OpenBenchmarking.org Transactions Per Minute, More Is Better HammerDB - MariaDB 10.9.3 Virtual Users: 16 - Warehouses: 100 a C B 20K 40K 60K 80K 100K 86639 80709 80629 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 C B 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: 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: 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: 16 - Warehouses: 250 OpenBenchmarking.org Transactions Per Minute, More Is Better HammerDB - MariaDB 10.9.3 Virtual Users: 16 - Warehouses: 250 a C B 20K 40K 60K 80K 100K 84840 82426 82210 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 C B 8K 16K 24K 32K 40K 36521 35474 35419 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
Phoronix Test Suite v10.8.5