October 2026 newsletter
Blog post from ClickHouse
ClickHouse’s monthly newsletter highlights the 26.9 release, which adds LIMIT AFTER and UNTIL boundary conditions for ordered results, incremental refreshes for append-only materialized views, time-limited credentials through CREATE TOKEN, and disk spilling for DISTINCT operations. It recognizes community contributor Hoang Minh V for extensive work improving PromQL, the TimeSeries engine, LIMIT BY behavior, and edge cases across several functions. New CostBench comparisons claim ClickHouse Cloud achieved substantially higher real-time analytics performance per dollar than Databricks and BigQuery while ingesting 113.2 billion market quotes, attributing the difference to ClickHouse’s insert-time sorting and pre-aggregation. The newsletter also announces general availability of executable UDFs in ClickHouse Cloud, the official ClickHouse provider for Apache Airflow, and chDB Durable Layer for persistent agent memory backed by object storage. Additional coverage explores ClickHouse integrations with PostgreSQL, including memory safety, local NVMe performance, and extension updates, while Open House presentations feature ClickHouse use cases at companies including Polymarket, OpenRouter, Buildkite, Canva, and Xero.
| Trend | Post Mentions | Total Month Mentions | Posts | Companies | MoM |
|---|---|---|---|---|---|
| Real-time | 12 | 1,841 | 506 | 164 | -62% |
| Observability | 3 | 1,359 | 336 | 123 | -50% |
| LLM | 1 | 2,649 | 517 | 161 | -56% |
Use this post, company, and trend context to find content marketing opportunities, perform competitive analysis, or address product feature gaps via the Plushcap MCP server or the Plushcap API.