v.20.10New Feature

Background Data Recompression: Specify TTL RECOMPRESS Codec for MergeTree Tables

Official CH changelog text
Background data recompression. Add the ability to specify TTL ... RECOMPRESS codec_name for MergeTree table engines family. #14494 (alesapin).
Introduces background data recompression using TTL ... RECOMPRESS codec_name for MergeTree family table engines in ClickHouse.

Why it matters

This feature allows automatic recompression of existing data parts in the background, enabling better control over storage optimization and potential improvements in disk space usage without manual intervention.

How to use it

Users can specify a TTL expression with the RECOMPRESS codec_name directive in the table definition for MergeTree engines. This sets up background recompression of data parts using the chosen codec after the TTL condition is met.

Related resources

PreviousNext