v.23.8Improvement

Limit Concurrent Background Partition Optimize Merges

Limit number of concurrent background partition optimize merges. #53405 (Duc Canh Le).
Limit the number of concurrent background merges for partition optimization in ClickHouse.

Why it matters

This feature addresses the need to control resource usage by restricting how many background merges for partition optimization can run simultaneously. It helps prevent excessive load from concurrent merges, improving system stability and predictable performance during background optimization tasks.

How to use it

Users can configure the maximum number of concurrent background partition optimize merges via relevant ClickHouse server settings. Adjust this limit according to available system resources to balance optimization speed and system load.