v.21.6Improvement

Added Background Buffer Flushing for Buffer Tables

Added ability to flush buffer only in background for Buffer tables. #22986 (Azat Khuzhin).
Added the ability to flush the buffer only in the background for Buffer tables in ClickHouse.

Why it matters

This feature allows users to control the flushing behavior of Buffer tables by enabling flushing exclusively in the background, reducing potential performance impacts caused by synchronous flushing operations and improving write efficiency.

How to use it

Users can enable background-only flushing for Buffer tables by configuring the buffer table settings accordingly, ensuring that flushing occurs only asynchronously in the background without blocking insert operations.