merge_checkpoints_min_bytes
The minimum total size of the source parts of a merge, in bytes, to checkpoint it withenable_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 withenable_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 plainMergeTree 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 asworkload setting value for
background merges of this table. If not specified (empty string), then
server setting merge_workload is used instead.
See Also