Introduces tiered storage support for MergeTree tables, allowing data to be automatically stored across multiple storage volumes such as SSDs and HDDs.
Why it matters
This feature enables optimized storage management by keeping fresh, frequently accessed data on faster SSDs while automatically moving older, less accessed data to cheaper, slower HDDs. It improves performance and cost efficiency for managing large datasets.How to use it
Configure tiered storage by specifying multiple storage volumes for a MergeTree table in its settings. Data is initially written to the faster storage (e.g., SSD) and moved automatically to slower storage (e.g., HDD) based on data age or retention policies. See the example usage in the ClickHouse presentations linked.