v.24.10Improvement

Added max_parts_to_move setting for part movement control

Added a new setting max_parts_to_move to control the maximum number of parts that can be moved at once. #70520 (Vladimir Cherkasov).
Introduced a new setting max_parts_to_move that limits the maximum number of parts that can be moved simultaneously during data operations in ClickHouse.

Why it matters

This setting helps control and manage resource usage and operational load by restricting the number of data parts moved at once, thereby improving stability and performance during merges or other background processes.

How to use it

Users can enable or configure this feature by setting max_parts_to_move to a desired integer value in the ClickHouse settings. For example, in the server configuration file or via SQL: SET max_parts_to_move = N;, where N is the maximum number of parts to move at once.