Skip to content
Download full logoDownload logomark

June 2026 newsletter

mark needham
Mark Needham
Jun 18, 2026 · 8 minutes read

Ten years ago this month, we released ClickHouse as an open-source project. What started as a prototype I built to solve a real data problem has grown into something I could not have imagined: 2,000 contributors, users on every continent, and a community that continues to push the project further than any single team could.

In this issue, you will find our own engineering updates alongside stories from community members building real systems with ClickHouse. Seeing people share what they have built is one of the best parts of having an open community.

Here's to the next ten years.

— Alexey Milovidov, inventor of ClickHouse

Featured community member: Vasily Chekalkin

This month's featured community member is Vasily Chekalkin, Staff Engineer at Neara in Sydney, Australia.

Vasily contributed a series of improvements to ClickHouse's WebAssembly (WASM) user-defined functions in the 26.5 release.

He added a DETERMINISTIC keyword, which means WASM UDFs can be declared as pure functions, making them eligible for constant folding and widening coercions for arguments. He also made WASM UDFs visible in system.functions with their argument and return types. Together, these changes make WASM UDFs easier to introspect and better integrated with the query optimizer.

To see what's possible when you push WASM UDFs to their limits, check out his side project chgeos - PostGIS-compatible spatial functions for ClickHouse (ST_Intersects, ST_Buffer, ST_Within, and more) delivered as a WASM module powered by GEOS 3.12+.

Beyond WASM UDFs, Vasily is a regular contributor across ClickHouse's Geospatial and Iceberg functionality, from fixing WKT parsing to propagating table UUIDs from the Iceberg REST catalog.

➡️ Connect with Vasily on LinkedIn

Ten years of ClickHouse in open source

Alexey Milovidov kicked off the 10-year anniversary week with the full origin story.

It starts with a 2008 prototype built to keep up with web analytics data that was growing faster than any existing database could handle, runs through the open-source release on June 15, 2016, and reflects on what it means to build truly in the open, with 2,000+ contributors and counting.

➡️ Read the blog post

26.5 release

ClickHouse 26.5 sees some important performance optimizations, particularly around Top-N queries - those that sort or group a large dataset only to return a handful of rows.

Pushing ORDER BY … LIMIT through a JOIN (20.4× faster with 175× less memory on TPC-H SF100) and supporting GROUP BY … LIMIT without an ORDER BY (11.9× faster and 185× less peak memory) both let ClickHouse stop work early instead of processing rows it will only throw away later.

➡️ Read the release post

Open House 2026 announcements

We hosted our annual Open House conference a few weeks ago in San Francisco and detailed all the announcements in this blog post.

Highlights included ClickHouse Postgres, a managed Postgres service that achieved 5x+ more transactions/sec than AWS RDS, and ClickHouse Agents, a new agentic analytics service powered by Claude with a native chat interface and a no-code agent builder.

➡️ Read about the announcements

Introducing native ClickHouse support in Jaeger

Mahad Zaryab walks through the design decisions behind native ClickHouse support in Jaeger v2.18.0, the most-requested storage backend from users running Jaeger at scale.

On a single-node benchmark, it achieved an ingestion rate of 50,000+ spans per second, with 8.6× compression, and sub-50ms search latency across 10 million spans.

➡️ Read the blog post

Building ClickCannon: a tool for benchmarking ClickHouse

Spencer Torres introduces ClickCannon, an open-source benchmarking tool for ClickHouse that grew out of internal work to build sizing recommendations for ClickStack.

It replays real production data at controlled throughput, simulates concurrent user query patterns, and decouples disk and insert workers, allowing each to be scaled independently, giving teams a flexible framework for testing any ClickHouse insert and query workload.

➡️ Read the blog post

Building a high-throughput KPI pipeline on ClickHouse: partitioning, idempotent recalculation, and flat column storage

Mobin Shaterian details three ClickHouse-specific design decisions behind a telecom KPI pipeline processing 15 million rows per hour.

The pipeline uses ALTER TABLE … DELETE scoped to a time window for idempotent recalculation, stores hundreds of KPIs as flat columns for compression and query simplicity, and merges sparse KPI sources with CTEs and FULL OUTER JOIN so cells with missing data still land in the right row.

➡️ Read the blog post

How ClickHouse became fast at joins

Tom Schreiber charts two years of focused join engineering that made ClickHouse 26× faster on TPC-H SF100 join-heavy workloads.

Year one laid the foundation with parallel hash join as the default, smarter filter pushdown, and local join reordering.

In year two, we added correlated subquery support, lazy column replication, runtime filters, and statistics-based join reordering, the last of which dropped a six-table query from 3,903 seconds to 2.7 seconds.

➡️ Read the blog post

Quick reads

Get started today

Interested in seeing how ClickHouse works on your data? Get started with ClickHouse Cloud in minutes and receive $300 in free credits.

Sign up

Events

Global virtual events

Virtual training

Events in AMER

Events in EMEA

Events in APAC

Share this post

  • Y Combinator icon
  • X icon
  • Bluesky icon
  • Facebook icon
  • LinkedIn icon

Subscribe to our newsletter

Stay informed on feature releases, product roadmap, support, and cloud offerings!

Recent posts

ai best data stack postgres and ch 1
Product

AI needs the best-of-breed data stack: Postgres and ClickHouse

Sai Srirampur · Jul 7, 2026
chdb local data engine banner 1
Engineering

chDB as the Agent's Local Data Engine

Auxten Wang and Nakul Mishra (AWS) · Jul 7, 2026
verihubs customer story cover
User stories

98% faster queries, 50% lower cloud costs: Verihubs’ journey from Postgres to ClickHouse

ClickHouse · Jul 6, 2026
View all Blogs