v.23.5Improvement
Added async_insert Setting for MergeTree Tables
Added settingasync_insertforMergeTreetables. It has the same meaning as query-level settingasync_insertand enables asynchronous inserts for specific table. Note: it doesn't take effect for insert queries fromclickhouse-client, use query-level setting in that case. #49122 (Anton Popov).
Why it matters
This feature allows users to enable asynchronous inserts directly on specificMergeTree tables, providing greater flexibility and control without relying solely on query-level settings. It helps optimize insert performance for targeted tables by decoupling insert operations from synchronous execution.How to use it
To enable asynchronous inserts for aMergeTree table, set the async_insert setting at the table level when creating or altering the table. Note that this setting does not affect inserts executed from clickhouse-client; for those cases, use the query-level async_insert setting instead.