v.22.7Improvement

Eliminate SELECT Query Delays After ALTER Queries in Ordinary Databases

Official CH changelog text
Eliminate unnecessary waiting of SELECT queries after ALTER queries in presence of INSERT queries if you use deprecated Ordinary databases. #38864 (Azat Khuzhin).
Eliminate unnecessary waiting of SELECT queries following ALTER queries when INSERT queries are also present in deprecated Ordinary databases.

Why it matters

This feature addresses the issue where SELECT queries would wait unnecessarily after ALTER queries in the presence of concurrent INSERT queries for deprecated Ordinary databases. It improves query execution concurrency and reduces latency for SELECT operations in such scenarios.

How to use it

Users benefit from this improvement automatically when using deprecated Ordinary databases. No special configuration or syntax changes are required to enable this optimization.

Related resources

PreviousNext