The March 2026 ClickHouse newsletter covers the 26.2 release featuring time-based block flushing, production-ready text indexes, and 3.2x faster JOINs. Key highlights include: chDB 4 launching with a Pandas-compatible DataStore API; Trigger.dev's TRQL DSL for tenant-isolated multi-tenant ClickHouse queries; general availability of ClickHouse full-text search using native inverted indexes (up to 96% fewer granules scanned); Hookdeck's 60x payload search speedup via hash-bucketed columns and time-window scanning; an agentic data stack using ClickHouse's MCP server with natural language querying; and a production TTL runbook for disk optimization. Additional reads cover geospatial analytics, anomaly detection, table cloning via CLONE AS, and a SecOps agent built on ClickHouse.
Table of contents
Featured community member: Jamie Herre #Upcoming events #26.2 release #Building towards an enterprise-grade Postgres service in ClickHouse Cloud #Announcing chDB 4: Write Pandas, Run ClickHouse, Now on Hex #How Trigger.dev built a custom SQL language on top of ClickHouse #Announcing General Availability of ClickHouse Full-text Search #How we made payload search 60x faster in ClickHouse #The Agentic Data Stack #ClickHouse TTL in production: A safe strategy for data retention and disk optimization #Quick reads #Sort: