Loading post…
ClickhouseAnnouncement
October 2026 newsletter
Summary
The October 2026 ClickHouse newsletter announces CostBench results where ClickHouse Cloud delivered 752× better performance per dollar than Databricks and 438× to 512× better than BigQuery on real-time analytics workloads. The 26.9 release extends LIMIT with AFTER and UNTIL boundary conditions, adds incremental refresh for materialized views, and introduces CREATE TOKEN for time-limited credentials. Executable user-defined functions are now generally available on ClickHouse Cloud, supporting precompiled Rust, Go, C++, and JavaScript binaries with outbound network access and a deterministic flag. Featured community member Hoang Minh V has had over 100 pull requests merged since May, including a fast path for PromQL aggregations and fixes to TimeSeries reads. The newsletter also covers the official Apache Airflow provider for ClickHouse, the chDB durable layer for agent memory, and a Postgres round-up on memory safety and local NVMe storage.
Context
Monthly newsletter from ClickHouse covering product updates, benchmarks, community contributions, and events for October 2026.
Takeaways
ClickHouse Cloud outperformed Databricks by 752× per dollar and BigQuery by 438–512× per dollar in CostBench real-time analytics benchmarks with 113.2 billion quotes.
ClickHouse 26.9 adds AFTER and UNTIL boundary conditions to LIMIT for log analysis, incremental materialized view refresh, and CREATE TOKEN for time-limited credentials.
Executable UDFs are now GA on ClickHouse Cloud, supporting Rust, Go, C++, and JavaScript with outbound network access and deterministic caching.
FAQ
How does ClickHouse Cloud compare to Databricks and BigQuery in cost and performance?
In CostBench tests ingesting 113.2 billion stock-market quotes, ClickHouse Cloud delivered 752× better end-to-end performance per dollar than Databricks and 438× to 512× better than BigQuery, depending on pricing model. ClickHouse sorts and pre-aggregates data on insert, while competitors leave catch-up work for query time or asynchronous refreshes.
What new features are in ClickHouse 26.9?
ClickHouse 26.9 extends LIMIT with AFTER and UNTIL boundary conditions that start and stop output based on ordered values, making log analysis easier. It also adds incremental refresh for append-only materialized views, CREATE TOKEN for time-limited credentials, and DISTINCT that can spill to disk.
What is the chDB durable layer for agent memory?
The chDB Durable Layer allows agent memory to survive machine restarts by keeping a fast local copy while the source of truth lives in object storage (S3, GCS, or Azure Blob). A new laptop, CI job, or sandbox can pick up where the last one left off.
Source and freshness
- Source
- clickhouse.com
- Published
- Added to Yomu
Summaries are generated from the original by a language model. Check the original before relying on it.
Keep reading
Related reading
The Good Stuff
Paid picks we use ourselves. Links carry a referral code — a subscription through one earns us a commission at no extra cost to you.
The best engineering reads, once a week
One useful email. Unsubscribe anytime.