v.25.9Improvement

Respect memory limits in some places

Respect memory limits in some places that are known to allocate significant (>16MiB) amount of memory (sorting, async inserts, file log). #87035 (Azat Khuzhin).
This feature improves ClickHouse by enforcing memory limits in operations that allocate a significant amount of memory (more than 16 MiB), such as sorting, asynchronous inserts, and file logging.

Why it matters

The motivation behind this improvement is to prevent excessive memory consumption during heavy operations, which can lead to instability or resource exhaustion. By respecting memory limits in these critical areas, it helps maintain system stability and ensures better resource management for users.

How to use it

This feature is applied internally in ClickHouse and requires no explicit user action to enable. Memory limits can be configured via existing settings related to query resource management, and the improved enforcement will automatically apply to sorting, async inserts, and file logging operations.