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

​
use_adaptive_write_buffer_for_dynamic_subcolumns

Allow to use adaptive writer buffers during writing dynamic subcolumns to reduce memory usage

​
use_async_block_ids_cache

Obsolete setting, does nothing.

​
use_compact_variant_discriminators_serialization

Enables compact mode for binary serialization of discriminators in Variant data type. This mode allows to use significantly less memory for storing discriminators in parts when there is mostly one variant or a lot of NULL values.

​
use_const_adaptive_granularity

Always use constant granularity for whole part. It allows to compress in memory values of index granularity. It can be useful in extremely large workloads with thin tables.

​
use_metadata_cache

Obsolete setting, does nothing.

​
use_primary_key_cache

Use cache for primary index instead of saving all indexes in memory. Can be useful for very large tables
Last modified on July 22, 2026