---
title: "July 2026 newsletter"
description: "The July 2026 newsletter rounds up ClickHouse releases, community projects, benchmarks, engineering work, and upcoming events in real-time data warehousing. Version 26.6 adds hypothetical skip indexes, cascading refreshable materialized-view dependencies, experimental continuous queries, AI embedding functions, PNG output, CLI documentation, and geospatial improvements. A CostBench comparison running the full analytics path over 28 hours found better cost-performance for ClickHouse Cloud than Snowflake Interactive Tables, which required a continuously running refresh warehouse for pre-aggregated data. Other features cover conversational analytics with ClickHouse Cloud, LibreChat, and MCP; Postgres change-data capture through Debezium and Kafka; local agent queries with chDB; high-concurrency tuning; and Silk, whose fiber runtime targets lower I/O tail latency. Quick reads report ingestion, caching, security, and multi-tenant SQL developments."
---

# July 2026 newsletter

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

**Type:** Announcement

## Summary

The July 2026 newsletter rounds up ClickHouse releases, community projects, benchmarks, engineering work, and upcoming events in real-time data warehousing. Version 26.6 adds hypothetical skip indexes, cascading refreshable materialized-view dependencies, experimental continuous queries, AI embedding functions, PNG output, CLI documentation, and geospatial improvements. A CostBench comparison running the full analytics path over 28 hours found better cost-performance for ClickHouse Cloud than Snowflake Interactive Tables, which required a continuously running refresh warehouse for pre-aggregated data. Other features cover conversational analytics with ClickHouse Cloud, LibreChat, and MCP; Postgres change-data capture through Debezium and Kafka; local agent queries with chDB; high-concurrency tuning; and Silk, whose fiber runtime targets lower I/O tail latency. Quick reads report ingestion, caching, security, and multi-tenant SQL developments.

## Context

The newsletter is intended to round up what happened in real-time data warehouses over the last month, including product releases, technical articles, community activity, benchmarks, and events.

## Approach / What changed

It presents a curated set of release notes, user and community examples, comparative performance research, engineering articles, quick reads, and event announcements. Topics include ClickHouse 26.6, real-time analytics cost measurement, Postgres CDC, embedded querying for AI agents, concurrency tuning, and the Silk fiber runtime.

## Takeaways

- Hypothetical skip indexes show whether adding a skip index could improve query performance without actually building the index.
- CostBench measures continuous ingestion, data maintenance, freshness, and query execution; over 28 hours, ClickHouse delivered better cost-performance than Snowflake Interactive Tables.
- Silk combines a NUMA-aware work-stealing scheduler with io\_uring and zero heap allocation on the hot path, reporting 3.6-nanosecond fiber yields and 5.9 million file IOPS.

**Tags:** [Data Pipelines](https://yomu.fyi/topic/data-pipelines), [LLMs](https://yomu.fyi/topic/llm), [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/202607-newsletter)
- Source URL: https://clickhouse.com/blog/202607-newsletter
- Ingested by Yomu: 2026-08-29T01:38:50.533Z

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