Set up docs MCPThese settings are available in system.merge_tree_settings and are autogenerated from the ClickHouse snapshot.
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.