Set up docs MCPThese settings are available in system.merge_tree_settings and are autogenerated from ClickHouse source.
vertical_merge_algorithm_min_bytes_to_activate
Type
UInt64
Default
0
Minimal (approximate) uncompressed size in bytes in merging parts to activate Vertical merge algorithm.
vertical_merge_algorithm_min_columns_to_activate
Type
UInt64
Default
11
Minimal amount of non-PK columns to activate Vertical merge algorithm.
vertical_merge_algorithm_min_rows_to_activate
Type
UInt64
Default
131072
Minimal (approximate) sum of rows in merging parts to activate Vertical merge algorithm.
vertical_merge_optimize_lightweight_delete
Type
Bool
Default
1
Version history
| Version | Default value | Comment |
|---|---|---|
| 25.9 | 1 | New setting |
If true, lightweight delete is optimized on vertical merge.
vertical_merge_optimize_ttl_delete
Type
Bool
Default
1
Version history
| Version | Default value | Comment |
|---|---|---|
| 26.3 | 1 | Allow vertical merge algorithm for merges that need to remove rows expired by TTL |
If true, rows TTL delete is optimized on vertical merge. Instead of forcing horizontal merge, the TTL filter is evaluated and passed to the merging algorithm which sets skip flags in row sources.
vertical_merge_remote_filesystem_prefetch
Type
Bool
Default
1
If true prefetching of data from remote filesystem is used for the next column during merge