Skip to content
ClickHouse Docs

compress_* MergeTree table settings

Autogenerated from ClickHouse system tables

These settings are available in system.merge_tree_settings and are autogenerated from the ClickHouse snapshot.

compress_marks

Marks support compression, reduce mark file size and speed up network transmission.

compress_per_column_in_compact_parts

Controls the physical layout of Compact parts. If true (default), each column in a granule starts a new compressed block, allowing ClickHouse to skip reading unnecessary columns from disk. If false, all columns within a granule are packed into the same compressed block, improving compression ratio but requiring more data to be decompressed during reads. This is beneficial for workloads that always read all columns (e.g. projections).

compress_primary_key

Primary key support compression, reduce primary key file size and speed up network transmission.