tigerlake clickhouse

Intel Core i7-1165G7 testing with a Dell 0GG9PT (3.11.0 BIOS) and Intel Xe TGL GT2 15GB on Ubuntu 22.10 via the Phoronix Test Suite.

HTML result view exported from: https://openbenchmarking.org/result/2301117-NE-TIGERLAKE97&sor&gru.

tigerlake clickhouseProcessorMotherboardChipsetMemoryDiskGraphicsAudioNetworkOSKernelDesktopDisplay ServerOpenGLVulkanCompilerFile-SystemScreen ResolutionabcdIntel Core i7-1165G7 @ 4.70GHz (4 Cores / 8 Threads)Dell 0GG9PT (3.11.0 BIOS)Intel Tiger Lake-LP16GBKioxia KBG40ZNS256G NVMe 256GBIntel Xe TGL GT2 15GB (1300MHz)Realtek ALC289Intel Wi-Fi 6 AX201Ubuntu 22.105.19.0-26-generic (x86_64)GNOME Shell 43.0X Server + Wayland4.6 Mesa 22.2.11.3.224GCC 12.2.0ext41920x1200OpenBenchmarking.orgKernel Details- Transparent Huge Pages: madviseProcessor Details- Scaling Governor: intel_pstate powersave (EPP: balance_performance) - CPU Microcode: 0xa4 - Thermald 2.5.1 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 Enhanced IBRS IBPB: conditional RSB filling PBRSB-eIBRS: SW sequence + srbds: Not affected + tsx_async_abort: Not affected

tigerlake clickhouseclickhouse: 100M Rows Hits Dataset, First Run / Cold Cacheclickhouse: 100M Rows Hits Dataset, Second Runclickhouse: 100M Rows Hits Dataset, Third Runabcd82.1698.3099.3993.29106.66105.6897.36109.52110.4787.61104.99104.43OpenBenchmarking.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 Cachecbda20406080100SE +/- 4.00, N = 797.3693.2987.6182.16MIN: 2.62 / MAX: 5000MIN: 2.63 / MAX: 4285.71MIN: 2.62 / MAX: 4615.38MIN: 2.3 / MAX: 4285.71

ClickHouse

100M Rows Hits Dataset, Second Run

OpenBenchmarking.orgQueries Per Minute, Geo Mean, More Is BetterClickHouse 22.12.3.5100M Rows Hits Dataset, Second Runcbda20406080100SE +/- 1.64, N = 7109.52106.66104.9998.30MIN: 2.62 / MAX: 6000MIN: 2.65 / MAX: 6666.67MIN: 2.64 / MAX: 6000MIN: 2.54 / MAX: 6000

ClickHouse

100M Rows Hits Dataset, Third Run

OpenBenchmarking.orgQueries Per Minute, Geo Mean, More Is BetterClickHouse 22.12.3.5100M Rows Hits Dataset, Third Runcbda20406080100SE +/- 0.85, N = 7110.47105.68104.4399.39MIN: 2.63 / MAX: 6000MIN: 2.64 / MAX: 5454.55MIN: 2.64 / MAX: 5000MIN: 2.6 / MAX: 6666.67

Phoronix Test Suite v10.8.5