v.20.3Improvement

Allow Disk Allocation for Downloaded Parts Based on TTL Rules

Allow to put downloaded part to a disks/volumes according to TTL rules #8598 (Vladimir Chebotarev)
ClickHouse now supports placing downloaded parts on specific disks or volumes based on TTL (time-to-live) rules.

Why it matters

This feature enables more efficient and automated storage management by allowing parts of data to be moved to designated disks or volumes according to TTL rules. This helps optimize disk usage and data lifecycle management, improving both performance and cost-effectiveness.

How to use it

Users can define TTL rules with disk or volume placement directives in the table schema using the TTL clause. When data parts expire according to TTL conditions, ClickHouse will automatically move these parts to the specified disks or volumes.