---
title: "April 2026 newsletter"
description: "ClickHouse 26.3 LTS introduces experimental materialized common table expressions, WebAssembly user-defined functions, and enables asynchronous inserts by default. Alongside the release, Alasdair Brown launched clickhousectl to manage local installations and cloud deployments with built-in agentic development features and authentication safeguards. User case studies show Goldsky accelerating historical blockchain backfills by twelve times through direct ClickHouse reads using Apache Arrow, replacing their prior Kafka and Avro architecture. Additionally, the engineering team redesigned the full-text search index with front-coding compression, a sparse lookup index, and adaptive posting lists to handle expensive random reads on object storage. ClickHouse also previewed community architecture patterns for lightweight SIEM setups using Clickdetect and Wazuh log collection."
---

# April 2026 newsletter

[Clickhouse](https://yomu.fyi/company/clickhouse) · Mark Needham · Apr 16, 2026

**Type:** Announcement

## Summary

ClickHouse 26.3 LTS introduces experimental materialized common table expressions, WebAssembly user-defined functions, and enables asynchronous inserts by default. Alongside the release, Alasdair Brown launched clickhousectl to manage local installations and cloud deployments with built-in agentic development features and authentication safeguards. User case studies show Goldsky accelerating historical blockchain backfills by twelve times through direct ClickHouse reads using Apache Arrow, replacing their prior Kafka and Avro architecture. Additionally, the engineering team redesigned the full-text search index with front-coding compression, a sparse lookup index, and adaptive posting lists to handle expensive random reads on object storage. ClickHouse also previewed community architecture patterns for lightweight SIEM setups using Clickdetect and Wazuh log collection.

## Context

ClickHouse users and engineers manage evolving database workflows requiring optimized object storage lookups, faster historical data backfills, and streamlined local and cloud server administration.

## Approach / What changed

ClickHouse released version 26.3 LTS with default asynchronous inserts and materialized CTEs, introduced the clickhousectl CLI for human and AI-assisted workflows, and redesigned full-text indexing using front-coding compression and adaptive posting lists.

## Takeaways

- ClickHouse 26.3 LTS introduces experimental materialized CTEs, WebAssembly UDFs, default asynchronous inserts, and JOIN reordering for ANTI, SEMI, and FULL joins.
- Goldsky achieved a 12x speedup in historical blockchain backfills, moving from ~50K to ~600K rows per second, by switching from a Kafka/Avro pipeline to direct ClickHouse reads using Apache Arrow.
- The redesigned full-text search index uses front-coding compression, a sparse lookup index, and adaptive posting lists to answer queries without reading underlying text columns on object storage.

**Tags:** [Data Pipelines](https://yomu.fyi/topic/data-pipelines), [Open Source](https://yomu.fyi/topic/open-source), [Performance](https://yomu.fyi/topic/performance), [Search](https://yomu.fyi/topic/search)

- Source: [Clickhouse](https://clickhouse.com/blog/202604-newsletter)
- Source URL: https://clickhouse.com/blog/202604-newsletter
- Ingested by Yomu: 2026-08-28T01:24:27.720Z

[Read original post](https://clickhouse.com/blog/202604-newsletter)