Learn about the latest ClickHouse tips, tricks and company announcements.

ClickHouse source code is published under the Apache 2.0 License. Software is distributed on an "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.

logo_without_text.svg

Stay informed on feature releases, product roadmap, support, and cloud offerings!

Subscribe to our newsletter

icon-github.svg

icon-slack.svg

icon-telegram.svg

icon-twitter.svg

Join the ClickHouse conversation on

ClickHouse

ClickHouse Cloud

Download

PRODUCT

Documentation

Training

Support

Comparison

Use cases

RESOURCES

Blog

Our story

Careers

Contact us

News and events

COMPANY

A look back at some of my favorite benchmark-backed ClickHouse blog posts this year, and the lessons they revealed about performance in practice.

large_527657444-6c939522-a72b-4802-92e1-e5f3c8da60eb.jpg

medium_527657444-6c939522-a72b-4802-92e1-e5f3c8da60eb.jpg

small_527657444-6c939522-a72b-4802-92e1-e5f3c8da60eb.jpg

thumbnail_527657444-6c939522-a72b-4802-92e1-e5f3c8da60eb.jpg

527657444-6c939522-a72b-4802-92e1-e5f3c8da60eb.jpg

What really matters for performance: lessons from a year of benchmarks

Looking back at Alexey's favorite ClickHouse features of the year.

large_Release Blog Cover (33).png

medium_Release Blog Cover (33).png

small_Release Blog Cover (33).png

thumbnail_Release Blog Cover (33).png

Release Blog Cover (33).png

Alexey's favorite features of 2025

large_Blog Banner Taming PostgreSQL.jpg

medium_Blog Banner Taming PostgreSQL.jpg

small_Blog Banner Taming PostgreSQL.jpg

thumbnail_Blog Banner Taming PostgreSQL.jpg

Blog Banner Taming PostgreSQL.jpg

Taming PostgreSQL GUC “extra” Data

An annotated version of Alexey's presentation at the P99 conference on the use of Rust in ClickHouse.

large_Clickhouse C++ Rust Journey Alexey Milovidov.jpg

medium_Clickhouse C++ Rust Journey Alexey Milovidov.jpg

small_Clickhouse C++ Rust Journey Alexey Milovidov.jpg

thumbnail_Clickhouse C++ Rust Journey Alexey Milovidov.jpg

Clickhouse C++ Rust Journey Alexey Milovidov.jpg

How to use Rust in ClickHouse: avoiding a full rewrite

A first-person engineering deep dive into how ClickHouse parallelized aggregation merges for FixedHashMap, including design choices, false starts, and performance trade-offs.

large_525537271-fc89e319-94ef-4ebe-90d9-44ce6e384d4b.jpg

medium_525537271-fc89e319-94ef-4ebe-90d9-44ce6e384d4b.jpg

small_525537271-fc89e319-94ef-4ebe-90d9-44ce6e384d4b.jpg

thumbnail_525537271-fc89e319-94ef-4ebe-90d9-44ce6e384d4b.jpg

525537271-fc89e319-94ef-4ebe-90d9-44ce6e384d4b.jpg

Parallelizing ClickHouse aggregation merge for fixed hash map

ClickHouse 25.11 is here! In this post, you will learn about parallel merge for small GROUP BY, projections as secondary indices, and more!

large_Release Blog Cover (30).png

medium_Release Blog Cover (30).png

small_Release Blog Cover (30).png

thumbnail_Release Blog Cover (30).png

Release Blog Cover (30).png

ClickHouse Release 25.11

Discover what’s new in ClickStack this month, including service maps, root span filtering, Incident.io integration, and more!

large_image9.png

medium_image9.png

small_image9.png

thumbnail_image9.png

image9.png

What's new in ClickStack. November '25.

We benchmarked the five major cloud data warehouses at 1B–100B rows using their real billing models to measure performance per dollar. Results show how cost-performance shifts as data grows.

large_518800743-54d259df-9a1b-4798-b91c-5fea9f2e00ab.jpg

