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 .
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 a b c d e 50 100 150 200 250 SE +/- 0.43, N = 3 SE +/- 2.76, N = 4 SE +/- 3.06, N = 3 SE +/- 0.56, N = 3 SE +/- 2.37, N = 3 234.34 243.36 238.77 239.50 235.63 MIN: 12.03 / MAX: 7500 MIN: 12.25 / MAX: 10000 MIN: 12.11 / MAX: 7500 MIN: 12.21 / MAX: 8571.43 MIN: 12.57 / MAX: 8571.43
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 a b c d e 60 120 180 240 300 SE +/- 1.35, N = 3 SE +/- 2.04, N = 4 SE +/- 1.79, N = 3 SE +/- 3.16, N = 3 SE +/- 3.51, N = 3 260.89 268.10 266.17 271.36 260.96 MIN: 15.22 / MAX: 10000 MIN: 12.66 / MAX: 12000 MIN: 15.09 / MAX: 8571.43 MIN: 15.15 / MAX: 10000 MIN: 16.93 / 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 a b c d e 60 120 180 240 300 SE +/- 3.48, N = 3 SE +/- 1.84, N = 4 SE +/- 3.27, N = 3 SE +/- 2.08, N = 3 SE +/- 1.59, N = 3 265.94 273.87 268.27 271.10 270.10 MIN: 16.82 / MAX: 10000 MIN: 15.04 / MAX: 12000 MIN: 15.03 / MAX: 10000 MIN: 15.05 / MAX: 10000 MIN: 15.34 / MAX: 10000
Phoronix Test Suite v10.8.5