How ClickHouse Uses PostgreSQL
63 engineering articles about PostgreSQL from ClickHouse's engineering team
Other ClickHouse Technologies
Other Companies Using PostgreSQL
Articles
Filter:
JSONBench now compares 27 database engines. ClickHouse still leads on a billion JSON documents. Explore the results and run the benchmark yourself.
5 min read
Includes Code
--
ClickHouse Managed Postgres is generally available, ClickHouse Observability enters public beta, ClickHouse Security launches in private preview, Langfuse introduces an open-source AI Gateway, and ClickHouse acquires Xata.
9 min read
Includes Code
--
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.
26 min read
Includes Code
--
Hidehiko ASAHI shares a month of WalShadow private-preview testing, comparing replication latency with ClickPipes and checking data correctness, schema changes, and recovery.
17 min read
Includes Code
--
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.
11 min read
Includes Code
--
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.
11 min read
--
Meet GroeneAI, ClickHouse’s autonomous engineering agent that contributed more than 3,000 merged pull requests in under seven months.
21 min read
Includes Code
--
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.
4 min read
Includes Code
--
Offload settled Postgres data to ClickHouse to reduce storage and query costs while keeping active transactions in Postgres.
8 min read
--
Clera migrated its 500 GB production database and 500+ tables to ClickHouse Managed Postgres overnight, cutting CPU usage from 100% to 10–20%.
Highlights from Postgres Summit US 2026 in New York City, where ClickHouse sponsored the community and demonstrated its growing Postgres integrations.
7 min read
--
See how local NVMe transforms Postgres transaction performance—and why ClickHouse remains essential for fast analytics as workloads scale.
9 min read
Includes Code
--
Notes from three days in the Netherlands, featuring a lightning talk on pg_clickhouse and pg_stat_ch at PGDay Lowlands and a session on PostgreSQL 19 monitoring at Percona Live Amsterdam.
8 min read
Includes Code
--
ClickHouse 26.8 LTS introduces background queries, pipelined SQL, new text tokenizers, expanded data lake integrations, and faster Parquet, aggregation, and join queries.
Google's MCP Toolbox for Databases embeds agent text into vectors on insert and search, then lets ClickHouse rank the results - no embedding service to build or maintain. Here's how to set it up, and what it looks like end to end.
PostgreSQL 19 adds four system views that make lock contention, recovery state, autovacuum priorities, and dynamic shared memory allocations easier to inspect.
14 min read
Includes Code
--
See how a four-step onboarding flow helps users move from provisioning ClickHouse Managed Postgres to querying operational data and running real-time analytics with ClickHouse.
7 min read
--
PostgreSQL 19's new `WAIT FOR` command enables read-your-writes consistency on asynchronous replicas by letting individual reads wait for a specific WAL position.
7 min read
Includes Code
--
A recap of Sai Srirampur's POSETTE 2026 talk on storage performance in Postgres, with a local NVMe vs. EBS benchmark and the production setup behind it.
9 min read
Includes Code
--
What's New with Monitoring in PostgreSQL 19
9 min read
Includes Code
--
I am excited to announce that I am joining ClickHouse, Inc. to establish and lead a new research team at ClickHouse Labs.
4 min read
--
We ran ClickHouse Managed Postgres and PlanetScale on the same hardware. ClickHouse delivered up to 54% higher throughput with lower latency.
5 min read
Includes Code
--
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.
5 min read
--
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
8 min read
Includes Code
--
High-performance full-text search, even on object storage. This deep dive from the ClickHouse engineers explains the new text index design and how it keeps queries fast at scale.
37 min read
Includes Code
--
Discover how Postgres managed by ClickHouse compares to its peers in a reproducible, open benchmark.
9 min read
Includes Code
--
A Solutions Architect’s experience building a retail analytics platform with AI agents, real-time dashboards, and full observability on the ClickHouse data platform
15 min read
Includes Code
--
ClickHouse 26.4 is here! In this release, more features become SQL compatible, COUNT DISTINCT gets faster, EXPLAIN gets even prettier, and more
12 min read
Includes Code
--
On June 15, 2016, ClickHouse went open source under the Apache 2.0 license. Ten years later, it's one of the most widely deployed analytical databases in the world.
8 min read
Includes Code
--
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.
6 min read
Includes Code
--
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.
18 min read
Includes Code
--
How ClickHouse Managed Postgres reserves, enforces, and sizes huge pages so shared_buffers avoids the per-connection page-table tax that eats RAM and stalls reads on 4KB pages.
6 min read
Includes Code
--
The article discusses how PeerDB facilitates large-scale PostgreSQL migrations, specifically achieving a 1TB migration in just 2 hours.
15 min read
Includes Code
Has Summary
--
The article discusses the pg_stat_ch extension for PostgreSQL, which facilitates the export of metrics to ClickHouse.
1 min read
Has Summary
--
20 min read
Includes Code
Has Summary
--
The article discusses the development of chDB, a Python library that integrates ClickHouse with Pandas DataFrames for high-performance SQL querying.
The article presents a curated list of technology blogs that focus on performance optimizations, algorithms, database development, and more, aimed at helping software engineers find valuable resour...
The article discusses the implementation of a PostgreSQL setting (GUC) for the pg_clickhouse extension, focusing on optimizing the parsing of key/value pairs for session settings.
David Wheeler
10 min read
Includes Code
Has Summary
--
The article highlights Alexey's favorite features introduced in ClickHouse throughout 2025, including lightweight updates, data lake support, and advancements in text and vector indexing.
12 min read
Includes Code
Has Summary
--
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 ...
Al Brown and Tom Schreiber
18 min read
Includes Code
Has Summary
--
ClickHouse Team
15 min read
Includes Code
Has Summary
--
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...
Tom Schreiber
21 min read
Includes Code
Has Summary
--
This article discusses the innovative approach ClickHouse has taken to implement fast SQL-style UPDATEs in its column store architecture.
Tom Schreiber
23 min read
Includes Code
Has Summary
--
This article discusses how ClickHouse addresses the challenges of row-level updates in column stores by treating updates as inserts.
Tom Schreiber
14 min read
Includes Code
Has Summary
--
This article explores a bug encountered by the ClickPipes team related to logical replication slot creation in PostgreSQL read replicas, where a query could not be terminated by standard methods.
Kevin Biju Kizhake Kanichery
13 min read
Includes Code
Has Summary
--
The article discusses how Dash0 transitioned to using ClickHouse as a core database technology for their observability platform, leveraging its efficiency and scalability to handle OpenTelemetry da...
Miel Donkers
20 min read
Includes Code
Has Summary
--
The article discusses the implementation of Make Before Break scaling mechanics for ClickHouse Cloud, focusing on the transition from a single StatefulSet architecture to a more flexible MultiSTS a...
Jayme Bird, Manish Gill, Manas Alekar, Francesco Ciocchetti & Ashwath Singh
20 min read
Includes Code
Has Summary
--
This article provides a comprehensive guide on integrating PostgreSQL with ClickHouse using Change Data Capture (CDC) for real-time analytics.
Lionel Palacin & Sai Srirampur
23 min read
Includes Code
Has Summary
--
The article discusses the One Billion Documents JSON Challenge, comparing the performance of ClickHouse against other popular databases like MongoDB, Elasticsearch, DuckDB, and PostgreSQL in storin...
Tom Schreiber
33 min read
Includes Code
Has Summary
--
This article discusses building single page applications (SPAs) using ClickHouse with a focus on a 'client only' architecture.