Blogsby GlyphNov 6
ClickHouse release 26.10
ClickHouse 26.10 introduces function composition, more flexible joins, faster GROUP BY queries, disk spilling for IN subqueries, an experimental columns cache, and Freeform and SQLite formats.
ClickHouse Blog the engineering blog of ClickHouse: latest posts and feed
ClickHouse · Engineering blog · 8 a week · 934 posts since Jun 15, 2016
Nov 6
What I learned from a month with WalShadow on ClickHouse Managed Postgres
Hidehiko ASAHI shares a month of WalShadow private-preview testing, comparing replication latency with ClickPipes and checking data correctness, schema changes, and recovery.
Nov 4
Fencing a Postgres primary that might still be alive
Promoting a standby doesn't stop the old Postgres primary from taking writes. Here's how the control plane behind ClickHouse Managed Postgres fences it on bare metal, AWS and GCP, and why the design is fail-open.
Nov 4
MongoDB CDC connector for ClickPipes is now generally available
The MongoDB CDC connector for ClickPipes is now generally available, with parallel snapshotting, structured ingestion into typed columns, lag and resource metrics, and Terraform and OpenAPI support.
Nov 3
Does your application need local data or faster Postgres?
Local synchronization makes reads fast, but adds another data layer to manage. Explore how AI agents change the trade-off and when NVMe-backed Postgres can simplify the architecture.
Nov 3
What's new in ClickStack - September and October '26
The September and October ClickStack releases bring ad hoc dashboard filters, PromQL for every chart type, ClickStack query tracing, a Trace logs tab, alerts from the chart explorer, and a long list of search page and collector...
Nov 2
What's new in clickhousectl v0.5.0
clickhousectl v0.5.0 takes UDFs from local to Cloud, adds ClickHouse Managed Postgres observability, standardises the command surface, and lists the API-key permissions every Cloud command needs.
Nov 2
How OpenRouter observes, understands, and acts on 740 million LLM requests a day with ClickHouse Cloud
OpenRouter uses ClickHouse Cloud as the single store behind customer analytics, public model rankings, internal AI agents, and routing across 500+ models, as monthly requests grew 33x to 19.7 billion.
Oct 29
Meet GroeneAI: our autonomous contributor to ClickHouse
Meet GroeneAI, ClickHouse’s autonomous engineering agent that contributed more than 3,000 merged pull requests in under seven months.
Oct 28
The new cost-based join optimizer with reordering support for non-inner joins
ClickHouse’s new exhaustive cost-based join optimizer safely reorders inner, outer, semi, and anti joins to find the cheapest valid plan.
Oct 28
Why ClickHouse Cloud wins at real-time analytics
Explore how ClickHouse Cloud turns fresh data into fast answers with efficient preparation, parallelized queries, and elastic scaling.
Oct 27
The Agentic Analytics Benchmark: ranking tables and labeling failures with Jev
Jev ranks warehouse tables and labels agent failures in under a second, but adding retrieval hints leaves accuracy flat across 20 models on the Agentic Analytics Benchmark.
Oct 26
Expanding Customer Notifications for ClickHouse Managed Postgres
ClickHouse Managed Postgres is adding five new customer notifications: inactive replication slots, planned switchovers, unplanned failovers, long-running transactions, and connections approaching their limit.
Oct 23
How Shipsidekick replaced Neon with ClickHouse Managed Postgres for 10x faster queries and better reliability
Shipsidekick moved from Neon to ClickHouse Managed Postgres in a single weekend, cutting CPU usage from 100% to 5-10% and making queries about 10x faster.
Oct 22
Trace and evaluate Cursor agents with Langfuse, powered by ClickHouse
Connect Cursor to Langfuse to trace every agent turn, pinpoint expensive model and tool calls, and use evaluations to confirm a fix actually helps, with ClickHouse powering the analytics underneath.
Oct 21
Running ClickHouse on NVIDIA Vera CPU: Is your favorite database up to the challenge?
NVIDIA Vera tops the ClickBench hardware leaderboard, and three micro-benchmarks for filters, aggregation and joins show ClickHouse scaling almost linearly across its 176 cores.
Oct 21
Front-end observability at scale: How OpenReplay captures billions of daily events in real time with ClickHouse
OpenReplay replaced Postgres with ClickHouse to ingest billions of events and up to 6 TB a day on a single, vertically scaled instance, with sub-second queries and retention handled by a single TTL setting.
Oct 20
The Agentic Analytics Benchmark, round two: GPT-6, Claude Opus 5.5, Claude Sonnet 5.5
We added GPT-6 Astra, Luna and Sol, Claude Opus 5.5 and Claude Sonnet 5.5 to the Agentic Analytics Benchmark: all five land mid-board within a point of each other, and Sonnet 5.5 brings the biggest change in turns, cost and truncated runs.
Oct 19
Postgres wait events, now in Query Insights
Query Insights for ClickHouse Managed Postgres now shows what active sessions are waiting on, with wait event breakdowns, blocked-session and lock-wait charts, and the same metrics in Prometheus.
Oct 16
Introducing the (blazing fast!) native TCP client for.NET
ClickHouse’s new native TCP client for.NET brings faster reads and inserts with fewer allocations, columnar APIs, POCO support, and a path to migrate from HTTP.
Oct 15
Scaling ClickStack alerting with built-in anomaly detection
Managed ClickStack now flags unusual values on the charts you already use with built-in z-score anomaly detection, and a faster, sharded scheduler lets teams bring tens of thousands of alerts over from tools like Grafana.
Oct 15
October 2026 newsletter
Welcome to the October 2026 ClickHouse newsletter, featuring CostBench results against BigQuery and Databricks, ClickHouse 26.9, executable UDFs on ClickHouse Cloud, and the latest community news and events.
Oct 15
OLTP is expensive, you can ClickHouse it
Offload settled Postgres data to ClickHouse to reduce storage and query costs while keeping active transactions in Postgres.
Oct 14
Why Redshift Serverless can’t match ClickHouse Cloud for real-time analytics
ClickHouse Cloud delivered 1,996× better performance per dollar than Redshift Serverless in CostBench. We trace the gap from fresh data arriving to fast answers coming back.
Oct 14
How Ridgeline unified Iceberg and ClickHouse into one analytics layer for investment management
Ridgeline rebuilt its performance analytics on ClickHouse Cloud, querying decades of Iceberg history alongside recent data so it can serve investment managers 10x larger than before and more than double the customers live on its platform.
The latest 200 of 934 posts on file; older ones are under Months.
About this blog
Real-time analytics, query performance and ClickHouse internals.
Posts per week, last 26 weeks
8 a week over the last six months (or since the feed's oldest post)
Posts by month
Writes about
Databases (137), AI and agents (22), Reliability and performance (19) in the last six months.
ClickHouse
ClickHouse on Companies (companies.fru.dev)Across Glyph:Acquisitions·awards·calendar·Attested·Tier Zero·Roundup·Downtime·Mainstage·Leaders·marketplaces·Paydays·problems·Footprint·Changefeed·repos·salaries·socials·standards·sunsets·terms·Titlewave
History
Official checkSep 25
not reviewed to official: on clickhouse.com