How ClickHouse Uses AWS

iFood rebuilt its in-house security platform on ClickHouse Cloud, getting 9-16x faster queries at 40-50% of the cost and unlocking agentic threat hunts that cut a week of analyst work down to two hours.

This release brings speedups for GROUP BY ... ORDER BY ... LIMIT, three JOIN improvements, four vector search improvements, position-aware phrase search, EXPLAIN ANALYZE, unified URL access, and more!

You can choose any of these hundred database systems and run queries. You can create tables and databases, insert data, drop tables, etc. Every database comes with a preloaded dataset of 100 million records, so you can test example queries. It has not onl

We ran ClickHouse Managed Postgres and PlanetScale on the same hardware. ClickHouse delivered up to 54% higher throughput with lower latency.

ClickHouse has achieved the AWS Small and Medium Business Competency, joining a select group of AWS Partners recognized for deep expertise in real-time analytics for small and medium businesses.

PostgresBench now includes HA benchmarks, comparing the performance of managed Postgres services under production-style HA configurations. This post explains the architectures behind each service and analyzes the trade-offs between availability guarantees

Recent improvements to the OpenTelemetry Collector's Datadog receiver let teams reroute telemetry from their existing Datadog agents and SDKs to ClickStack. or any OTel destination making migrations and evaluations simpler than ever.

This post shows a lightweight metrics layer for ClickHouse using MooseStack, an open source developer agent harness for ClickHouse.

ClickHouse 26.2 is here! In this post, text-index and QBit data type become production-ready.

How to remain competitive in the AI era of software engineering

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

ClickHouse now brings full-text search and large-scale analytics together in one engine, making it a powerful alternative to Elasticsearch for log analytics. This benchmark shows why.

We use clickhousectl to spin up multiple ClickHouse versions side by side and benchmark two recent performance improvements.

ClickHouse 26.5 is here! In this release, we have a record number of performance optimizations, a new `filesystem` table function for querying your local file system with SQL, and more!

ClickHouse Cloud takes on Snowflake, Databricks, BigQuery, and Redshift on TPC-H, ranking first on SF100 cost-performance and running SF10 for less than one cent.

Over two years of focused join engineering, ClickHouse became 26× faster on the TPC-H SF100 join-heavy workload. Here’s how parallel hash joins, runtime filters, lazy column replication, and smarter join planning got us there.

Postgres managed by ClickHouse's first major update since public beta, covering fine-grained access control, a redesigned console, Terraform support, MCP integration, Stripe provisioning, migrations, billing, and capacity reservations — all shipped in und

Real-time analytics is more than fast queries. CostBench compares Snowflake and ClickHouse Cloud across the full path: continuous ingest, query-ready data maintenance, freshness, query latency, and cost.

We scaled our internal logging platform from 19 PiB to 431 PiB and 1.59 quadrillion rows. Here’s how we rearchitected LogHouse to handle 80 GiB/s of writes while keeping queries fast and the underlying complexity invisible.

chDB embeds a full ClickHouse query engine inside an agent's own process, turning data access, memory, and federation into local function calls instead of network round trips, cutting the latency, retries, and token waste that come with remote queries.

ClickHouse is now available as a Docker Hardened Image: a minimal, security-hardened build that passes enterprise vulnerability scans by shipping only what the database needs to run, with no change to how ClickHouse behaves.

Welcome to the July 2026 ClickHouse newsletter, which will round up what’s happened in real-time data warehouses over the last month.

The article discusses how PeerDB facilitates large-scale PostgreSQL migrations, specifically achieving a 1TB migration in just 2 hours.

This article explains how ClickHouse optimizes Top-N queries (ORDER BY . LIMIT N) using granule-level data skipping indexes.

ClickHouse 25.

ClickHouse 25. 9 introduces streaming secondary indices, a fundamental change to how secondary indexes (minmax, set, bloom filter, vector, text) are evaluated during query execution.

The article discusses the new functionality in ClickHouse that allows for multiple lightweight projections to behave like true secondary indexes, significantly enhancing query performance without d...

The article discusses the development of chDB, a Python library that integrates ClickHouse with Pandas DataFrames for high-performance SQL querying.

ClickHouse version 25. 11 introduces significant enhancements, including 24 new features, 27 performance optimizations, and 97 bug fixes.

This article benchmarks five major cloud data warehouses—Snowflake, Databricks, ClickHouse Cloud, BigQuery, and Redshift—across various scales of data to compare their cost-performance.

This article provides a detailed analysis of how the five major cloud data warehouses—Snowflake, Databricks, ClickHouse Cloud, Google BigQuery, and Amazon Redshift Serverless—calculate compute cost...

This article discusses the transition from OpenTelemetry (OTel) to Rotel, an open-source Rust project that enhances tracing capabilities at petabyte scale.

The article details the journey of upgrading the chDB kernel from ClickHouse v25. 5 to v25. 8. 2.

This article details the transformation of ClickHouse's internal data warehouse from a traditional BI-first approach to an AI-first model, significantly enhancing user accessibility to analytics.

ClickPipes for PostgreSQL has introduced support for failover replication slots, enhancing reliability and flexibility for users.

ClickHouse version 25. 10 introduces significant enhancements, including 20 new features, 30 performance optimizations, and 103 bug fixes.

The article discusses the potential of lakehouses using open table formats like Apache Iceberg and Delta Lake for observability, highlighting their advantages in scalability, cost-effectiveness, an...

The article discusses the new capabilities of ClickHouse Cloud to query Iceberg and Delta Lake tables through the DataLakeCatalog engine.

ClickHouse Release 25. 9 introduces significant enhancements, including 25 new features, 22 performance optimizations, and 83 bug fixes.

ClickHouse version 25. 8 introduces 45 new features, 47 performance optimizations, and 119 bug fixes, enhancing its capabilities as a high-performance analytical database.

The article discusses how ClickHouse Cloud has achieved the capability to scale complex GROUP BY queries across thousands of cores, processing over 100 billion rows in under a second.

This article discusses the process of creating reproducible ZIP archives for AWS Lambda functions, focusing on challenges such as file order, timestamp management, and OS compatibility.

This article discusses the implementation of Change Data Capture (CDC) from Delta Lake to ClickHouse, detailing the architecture, components, and a reference implementation in Python.

This article compares the UPDATE performance of ClickHouse and PostgreSQL, highlighting ClickHouse's significant speed advantages in bulk updates while also acknowledging PostgreSQL's strengths in ...

ClickHouse Release 25.

This article discusses the significant performance improvements achieved in ClickHouse's SQL UPDATE operations, demonstrating how they can be up to 1,000× faster than traditional mutation methods t...

The article discusses the transition of ClickHouse Cloud to a fully stateless compute architecture, enabled by the introduction of a Shared Catalog.

This article benchmarks join-heavy SQL queries across ClickHouse, Databricks, and Snowflake, demonstrating that ClickHouse outperforms both competitors in speed and cost across various data scales.

ClickHouse version 25.

This article discusses the development of a distributed cache for ClickHouse Cloud, aimed at providing low-latency access to hot data across compute nodes.