Building the Open Source Data Stack with Postgres and ClickHouse
Building the Open Source Data Stack with Postgres and ClickHouse
Presented by:
Kevin Biju
Kevin Biju is a developer at ClickHouse and a contributor to Postgres. Before joining ClickHouse, he was a founding engineer at PeerDB, an open source data replication platform built with focus on Postgres — which was later acquired by ClickHouse. With deep expertise in distributed systems, database internals, and data replication, Kevin’s work has directly impacted users of two major open-source databases, PostgreSQL and ClickHouse. He is passionate about open-source collaboration and improving how databases are built and operated.
Amogh Bharadwaj
Amogh Bharadwaj is a Software Engineer at ClickHouse Inc., based in Bangalore, India, where he works on ClickPipes, a platform that enables seamless data movement from Postgres and other sources into ClickHouse Cloud. Before joining ClickHouse through the acquisition of PeerDB, an open-source tool for real-time data replication from Postgres to ClickHouse, Amogh was a founding engineer contributing to its core engine, UI, and customer success. Passionate about building scalable data systems, he combines deep technical expertise in Go, Postgres, and full-stack development with hands-on experience helping users move data effortlessly across databases.
No video of the event yet, sorry!
An increasing number of organizations are adopting a proven architectural pattern: using PostgreSQL for transactional workloads and ClickHouse for analytics. Instead of relying on a single database to do everything, this approach combines two mature open-source systems — each optimized for its specific purpose. It’s the foundation behind real-time data platforms at companies like GitLab, Cloudflare, Instacart and 1000s of other companies.
In this training, you’ll learn how to integrate Postgres and ClickHouse to build a high-performance, open-source data stack that supports real-time applications. We’ll cover:
Deploying Postgres and ClickHouse seamlessly in your environment
Setting up real-time replication from Postgres to ClickHouse using PeerDB, an open-source Change Data Capture (CDC) tool designed for this use case
Using the pg_clickhouse extension to query ClickHouse directly from Postgres, enabling a unified query layer for your applications
By the end of this session, you’ll understand how to connect and operate these technologies together to deliver real-time analytics — with simplicity, flexibility, and open-source power.
Learning Objectives:
By the end of this session, attendees will gain practical knowledge to design and implement an open-source data architecture that integrates Postgres and ClickHouse to power real-time analytics for modern applications, the same pattern trusted by companies like GitLab, Cloudflare, Instacart and more.
- Date:
- Duration:
- 3 h 30 min
- Room:
- Conference:
- PGConf India, 2026
- Language:
- Track:
- Training
- Difficulty:
- Medium