Understanding & Managing Postgres Table Bloat | Citus Con: An Event for Postgres 2023

Video Description

Video of a conference talk about what table bloat is in Postgres, why it occurs, how to mitigate it, and (best of all) how to avoid tripping over it in the first place. This talk was presented at Citus Con: An Event for Postgres 2023, by Chelsea Dole. When making the jump from "running Postgres", to "running Postgres at scale", managing table bloat is a hurdle which many engineers trip over. To help you avoid these hurdles, this talk covers Multi-Version Concurrency Control (MVCC), Postgres autovacuum, and database table design. Chelsea Dole is a Senior Software Engineer at Brex, a fintech startup providing B2B credit access and expense management software. As an engineer on the Data Storage team, Chelsea builds Postgres infrastructure at scale, performs query optimization, and seeks to up-level organizational understanding of databases. Chelsea is active within the Postgres and Python communities, and has presented talks about cloud computing, data storage, and Python. ► Video bookmarks: ⏩ 00:00 Introduction ⏩ 01:52 Multi-version Concurrency Control (MVCC) ⏩ 08:19 Vacuum ⏩ 10:37 Table bloat ⏩ 14:27 Avoiding Postgres table bloat ⏩ 22:19 Designing bloat-aware data access patterns ✅ Learn more: Watch more Citus Con 2023 talks: https://aka.ms/cituscon-playlist 📕 Everything you need to know about Citus Con: An Event for Postgres can be found at: https://aka.ms/cituscon 📌 Let’s connect:   Twitter – @CitusCon, https://twitter.com/CitusCon #CitusCon #PostgreSQL #Database