# Smarter Auto-Scaling for ClickHouse: The Two-Window Approach

DevFeed: [Smarter Auto-Scaling for ClickHouse: The Two-Window Approach](<https://devfeed.tech/articles/smarter-auto-scaling-for-clickhouse-the-two-window-approach-5573.md>)

Original publisher: [Read original article](<https://clickhouse.com/blog/smarter-auto-scaling>)

Author: Ashwath Singh; Manas Alekar

Published: 2026-03-24T00: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>), [autoscaling](<https://devfeed.tech/topics/autoscaling.md>), [cpu](<https://devfeed.tech/topics/cpu.md>), [Latency](<https://devfeed.tech/topics/latency.md>), [Cloud](<https://devfeed.tech/topics/cloud.md>), [Provisioning](<https://devfeed.tech/topics/provisioning.md>)

Tags: [clickhouse](<https://devfeed.tech/tags/clickhouse.md>), [cloud](<https://devfeed.tech/tags/cloud.md>), [cost](<https://devfeed.tech/tags/cost.md>), [cpu](<https://devfeed.tech/tags/cpu.md>), [infrastructure](<https://devfeed.tech/tags/infrastructure.md>), [performance](<https://devfeed.tech/tags/performance.md>), [production](<https://devfeed.tech/tags/production.md>), [resource](<https://devfeed.tech/tags/resource.md>), [scale](<https://devfeed.tech/tags/scale.md>)

## AI overview

ClickHouse Cloud's two-window recommender combines a 3-hour lookback for faster scale-downs with a 30-hour lookback for stable, rapid scale-ups. Paired with target-tracking CPU recommendations, the approach reduces scaling latency and oscillations while lowering infrastructure costs for variable workloads.

## Source excerpt

How ClickHouse Cloud's two-window recommender and target-tracking CPU algorithm cut scale-down latency from 30 hours to 3 hours while eliminating oscillations and reducing infrastructure costs.