v.23.6Improvement

Relax Thresholds for Parts and Handle Backpressure in Long-Running Inserts

Relax the thresholds for "too many parts" to be more modern. Return the backpressure during long-running insert queries. #50856 (Alexey Milovidov).
Relaxed the thresholds for "too many parts" warnings and restored backpressure during long-running insert queries in ClickHouse.

Why it matters

This feature addresses the issue of overly strict limits on the number of data parts during inserts, which could cause unnecessary interruptions or warnings. By relaxing these thresholds and reinstating backpressure, it improves stability and performance during bulk or prolonged insert operations, preventing system overload and ensuring smoother data ingestion.

How to use it

The feature is applied automatically in the new version with no extra configuration needed. Users will benefit from improved handling of insert queries and more tolerant part count limits out-of-the-box.