---
title: "March 2026 newsletter"
description: "The March 2026 ClickHouse newsletter details major platform updates, community deployments, and architectural practices for high-throughput analytics. Recent product announcements include ClickHouse 26.2 featuring time-based block flushing for streaming feeds, general availability of native inverted indexes for full-text search, and the release of chDB 4 with a Pandas-compatible DataStore API. Community implementations show Cloudflare managing 1.61 quadrillion daily events, while Trigger.dev isolated multi-tenant SQL execution using a domain-specific query language that compiles safe ClickHouse queries. In data optimization techniques, Hookdeck accelerated webhook payload search from over 30 seconds to under 400 milliseconds by partitioning payload hashes into typed bucket columns and scanning iterative time windows. Additional operational guidance emphasizes setting the ttl_only_drop_parts parameter and aligning table partitioning with time units so background merges drop entire data parts cleanly without triggering mutation rewrites."
---

# March 2026 newsletter

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

**Type:** Announcement

## Summary

The March 2026 ClickHouse newsletter details major platform updates, community deployments, and architectural practices for high-throughput analytics. Recent product announcements include ClickHouse 26.2 featuring time-based block flushing for streaming feeds, general availability of native inverted indexes for full-text search, and the release of chDB 4 with a Pandas-compatible DataStore API. Community implementations show Cloudflare managing 1.61 quadrillion daily events, while Trigger.dev isolated multi-tenant SQL execution using a domain-specific query language that compiles safe ClickHouse queries. In data optimization techniques, Hookdeck accelerated webhook payload search from over 30 seconds to under 400 milliseconds by partitioning payload hashes into typed bucket columns and scanning iterative time windows. Additional operational guidance emphasizes setting the ttl\_only\_drop\_parts parameter and aligning table partitioning with time units so background merges drop entire data parts cleanly without triggering mutation rewrites.

## Context

ClickHouse users and operators face varying challenges across scale and query efficiency, including slow semi-structured payload searches exceeding 30 seconds, multi-tenant data isolation risks in shared clusters, and high disk utilization caused by inefficient TTL background mutations.

## Approach / What changed

The release highlights ClickHouse 26.2 capabilities alongside community solutions, including time-based block flushing, full-text inverted indexes, Hookdeck's typed hash-bucket columns with iterative window scanning, Trigger.dev's TRQL query compiler, and partition-aligned TTL dropping with ttl\_only\_drop\_parts=1.

## Takeaways

- Hookdeck reduced webhook payload search latency from over 30 seconds to under 400 milliseconds by hashing values into typed bucket columns and applying iterative time-window scanning.
- ClickHouse 26.2 introduced time-based block flushing for streaming ingestion, faster RIGHT and FULL JOIN operations, and native inverted indexes that reduce scanned granules by up to 96%.
- Efficient TTL execution requires aligning table partitioning with the TTL time unit and setting ttl\_only\_drop\_parts=1, allowing background merges to drop whole data parts without mutation rewrites.

**Tags:** [Performance](https://yomu.fyi/topic/performance), [Postgres](https://yomu.fyi/topic/postgres), [Scalability](https://yomu.fyi/topic/scalability), [Search](https://yomu.fyi/topic/search), [Streaming](https://yomu.fyi/topic/streaming)

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

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