--- title: ClickHouse Release 26.3 | daily.dev description: ClickHouse 26.3 LTS ships several notable improvements. Materialized CTEs (WITH ... AS MATERIALIZED) are now supported, evaluating subqueries once and storing... canonical: https://daily.dev/posts/clickhouse-release-26-3-er4ubo4s4 twitter:card: summary_large_image twitter:site: @dailydotdev og:type: website og:site_name: daily.dev og:title: ClickHouse Release 26.3 | daily.dev og:description: ClickHouse 26.3 LTS ships several notable improvements. Materialized CTEs (WITH ... AS MATERIALIZED) are now supported, evaluating subqueries once and storing... og:url: https://daily.dev/posts/clickhouse-release-26-3-er4ubo4s4 og:image: https://api.daily.dev/og/posts/Er4Ubo4s4.png og:image:alt: ClickHouse Release 26.3 og:image:width: 1200 og:image:height: 630 og:locale: en --- > ## Documentation Index > Fetch the complete documentation index at: https://daily.dev/llms.txt > Use this file to discover all available pages before exploring further. # ClickHouse Release 26.3 **[ClickHouse](https://daily.dev/sources/clickhouse)** · 12 min read · 9 upvotes · 0 comments ## Summary ClickHouse 26.3 LTS ships several notable improvements. Materialized CTEs (WITH ... AS MATERIALIZED) are now supported, evaluating subqueries once and storing results in temporary tables for significant query speedups — roughly 2x faster in benchmarks. Asynchronous inserts are now enabled by default, automatically batching small writes server-side without configuration changes. JOIN reordering now covers all major join types including ANTI, SEMI, and FULL joins. TTL DELETE operations can now leverage vertical merges, reducing memory usage for wide-table observability workloads. The Map data type gains a new bucketed storage format that splits keys into hash-based buckets during background merges, dramatically reducing data scanned for single-key lookups. The release also fixes JSONExtract functions to work directly on the JSON type. ## Full article daily.dev links to this article rather than hosting it. Read it at the original source: ## Similar posts on daily.dev - [ClickHouse Release 26.4](https://daily.dev/posts/clickhouse-release-26-4-9kszqbsdn) · ClickHouse · 7 upvotes · 0 comments - [ClickHouse Release 26.7](https://daily.dev/posts/clickhouse-release-26-7-8dsprk7ep) · ClickHouse · 3 upvotes · 0 comments - [ClickHouse Release 26.2](https://daily.dev/posts/clickhouse-release-26-2-s8argzwrd) · ClickHouse · 1 upvotes · 0 comments - [ClickHouse Release 26.1](https://daily.dev/posts/clickhouse-release-26-1-j8qvummhl) · ClickHouse · 1 upvotes · 0 comments - [ClickHouse Release 26.6](https://daily.dev/posts/clickhouse-release-26-6-3hujlqnzt) · ClickHouse · 1 upvotes · 0 comments --- Tags: [#backend](https://daily.dev/tags/backend), [#clickhouse](https://daily.dev/tags/clickhouse) [View this post on daily.dev](https://daily.dev/posts/clickhouse-release-26-3-er4ubo4s4) ```json {"@context":"https://schema.org","@graph":[{"@type":"Organization","@id":"https://daily.dev/#organization","name":"daily.dev","url":"https://daily.dev","logo":{"@type":"ImageObject","url":"https://daily.dev/apple-touch-icon.png","width":180,"height":180},"sameAs":["https://twitter.com/dailydotdev","https://github.com/dailydotdev","https://www.linkedin.com/company/daily-dev-ltd"]},{"@type":"WebSite","@id":"https://daily.dev/#website","url":"https://daily.dev","name":"daily.dev","publisher":{"@id":"https://daily.dev/#organization"},"potentialAction":{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https://daily.dev/search?q={search_term_string}"},"query-input":"required name=search_term_string"}}]} {"@context":"https://schema.org","@type":"TechArticle","headline":"ClickHouse Release 26.3","url":"https://daily.dev/posts/clickhouse-release-26-3-er4ubo4s4","mainEntityOfPage":{"@type":"WebPage","@id":"https://daily.dev/posts/clickhouse-release-26-3-er4ubo4s4"},"datePublished":"2026-04-07T09:46:27.237Z","dateModified":"2026-04-07T09:46:59.878Z","description":"ClickHouse 26.3 LTS ships several notable improvements. Materialized CTEs (WITH ... AS MATERIALIZED) are now supported, evaluating subqueries once and storing...","image":"https://media.daily.dev/image/upload/f_auto,q_auto/v1/posts/db34422f64f2e67e58297d3ddb097693?_a=AQAEuop","thumbnailUrl":"https://media.daily.dev/image/upload/f_auto,q_auto/v1/posts/db34422f64f2e67e58297d3ddb097693?_a=AQAEuop","isAccessibleForFree":true,"articleSection":"ClickHouse","inLanguage":"en","publisher":{"@type":"Organization","name":"daily.dev","url":"https://daily.dev","logo":{"@type":"ImageObject","url":"https://daily.dev/apple-touch-icon.png","width":180,"height":180}},"author":{"@type":"Organization","name":"ClickHouse","logo":"https://media.daily.dev/image/upload/t_logo,f_auto/v1/logos/clickhouse","url":"https://daily.dev/sources/clickhouse"},"commentCount":0,"discussionUrl":"https://daily.dev/posts/clickhouse-release-26-3-er4ubo4s4","interactionStatistic":[{"@type":"InteractionCounter","interactionType":{"@type":"LikeAction"},"userInteractionCount":9},{"@type":"InteractionCounter","interactionType":{"@type":"CommentAction"},"userInteractionCount":0}],"keywords":"backend,clickhouse","timeRequired":"PT12M"} {"@context":"https://schema.org","@type":"BreadcrumbList","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https://daily.dev"},{"@type":"ListItem","position":2,"name":"ClickHouse","item":"https://daily.dev/sources/clickhouse"},{"@type":"ListItem","position":3,"name":"ClickHouse Release 26.3"}]} ```