ClickHouse Deletes Expired TTL Rows Only When Parts Merge
ClickHouse stores a per-part TTL expiry bound and removes expired rows during a merge, using a bit mask rather than a rewrite.
Ttl
How ClickHouse Recompresses a Part When Its TTL Expires
A RECOMPRESS TTL rewrites a whole part with a new codec once all of its rows have expired.