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&rdt.

clickhouse 7950xProcessorMotherboardChipsetMemoryDiskGraphicsAudioMonitorNetworkOSKernelDesktopDisplay ServerOpenGLVulkanCompilerFile-SystemScreen ResolutionabcdeAMD Ryzen 9 7950X 16-Core @ 4.50GHz (16 Cores / 32 Threads)ASUS ROG CROSSHAIR X670E HERO (0805 BIOS)AMD Device 14d832GBWestern Digital WD_BLACK SN850X 1000GB + 2000GBAMD Radeon RX 6800 XT 16GB (2575/1000MHz)AMD Navi 21/23ASUS MG28UIntel I225-V + Intel Wi-Fi 6 AX210/AX211/AX411Ubuntu 22.106.2.0-rc1-phx (x86_64)GNOME Shell 43.1X Server + Wayland4.6 Mesa 22.2.1 (LLVM 15.0.2 DRM 3.49)1.3.224GCC 12.2.0ext43840x2160OpenBenchmarking.orgKernel Details- Transparent Huge Pages: madviseProcessor 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 7950xclickhouse: 100M Rows Hits Dataset, First Run / Cold Cacheclickhouse: 100M Rows Hits Dataset, Second Runclickhouse: 100M Rows Hits Dataset, Third Runabcde234.34260.89265.94243.36268.10273.87238.77266.17268.27239.50271.36271.10235.63260.96270.10OpenBenchmarking.org

ClickHouse

100M Rows Hits Dataset, First Run / Cold Cache

OpenBenchmarking.orgQueries Per Minute, Geo Mean, More Is BetterClickHouse 22.12.3.5100M Rows Hits Dataset, First Run / Cold Cacheabcde50100150200250SE +/- 0.43, N = 3SE +/- 2.76, N = 4SE +/- 3.06, N = 3SE +/- 0.56, N = 3SE +/- 2.37, N = 3234.34243.36238.77239.50235.63MIN: 12.03 / MAX: 7500MIN: 12.25 / MAX: 10000MIN: 12.11 / MAX: 7500MIN: 12.21 / MAX: 8571.43MIN: 12.57 / MAX: 8571.43

ClickHouse

100M Rows Hits Dataset, Second Run

OpenBenchmarking.orgQueries Per Minute, Geo Mean, More Is BetterClickHouse 22.12.3.5100M Rows Hits Dataset, Second Runabcde60120180240300SE +/- 1.35, N = 3SE +/- 2.04, N = 4SE +/- 1.79, N = 3SE +/- 3.16, N = 3SE +/- 3.51, N = 3260.89268.10266.17271.36260.96MIN: 15.22 / MAX: 10000MIN: 12.66 / MAX: 12000MIN: 15.09 / MAX: 8571.43MIN: 15.15 / MAX: 10000MIN: 16.93 / MAX: 10000

ClickHouse

100M Rows Hits Dataset, Third Run

OpenBenchmarking.orgQueries Per Minute, Geo Mean, More Is BetterClickHouse 22.12.3.5100M Rows Hits Dataset, Third Runabcde60120180240300SE +/- 3.48, N = 3SE +/- 1.84, N = 4SE +/- 3.27, N = 3SE +/- 2.08, N = 3SE +/- 1.59, N = 3265.94273.87268.27271.10270.10MIN: 16.82 / MAX: 10000MIN: 15.04 / MAX: 12000MIN: 15.03 / MAX: 10000MIN: 15.05 / MAX: 10000MIN: 15.34 / MAX: 10000


Phoronix Test Suite v10.8.4