---
title: "ClickHouse Release 26.7"
description: "ClickHouse 26.7 is a monthly release with 61 new features, 112 performance optimizations, and 329 bug fixes, including improvements to aggregation, joins, vector search, phrase search, query analysis, and URL access. Its combination of optimize_aggregation_in_order and the new optimize_aggregation_in_order_limit turns matching GROUP BY, ORDER BY, and LIMIT queries into low-memory streaming pipelines that can stop reading after N groups. In a TPC-H scale-factor-100 test, the optimized query ran 313× faster, processed 339× fewer rows, and used 592× less peak memory. The release also adds build-side JOIN pruning, LLVM JIT compilation for supported regular expressions, and macOS improvements including faster allocation-heavy workloads, concurrent remote-replica reads, SSD cache dictionaries, FileLog, and STREAM support."
---

# ClickHouse Release 26.7

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

**Type:** Announcement

## Summary

ClickHouse 26.7 is a monthly release with 61 new features, 112 performance optimizations, and 329 bug fixes, including improvements to aggregation, joins, vector search, phrase search, query analysis, and URL access. Its combination of optimize\_aggregation\_in\_order and the new optimize\_aggregation\_in\_order\_limit turns matching GROUP BY, ORDER BY, and LIMIT queries into low-memory streaming pipelines that can stop reading after N groups. In a TPC-H scale-factor-100 test, the optimized query ran 313× faster, processed 339× fewer rows, and used 592× less peak memory. The release also adds build-side JOIN pruning, LLVM JIT compilation for supported regular expressions, and macOS improvements including faster allocation-heavy workloads, concurrent remote-replica reads, SSD cache dictionaries, FileLog, and STREAM support.

## Context

ClickHouse 26.7 is presented as the next monthly release, containing 61 new features, 112 performance optimizations, and 329 bug fixes. The release addresses analytical query performance, JOIN execution, search, regular-expression processing, and feature and performance gaps on macOS.

## Approach / What changed

The release combines ordered aggregation with the new optimize\_aggregation\_in\_order\_limit setting so GROUP BY ... ORDER BY ... LIMIT queries can stream results and terminate early. It also adds build-side JOIN-key pruning of probe-side granules, an LLVM-based JIT regular-expression engine with fallback support, and several macOS runtime and feature improvements.

## Takeaways

- Combining optimize\_aggregation\_in\_order with optimize\_aggregation\_in\_order\_limit allows ClickHouse to retain only the current ordered group, emit completed groups, and stop reading after the requested LIMIT.
- In a TPC-H scale-factor-100 benchmark, the optimized GROUP BY query ran in 0.009 seconds versus 2.814 seconds, processed 1.77 million instead of 600.04 million rows, and reduced peak memory from 17.33 GiB to 29.97 MiB.
- The new regular-expression engine uses LLVM to compile supported patterns into CPU-specific native code, falls back transparently when needed, and reduced match() time over 20 million strings from 2.7 seconds to 1.1 seconds.

**Tags:** [Performance](https://yomu.fyi/topic/performance), [Search](https://yomu.fyi/topic/search)

- Source: [Clickhouse](https://clickhouse.com/blog/clickhouse-release-26-07)
- Source URL: https://clickhouse.com/blog/clickhouse-release-26-07
- Ingested by Yomu: 2026-08-29T07:45:34.844Z

[Read original post](https://clickhouse.com/blog/clickhouse-release-26-07)