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.
Compare your own system(s) to this result file with the
Phoronix Test Suite by running the command:
phoronix-test-suite benchmark 2301117-NE-TIGERLAKE97 tigerlake clickhouse - Phoronix Test Suite 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&grt&sor .
tigerlake clickhouse Processor Motherboard Chipset Memory Disk Graphics Audio Network OS Kernel Desktop Display Server OpenGL Vulkan Compiler File-System Screen Resolution a b c d Intel Core i7-1165G7 @ 4.70GHz (4 Cores / 8 Threads) Dell 0GG9PT (3.11.0 BIOS) Intel Tiger Lake-LP 16GB Kioxia KBG40ZNS256G NVMe 256GB Intel Xe TGL GT2 15GB (1300MHz) Realtek ALC289 Intel Wi-Fi 6 AX201 Ubuntu 22.10 5.19.0-26-generic (x86_64) GNOME Shell 43.0 X Server + Wayland 4.6 Mesa 22.2.1 1.3.224 GCC 12.2.0 ext4 1920x1200 OpenBenchmarking.org Kernel Details - Transparent Huge Pages: madvise Processor 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 clickhouse 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 82.16 98.30 99.39 93.29 106.66 105.68 97.36 109.52 110.47 87.61 104.99 104.43 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 c b d a 20 40 60 80 100 SE +/- 4.00, N = 7 97.36 93.29 87.61 82.16 MIN: 2.62 / MAX: 5000 MIN: 2.63 / MAX: 4285.71 MIN: 2.62 / MAX: 4615.38 MIN: 2.3 / MAX: 4285.71
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 c b d a 20 40 60 80 100 SE +/- 1.64, N = 7 109.52 106.66 104.99 98.30 MIN: 2.62 / MAX: 6000 MIN: 2.65 / MAX: 6666.67 MIN: 2.64 / MAX: 6000 MIN: 2.54 / MAX: 6000
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 c b d a 20 40 60 80 100 SE +/- 0.85, N = 7 110.47 105.68 104.43 99.39 MIN: 2.63 / MAX: 6000 MIN: 2.64 / MAX: 5454.55 MIN: 2.64 / MAX: 5000 MIN: 2.6 / MAX: 6666.67
Phoronix Test Suite v10.8.5