clickhouse raptor lake

Intel Core i9-13900K testing with a ASUS PRIME Z790-P WIFI (0602 BIOS) and AMD Radeon RX 6700 XT 12GB on Ubuntu 22.10 via the Phoronix Test Suite.

HTML result view exported from: https://openbenchmarking.org/result/2301117-PTS-CLICKHOU34&sor&grt.

clickhouse raptor lakeProcessorMotherboardChipsetMemoryDiskGraphicsAudioMonitorNetworkOSKernelDesktopDisplay ServerOpenGLVulkanCompilerFile-SystemScreen ResolutionabcdeIntel Core i9-13900K @ 5.50GHz (24 Cores / 32 Threads)ASUS PRIME Z790-P WIFI (0602 BIOS)Intel Device 7a2732GB2048GB SOLIDIGM SSDPFKKW020X7AMD Radeon RX 6700 XT 12GB (2855/1000MHz)Realtek ALC897ASUS VP28UIntel Device 7a70Ubuntu 22.106.2.0-rc2-phx (x86_64)GNOME Shell 43.1X Server 1.21.1.4 + Wayland4.6 Mesa 23.0.0-devel (git-fc0e23b 2023-01-02 kinetic-oibaf-ppa) (LLVM 15.0.5 DRM 3.49)1.3.238GCC 12.2.0ext43840x2160OpenBenchmarking.orgKernel Details- Transparent Huge Pages: madviseProcessor Details- Scaling Governor: intel_pstate powersave (EPP: balance_performance) - CPU Microcode: 0x10e - Thermald 2.5.1Security 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 Enhanced IBRS IBPB: conditional RSB filling PBRSB-eIBRS: SW sequence + srbds: Not affected + tsx_async_abort: Not affected

clickhouse raptor lakeclickhouse: 100M Rows Hits Dataset, First Run / Cold Cacheclickhouse: 100M Rows Hits Dataset, Second Runclickhouse: 100M Rows Hits Dataset, Third Runabcde280.53303.03306.32282.74298.58307.38282.41305.12309.89279.35305.00308.85283.14305.93306.50OpenBenchmarking.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 Cacheebcad60120180240300SE +/- 2.77, N = 3283.14282.74282.41280.53279.35MIN: 19.01 / MAX: 8571.43MIN: 18.94 / MAX: 7500MIN: 19.17 / MAX: 8571.43MIN: 16.98 / MAX: 8571.43MIN: 17.07 / MAX: 6666.67

ClickHouse

100M Rows Hits Dataset, Second Run

OpenBenchmarking.orgQueries Per Minute, Geo Mean, More Is BetterClickHouse 22.12.3.5100M Rows Hits Dataset, Second Runecdab70140210280350SE +/- 0.03, N = 3305.93305.12305.00303.03298.58MIN: 21.61 / MAX: 10000MIN: 21.99 / MAX: 10000MIN: 21.38 / MAX: 7500MIN: 20.47 / MAX: 10000MIN: 21.09 / MAX: 8571.43

ClickHouse

100M Rows Hits Dataset, Third Run

OpenBenchmarking.orgQueries Per Minute, Geo Mean, More Is BetterClickHouse 22.12.3.5100M Rows Hits Dataset, Third Runcdbea70140210280350SE +/- 2.28, N = 3309.89308.85307.38306.50306.32MIN: 21.28 / MAX: 10000MIN: 23.77 / MAX: 8571.43MIN: 19.16 / MAX: 8571.43MIN: 19.22 / MAX: 7500MIN: 20.7 / MAX: 10000

Phoronix Test Suite v10.8.5