According to a recent LinkedIn post from ClickHouse, the company is highlighting the release of ClickHouse 26.3 LTS, with materialized common table expressions (CTEs) presented as the key enhancement. The post indicates that materialized CTEs can be enabled to cache results so repeated references to the same CTE may reduce query compute costs and improve performance.
Claim 30% Off TipRanks
- Unlock hedge fund-level data and powerful investing tools for smarter, sharper decisions
- Discover top-performing stock ideas and upgrade to a portfolio of market leaders with Smart Investor Picks
The post also points to several additional technical improvements, including asynchronous inserts enabled by default to support automatic batching, sharded Map storage reportedly delivering significantly faster single-key lookups, join reordering across major join types, and more readable query plans via a “Pretty EXPLAIN” feature. For investors, this type of long-term support release suggests ongoing product maturation aimed at higher performance and developer productivity, which could strengthen ClickHouse’s position in the analytical database market and support customer retention and expansion over time.