AMD Ryzen 9 7950X 16-Core testing with a ASUS ROG CROSSHAIR X670E HERO (0805 BIOS) and AMD Radeon RX 6800 XT 16GB on Ubuntu 22.10 via the Phoronix Test Suite.
Compare your own system(s) to this result file with the
Phoronix Test Suite by running the command:
phoronix-test-suite benchmark 2301112-NE-CLICKHOUS53 clickhouse 7950x - Phoronix Test Suite clickhouse 7950x AMD Ryzen 9 7950X 16-Core testing with a ASUS ROG CROSSHAIR X670E HERO (0805 BIOS) and AMD Radeon RX 6800 XT 16GB on Ubuntu 22.10 via the Phoronix Test Suite.
HTML result view exported from: https://openbenchmarking.org/result/2301112-NE-CLICKHOUS53&sor .
clickhouse 7950x Processor Motherboard Chipset Memory Disk Graphics Audio Monitor Network OS Kernel Desktop Display Server OpenGL Vulkan Compiler File-System Screen Resolution a b c d e AMD Ryzen 9 7950X 16-Core @ 4.50GHz (16 Cores / 32 Threads) ASUS ROG CROSSHAIR X670E HERO (0805 BIOS) AMD Device 14d8 32GB Western Digital WD_BLACK SN850X 1000GB + 2000GB AMD Radeon RX 6800 XT 16GB (2575/1000MHz) AMD Navi 21/23 ASUS MG28U Intel I225-V + Intel Wi-Fi 6 AX210/AX211/AX411 Ubuntu 22.10 6.2.0-rc1-phx (x86_64) GNOME Shell 43.1 X Server + Wayland 4.6 Mesa 22.2.1 (LLVM 15.0.2 DRM 3.49) 1.3.224 GCC 12.2.0 ext4 3840x2160 OpenBenchmarking.org Kernel Details - Transparent Huge Pages: madvise Processor Details - Scaling Governor: acpi-cpufreq 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
clickhouse 7950x clickhouse: 100M Rows Hits Dataset, First Run / Cold Cache clickhouse: 100M Rows Hits Dataset, Second Run clickhouse: 100M Rows Hits Dataset, Third Run a b c d e 234.34 260.89 265.94 243.36 268.10 273.87 238.77 266.17 268.27 239.50 271.36 271.10 235.63 260.96 270.10 OpenBenchmarking.org
ClickHouse 100M Rows Hits Dataset, First Run / Cold Cache OpenBenchmarking.org Queries Per Minute, Geo Mean, More Is Better ClickHouse 22.12.3.5 100M Rows Hits Dataset, First Run / Cold Cache b d c e a 50 100 150 200 250 SE +/- 2.76, N = 4 SE +/- 0.56, N = 3 SE +/- 3.06, N = 3 SE +/- 2.37, N = 3 SE +/- 0.43, N = 3 243.36 239.50 238.77 235.63 234.34 MIN: 12.25 / MAX: 10000 MIN: 12.21 / MAX: 8571.43 MIN: 12.11 / MAX: 7500 MIN: 12.57 / MAX: 8571.43 MIN: 12.03 / MAX: 7500
ClickHouse 100M Rows Hits Dataset, Second Run OpenBenchmarking.org Queries Per Minute, Geo Mean, More Is Better ClickHouse 22.12.3.5 100M Rows Hits Dataset, Second Run d b c e a 60 120 180 240 300 SE +/- 3.16, N = 3 SE +/- 2.04, N = 4 SE +/- 1.79, N = 3 SE +/- 3.51, N = 3 SE +/- 1.35, N = 3 271.36 268.10 266.17 260.96 260.89 MIN: 15.15 / MAX: 10000 MIN: 12.66 / MAX: 12000 MIN: 15.09 / MAX: 8571.43 MIN: 16.93 / MAX: 10000 MIN: 15.22 / MAX: 10000
ClickHouse 100M Rows Hits Dataset, Third Run OpenBenchmarking.org Queries Per Minute, Geo Mean, More Is Better ClickHouse 22.12.3.5 100M Rows Hits Dataset, Third Run b d e c a 60 120 180 240 300 SE +/- 1.84, N = 4 SE +/- 2.08, N = 3 SE +/- 1.59, N = 3 SE +/- 3.27, N = 3 SE +/- 3.48, N = 3 273.87 271.10 270.10 268.27 265.94 MIN: 15.04 / MAX: 12000 MIN: 15.05 / MAX: 10000 MIN: 15.34 / MAX: 10000 MIN: 15.03 / MAX: 10000 MIN: 16.82 / MAX: 10000
Phoronix Test Suite v10.8.5