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

allow_experimental_replacing_merge_with_cleanup

Allow experimental CLEANUP merges for ReplacingMergeTree with is_deleted column. When enabled, allows using OPTIMIZE ... FINAL CLEANUP to manually merge all parts in a partition down to a single part and removing any deleted rows. Also allows enabling such merges to happen automatically in the background with settings min_age_to_force_merge_seconds, min_age_to_force_merge_on_partition_only and enable_replacing_merge_with_cleanup_for_min_age_to_force_merge.

allow_experimental_reverse_key

Obsolete setting, does nothing. Allow creating text indexes with the experimental support_phrase_search argument which stores token positions to support exact phrase matching.
Last modified on July 24, 2026