medium_518800743-54d259df-9a1b-4798-b91c-5fea9f2e00ab.jpg

small_518800743-54d259df-9a1b-4798-b91c-5fea9f2e00ab.jpg

thumbnail_518800743-54d259df-9a1b-4798-b91c-5fea9f2e00ab.jpg

518800743-54d259df-9a1b-4798-b91c-5fea9f2e00ab.jpg

How the 5 major cloud data warehouses compare on cost-performance

This guide explains how the five major cloud data warehouses—Snowflake, Databricks, ClickHouse Cloud, BigQuery, and Redshift—allocate, meter, and bill compute, giving engineers a clear understanding of what the billing units mean and how to compare them.

large_519223445-6865553b-2d10-4c12-8e32-8d4ec7804fc2.jpg

medium_519223445-6865553b-2d10-4c12-8e32-8d4ec7804fc2.jpg

small_519223445-6865553b-2d10-4c12-8e32-8d4ec7804fc2.jpg

thumbnail_519223445-6865553b-2d10-4c12-8e32-8d4ec7804fc2.jpg

519223445-6865553b-2d10-4c12-8e32-8d4ec7804fc2.jpg

How the 5 major cloud data warehouses really bill you: A unified, engineer-friendly guide

Read how Streamfold’s Rotel pushes OpenTelemetry 4x faster into ClickHouse - benchmarking efficiency at scale and revealing the tools that make it happen

large_rotel-to-otel.png

medium_rotel-to-otel.png

small_rotel-to-otel.png

thumbnail_rotel-to-otel.png

rotel-to-otel.png

From OTel to Rotel: Petabyte-scale tracing with 4x greater throughput

chDB recently upgraded the ClickHouse kernel from v25.5 to v25.8.2.29. This blog post goes through that journey.

large_Image from GitHub (2).jpg

medium_Image from GitHub (2).jpg

small_Image from GitHub (2).jpg

thumbnail_Image from GitHub (2).jpg

Image from GitHub (2).jpg

chDB Kernel Upgrade Journey: Upgrading ClickHouse to v25.8.2.29 

Learn more how we built StockHouse, a real-time financial analytics application with Massive, ClickHouse and Perspective that scales to thousands of events per second.

large_stockhouse-banner.jpg

medium_stockhouse-banner.jpg

small_stockhouse-banner.jpg

thumbnail_stockhouse-banner.jpg

stockhouse-banner.jpg

Building StockHouse: Real-time market analytics with ClickHouse

Learn how we evolved our internal 2.1 PB data warehouse from traditional BI to an AI-first analytics platform

large_Blog Banner AI-first ClickHouse.jpg

medium_Blog Banner AI-first ClickHouse.jpg

small_Blog Banner AI-first ClickHouse.jpg

thumbnail_Blog Banner AI-first ClickHouse.jpg

Blog Banner AI-first ClickHouse.jpg

How we made our internal data warehouse AI-first 

Learn about how failover-ready replication slots keep Postgres CDC pipelines running without interruption.

large_clickpipes-postgres-failover-banner.jpg

medium_clickpipes-postgres-failover-banner.jpg

small_clickpipes-postgres-failover-banner.jpg

thumbnail_clickpipes-postgres-failover-banner.jpg

clickpipes-postgres-failover-banner.jpg

ClickPipes for Postgres now supports failover replication slots

Initially, I wanted to make a single report to incentivise for looking at and resolving GitHub issues. But I'm greedy, so in the end it appeared to be a website where you can compare various metrics on team activities across GitHub repositories.

large_ClickHouse Blog Banner.jpg

medium_ClickHouse Blog Banner.jpg

small_ClickHouse Blog Banner.jpg

thumbnail_ClickHouse Blog Banner.jpg

ClickHouse Blog Banner.jpg

I've created a website to track the team's activity

Over 100 functions were added to ClickHouse in 2025. These were some of my favorites.

Blog

New functions you might have missed in 2025