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

merge_checkpoints_min_bytes

The minimum total size of the source parts of a merge, in bytes, to checkpoint it with enable_merge_checkpoints. Smaller merges are not checkpointed: they are cheap to repeat.

merge_checkpoints_min_interval_seconds

The minimum time between two checkpoints of a merge with enable_merge_checkpoints. A vertical merge always checkpoints once its key columns are merged. After that, it checkpoints after a completed column only when this much time has passed since its previous checkpoint.

merge_total_max_bytes_to_prewarm_cache

Only available in ClickHouse Cloud. Maximal size of parts in total to prewarm cache during merge.

merge_use_batch_sorting_queue

Use the batch sorting queue to reduce per-row queue overhead when merging sorted streams. Only applies to merges that do not change rows: the merges of plain MergeTree parts (Ordinary merge mode) and of normal projection parts. The merges of parts of engines with merge-time semantics, such as ReplacingMergeTree, CollapsingMergeTree, SummingMergeTree, AggregatingMergeTree, CoalescingMergeTree, GraphiteMergeTree and VersionedCollapsingMergeTree, and of aggregate projection parts keep using the default queue regardless of this setting.

merge_workload

Used to regulate how resources are utilized and shared between merges and other workloads. Specified value is used as workload setting value for background merges of this table. If not specified (empty string), then server setting merge_workload is used instead. See Also