August 2026 newsletter

Summary

The August 2026 newsletter rounds up ClickHouse product releases, research, managed services, observability, community work, and upcoming events. It introduces Andy Pavlo’s arrival to establish ClickHouse Labs, describes the 26.7 release’s join optimizations, token-position text indexes, and EXPLAIN ANALYZE, and reports a 40× phrase-search improvement on a Hacker News dataset. It also covers an interactive ClickBench playground for more than 100 database systems, running isolated workloads in Firecracker microVMs on AWS EC2, plus guidance on combining Postgres for mutable data with ClickHouse for immutable analytical workloads. Additional items address Managed Postgres notifications and backups, TTL-related disk growth, vector-search trade-offs, and hdx-evals, which found a purpose-built ClickStack MCP server scored 7–20 percentage points higher than direct SQL access in five reproducible scenarios.

Takeaways

1. 1

   ClickHouse 26.7 reduces probe-side join input and build-side hash-table size, automatically arranges joins in multi-table queries, adds token positions to text indexes, and introduces EXPLAIN ANALYZE.

2. 2

   The ClickBench playground runs ad hoc queries against a 100m-record dataset across more than 100 database systems using Firecracker microVMs on an AWS EC2 instance for isolation, cost control, and fast startup.

3. 3

   In five reproducible incident-investigation scenarios, the purpose-built ClickStack MCP server scored 7–20 percentage points higher than giving agents direct SQL access through the ClickHouse MCP server.