---
title: "June 2026 newsletter"
description: "ClickHouse’s June 2026 newsletter marks the project’s ten years as open source, noting more than 2,000 contributors and community projects alongside engineering updates. It profiles Vasily Chekalkin’s 26.5 improvements to WebAssembly user-defined functions, including the DETERMINISTIC keyword and visibility in system.functions, and covers native Jaeger storage, the ClickCannon benchmark tool, and Open House announcements. The 26.5 release reports Top-N optimizations that make ORDER BY … LIMIT through JOIN 20.4× faster with 175× less memory on TPC-H SF100, while GROUP BY … LIMIT is 11.9× faster with 185× less peak memory. Other featured systems include a 15-million-rows-per-hour KPI pipeline, join-engineering work yielding a 26× improvement on join-heavy TPC-H workloads, and community guidance on inserts, columnar storage, ArrowStream, and RAG ingestion."
---

# June 2026 newsletter

[Clickhouse](https://yomu.fyi/company/clickhouse) · Jun 18, 2026

**Type:** Announcement

## Summary

ClickHouse’s June 2026 newsletter marks the project’s ten years as open source, noting more than 2,000 contributors and community projects alongside engineering updates. It profiles Vasily Chekalkin’s 26.5 improvements to WebAssembly user-defined functions, including the DETERMINISTIC keyword and visibility in system.functions, and covers native Jaeger storage, the ClickCannon benchmark tool, and Open House announcements. The 26.5 release reports Top-N optimizations that make ORDER BY … LIMIT through JOIN 20.4× faster with 175× less memory on TPC-H SF100, while GROUP BY … LIMIT is 11.9× faster with 185× less peak memory. Other featured systems include a 15-million-rows-per-hour KPI pipeline, join-engineering work yielding a 26× improvement on join-heavy TPC-H workloads, and community guidance on inserts, columnar storage, ArrowStream, and RAG ingestion.

## Context

The newsletter commemorates ClickHouse’s ten-year open-source anniversary and rounds up engineering updates, community contributions, product announcements, technical articles, and upcoming events.

## Approach / What changed

The issue presents performance changes and systems work across ClickHouse, including WebAssembly UDF enhancements, Top-N and join optimizations, native ClickHouse support in Jaeger, ClickCannon workload benchmarking, flat-column KPI storage, and community-built geospatial and RAG functionality.

## Takeaways

- ClickHouse 26.5 reports that pushing ORDER BY … LIMIT through a JOIN was 20.4× faster with 175× less memory on TPC-H SF100; GROUP BY … LIMIT was 11.9× faster with 185× less peak memory.
- WASM UDFs in 26.5 can use the DETERMINISTIC keyword and appear in system.functions with argument and return types, improving optimizer integration and introspection.
- Native ClickHouse support in Jaeger v2.18.0 reached more than 50,000 spans per second, 8.6× compression, and sub-50ms search latency across 10 million spans in a single-node benchmark.

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

- Source: [Clickhouse](https://clickhouse.com/blog/202606-newsletter)
- Source URL: https://clickhouse.com/blog/202606-newsletter
- Ingested by Yomu: 2026-08-29T01:35:36.740Z

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