Speaker:

Sai Srirampur

Date:

Mon Nov 2, 2026 @ 04:30pm EDT

Date:

Mon Nov 2, 2026

Time:

04:30pm EDT

Location:

https://cmu.zoom.us/j/92568565952?pwd=N8VKf5xfF5aisG9VoEwdNsCp0dCwel.1Zoom

Title:

Unifying Postgres and ClickHouse Natively

System:

ClickHouse

---

Talk Info:

PostgreSQL and ClickHouse are two of the most popular open-source databases, powering transactional and analytical workloads across thousands of mission-critical applications. But what does it take to bring these two fundamentally different database systems together?

In this talk, we’ll explore what we’re seeing in the field as customers increasingly look to bring OLTP and OLAP closer together, the challenges they face, and how these real-world requirements are shaping our engineering efforts at ClickHouse. We will discuss two components:

• WalShadow: A replication architecture that consumes PostgreSQL’s physical write-ahead log (WAL), bypassing traditional logical decoding to achieve replication latencies in the hundreds of milliseconds. We’ll explore its architecture and the challenges around consistency, schema evolution, and recovery.
• pg_clickhouse: A PostgreSQL extension that brings ClickHouse’s analytical capabilities into PostgreSQL. We’ll explore how it enables transactional and analytical queries through a single interface, including the architecture and challenges of query pushdown across two different execution engines.

The talk will offer a look at the latest innovations in unifying OLTP and OLAP with PostgreSQL and ClickHouse, the technical challenges involved, and how real-world production workloads are shaping these architectures.

This talk is part of the Whatever Andy Found Interesting While Out At Sea.

Bio:

Sai is a Director at ClickHouse. He leads all the Postgres efforts at ClickHouse. He was the CEO and Co-founder of PeerDB, which he sold to ClickHouse. Sai is a Postgres enthusiast who's helped thousands of companies get the most out of their databases. He built Postgres tools at Microsoft and was an early Citus Data employee (acquired by Microsoft).