Neon (serverless Postgres) and ClickHouse can be combined to handle both transactional (OLTP) and analytical (OLAP) workloads. PeerDB, acquired by ClickHouse, serves as the CDC pipeline between the two, leveraging Postgres logical replication with native optimizations for 10x faster replication. The post walks through configuring Neon as a source, ClickHouse as a destination, and setting up a CDC mirror in PeerDB's UI. PeerDB is available in open source and cloud forms, with planned integration into ClickHouse's native ingestion service ClickPipes.
Table of contents
Combining Neon and ClickHouse: operational efficiency with large-scale analyticsPeerDB brings Neon and ClickHouse closer togetherStreaming data from Neon to ClickHouse using PeerDBGetting started2 Impressions