Skip to main content
These settings are available in system.merge_tree_settings and are autogenerated from ClickHouse source.

​
primary_key_compress_block_size

Primary compress block size, the actual size of the block to compress.

​
primary_key_compression_codec

Compression encoding used by primary, primary key is small enough and cached, so the default compression is ZSTD(3).

​
primary_key_lazy_load

Load primary key in memory on first use instead of on table initialization. This can save memory in the presence of a large number of tables.

​
primary_key_ratio_of_unique_prefix_values_to_skip_suffix_columns

If the value of a column of the primary key in data part changes at least in this ratio of times, skip loading next columns in memory. This allows to save memory usage by not loading useless columns of the primary key.
Last modified on July 23, 2026