Aiven for ClickHouse® 26.3 LTS: Full-Text Search, Async Inserts, and Materialized CTEs

Aiven for ClickHouse 26.3 introduces a range of enhancements, including the general availability of full-text search, default asynchronous inserts, and materialized common table expressions, alongside numerous JSON and query-performance optimizations. The update features 27 new capabilities and 40 performance enhancements, with significant improvements in text indexing for faster searches, asynchronous inserts for better throughput, and experimental support for materialized CTEs to optimize repeated query work. Additionally, the release includes native geospatial support, smarter join reordering, and various quality-of-life improvements like more readable query plans and faster map lookups. The update also presents experimental features such as the QBit vector type for vector search and a polyglot SQL transpiler. Due to the substantial changes, users are advised to test the upgrade on a forked service before applying it to production, ensuring compatibility and reviewing any behavioral changes.

Use this post, company, and trend context to find content marketing opportunities, perform competitive analysis, or address product feature gaps via the Plushcap MCP server or the Plushcap API.