Performance
-
Basic Data Aggregation in ClickHouse®
Data aggregation is one of the most common operations in analytical workloads. Whether you’re calculating…
-
ClickHouse® Data Types: Explained for Beginners
Introduction When you start working with ClickHouse, one of the first things you need to…
-
ClickHouse® vs PostgreSQL: When to Use Which?
Introduction Choosing the right database is one of the most consequential architectural decisions in any…
-
Reliable ClickHouse Backups: From Simple Setups to Production-Ready Strategies
Introduction When running ClickHouse, especially in self-managed environments, one of the most critical questions is:…
-
Millions of UK House Sales Records – One Interactive Dashboard by ClickHouse & Apache Superset
Analyzing large real estate datasets requires tools built for high-performance analytics. The UK Land Registry…
-
When ClickHouse® Queries Are Slow: A Practical Debugging Guide
ClickHouse® has a reputation: it’s supposed to be fast. And it is – but only…
-
ClickHouse® 26.3 LTS: A Practical Guide to What Changed and Why It Matters
Published on: March 26, 2026Version: 26.3 (Long-Term Support) ClickHouse® 26.3 LTS is a significant release…
-
Optimizing ClickHouse Queries: Adding and Benchmarking Projections
In my previous blog on Optimizing ClickHouse Queries, we explored how ClickHouse stores data in…
-
Operating ClickHouse on Kubernetes
As Kubernetes becomes the default platform for deploying modern infrastructure, teams increasingly want their data…
-
Lightweight Delete in ClickHouse®
Deleting data in ClickHouse® requires a different approach compared to traditional row-based databases. Since the…