v.22.11New Feature

Add min_age_to_force_merge_on_partition_only setting for partition optimization

Add min_age_to_force_merge_on_partition_only setting to optimize old parts for the entire partition only. #42659 (Antonio Andelic).
Introduces the min_age_to_force_merge_on_partition_only setting to optimize only old parts within entire partitions in ClickHouse.

Why it matters

This feature allows users to efficiently optimize old data parts by forcing merges at the partition level, which can improve performance and resource utilization by avoiding unnecessary merges of more recent parts.

How to use it

Set the min_age_to_force_merge_on_partition_only setting in the configuration or query context to specify the minimum age of parts that should be merged only on the partition level. This enables targeted merging of old parts without affecting newer data.