#ClickHouse

What I learned operating ClickHouse at scale: the wins, the failures, and the lessons that only come from production experience.

Discover what's new in pg_clickhouse v0.10.0: 16 of 22 TPC-H queries now push down in full, plus a rebuilt C driver and broader aggregate support.

How we built WAL-RUS, an open-source Rust-based Postgres backup tool that reduces virtual memory usage by over 70% compared to WAL-G while maintaining full compatibility.

Discover how Postgres managed by ClickHouse compares to its peers in a reproducible, open benchmark.

ClickHouse was released in open source on Jun 15 2016, ten years ago. Since then, it became the most popular open source analytical database with more than 2000 contributors.

Postgres CDC into ClickHouse via Kafka + Debezium, MaterializedPostgreSQL, and ClickPipes — setup, schemas, monitoring SQL, and where each one breaks.

Introduction ClickHouse is a columnar OLAP database. It runs aggregate queries across...

When a partitioning change to our petabyte-scale ClickHouse cluster caused critical billing jobs to stall, standard metrics showed no obvious errors.…

For a long time, the advice around FINAL in ClickHouse was pretty straightforward: Avoid it...

The 'avoid JOINs in ClickHouse' advice is four years and 50+ PRs out of date. Here's what actually shipped between 2022 and 2026.

A lot of people compare PostgreSQL and ClickHouse like they are competing databases. They really are...

PostHog Cloud EU bill crossed 180 EUR/month at ~3M events, so I migrated to a self-hosted Hetzner...

From Dev.to - database: Building a Full-Stack Agentic AI Data Platform on ClickHouse: A Complete Architecture Guide

A practical guide based on shipping this for a crypto-derivatives platform — annual observability...

Why ClickHouse Silently Drops Your Rows I was running a batch test and noticed something...

The launch post for php_clickhouse 0.6.0 covered the framing: native binary protocol, soft fork of...

Achieve extreme analytics at scale. Master the 2026 production setup covering Tiered Storage, NVMe...

MaterializedMySQL is dead. Master the 2026 industry standard CDC pipeline using Debezium and Redpanda...

TL;DR Yes, ClickHouse fully supports UPDATEs. As of April 2026, ClickHouse ships standard...

Hi database folks, If you evaluated ClickHouse a few years ago, you were likely told to avoid **JOINs** at all costs. The standard industry advice was to denormalize everything into massive, flat tables. In 2020, that criticism was fair.…