v.25.11Improvement

Allow disabling background download of nearby segments

Allow disabling background download of nearby segments on a per query basis. Fixes #89524. #89668 (tanner-bruce).
Allow disabling background download of nearby segments on a per query basis in ClickHouse.

Why it matters

This feature addresses the need to control and optimize resource usage during query execution by allowing users to disable the automatic background download of nearby segments. It enables more precise management of data loading behavior for queries, which can improve performance and reduce unnecessary network or disk usage.

How to use it

Users can disable the background download of nearby segments by setting the appropriate query setting when executing a query. For example, set the setting to disable background download in the query context or via client configuration to prevent automatic fetching of additional data segments during query execution.