Date: 2025-04-25
Time: 10:10–10:55
Room: East
Level: Intermediate
When making the leap from "running Postgres" to "running Postgres at scale", managing table bloat is a hurdle which many engineers trip over. In this talk, we discuss everything from Postgres internals to application design on the journey to understanding table bloat, why it occurs, how to manage it, and how to avoid tripping over it in the first place.
This talk will cover: multi-version concurrency control (MVCC), vacuum & its multiple roles, identifying and quantifying bloat, and dealing with bloated systems