About
Sai leads all the Postgres and Database integration 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 hundreds 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).
Sai Srirampur has presented the following presentations
A lesser known Superpower of Postgres Logical Replication: Protocol Versions
at
Postgres Conference 2025
presented by Sai Srirampur
Did you know that Logical Replication has four protocol versions, each adding more features to the Postgres Logical Replication protocol, from drastically impacting performance to supporting more complex SQL commands?
In this talk, we will take a deep dive into each of these protocol versions and explore the use cases where they make sense, from the perspective of both Postgres and an extern...
more Thu 20 2025 Essentials
Overcoming Common Pitfalls of Postgres Logical Decoding
at
Seattle 2024
presented by Sai Srirampur
video
PeerDB provides a fast and simple way to replicate data from Postgres to ClickHouse. We implement Postgres Change Data Capture (CDC) to reliably replicate changes from Postgres to ClickHouse. Postgres Logical Decoding is a building block of Postgres CDC. It enables users to stream changes on Postgres as a sequence of logical operations like INSERTs, UPDATEs, and DELETEs. Logical Decoding has ev...
more Thu 7 2024 Dev
How can we make pg_dump and pg_restore 10 times faster?
at
Postgres Conference 2024
N/A
presented by Sai Srirampur
pg_dump and pg_restore are reliable tools for backing up and restoring Postgres databases. They are widely used for various real-world use cases, including Database Migrations, Disaster Recovery, and more.They offer fine grain control, allowing selection of specific db objects for backup and restore, choice of dump format (plain text or compressed), and parallel processing of multiple tables....
more Fri 19 2024 Dev
What does it take to build a first class data movement tool for Postgres?
at
Postgres Conference 2024
N/A
presented by Sai Srirampur
Every datastore is unique with a diverse set of features and data modeling characteristics. For example, PostgreSQL has 4 ways to ingest data, 5 ways to read data, 300+ data types and 300+ database configs. Building data movement solutions that scale, therefore, requires an emphasis on the unique design and capabilities of each data store.
However, most existing data movement tools focus on ...
more Fri 19 2024 Dev