tubeshowcase●1,670,700 videos♡ My collection 0
← Learn to Code

Learn to Code26:35

Postgres isn’t slow, your storage is | POSETTE: An Event for Postgres 2026

Microsoft Developer ↗

From the creator

Understand why large dataset bottlenecks are often due to storage rather than Postgres. Sai Srirampur (ClickHouse) explains this in his talk “Postgres isn’t slow, your storage is” at POSETTE: An Event for Postgres 2026. Abstract: A lot of Postgres “scaling problems” look the same: low CPU, high latency, falling insert rates, and unpredictable behavior once the dataset gets big, in the TBs. In most cases we’ve investigated, the bottleneck wasn’t Postgres it was slow or inconsistent storage. In this talk we run the same workloads on networked block storage and on local NVMe and show what actually changes. Using perf, flamegraphs, and Postgres internal stats, we demonstrate how WAL fsync, buffer reads, and checkpoints dominate on slow IO, and how those costs largely disappear on NVMe. Insert-heavy time-series workloads scale linearly, OLTP latency stays stable under reporting queries, and performance becomes predictable. We also show where NVMe does not help. For wide scans and repeated aggregations over hundreds of millions of rows, Postgres still spends most of its time in executor and tuple-processing code. Fast storage moves the bottleneck to CPU, but it doesn’t turn a row store into a column store. Sai Srirampur is a Director at ClickHouse, where he leads all Postgres efforts. Prior to ClickHouse, he was the CEO and Co-founder of PeerDB, which was acquired by ClickHouse. Before that, he was a leader on the Microsoft Postgres team and an early engineer at Citus Data. ► V

Published 2026-06-17 · Watch on YouTube ↗
Availability and playback restrictions are controlled by the original channel.

Keep exploring Learn to Code