# Optimizing ClickHouse for Intel's ultra-high core count processors

DevFeed: [Optimizing ClickHouse for Intel's ultra-high core count processors](<https://devfeed.tech/articles/optimizing-clickhouse-for-intel-s-ultra-high-core-count-processors-5469.md>)

Original publisher: [Read original article](<https://clickhouse.com/blog/optimizing-clickhouse-intel-high-core-count-cpu>)

Author: Jiebin Sun, Zhiguo Zhou, Wangyang Guo, Tianyou Li

Published: 2025-09-17T00:00:00Z

Content type: article

Language: en

Sources: [ClickHouse Blog](<https://devfeed.tech/sources/clickhouse-blog.md>)

Topics: [clickhouse](<https://devfeed.tech/topics/clickhouse.md>), [Optimization](<https://devfeed.tech/topics/optimization.md>), [Scalability](<https://devfeed.tech/topics/scalability.md>), [intel](<https://devfeed.tech/topics/intel.md>), [cpu](<https://devfeed.tech/topics/cpu.md>), [Databases](<https://devfeed.tech/topics/databases.md>), [systems](<https://devfeed.tech/topics/systems.md>)

Tags: [clickhouse](<https://devfeed.tech/tags/clickhouse.md>), [databases](<https://devfeed.tech/tags/databases.md>), [hardware](<https://devfeed.tech/tags/hardware.md>), [intel](<https://devfeed.tech/tags/intel.md>), [optimization](<https://devfeed.tech/tags/optimization.md>), [performance](<https://devfeed.tech/tags/performance.md>), [processors](<https://devfeed.tech/tags/processors.md>), [scalability](<https://devfeed.tech/tags/scalability.md>), [systems](<https://devfeed.tech/tags/systems.md>)

## AI overview

This guest article explains efforts to optimize ClickHouse for Intel ultra-high core count processors. It examines scalability challenges such as lock contention, cache coherence, NUMA, memory bandwidth, and coordination overhead, and reports performance improvements from systematic profiling and query-specific optimizations across 43 ClickBench queries.

## Source excerpt

Intel's latest processor generations are pushing the number of cores in a server to unprecedented levels. For analytical databases like ClickHouse, ultra-high core counts represent a huge opportunity and a complex challenge.