Enabled async_socket_for_remote by default for distributed queries

Why it matters

This feature reduces the number of operating system threads used during distributed query execution, optimizing resource usage and enhancing query performance in distributed environments.

How to use it

The async_socket_for_remote setting is now enabled by default, so no additional configuration is required to benefit from this optimization. Users can explicitly manage this setting in the server configuration if needed.