Postgres In Production Ep1. Different Kinds of Bloat & How to Fix It (Part 1) скачать в хорошем качестве

Postgres In Production Ep1. Different Kinds of Bloat & How to Fix It (Part 1)

We are excited to launch Postgres in Production, a new video series hosted by Ryan Booz, a longtime Postgres community member and Solutions Engineer at pganalyze. Each episode is designed to help you understand the real issues that come up in production environments and show you step by step how to address them. Ryan will start with foundational concepts and then move into live demos on a real Postgres database, so you can apply what is discussed easily to your own database. The goal is to equip you with practical knowledge that helps you run Postgres reliably and efficiently at scale. In Episode 1, Ryan covers one of the most common and persistent challenges: bloat. You will learn: What bloat is and how it affects performance How VACUUM maintains your tables over time Which configuration settings matter most for efficiency How to detect bloat using views like pg_stat_user_tables and extensions like pgstattuple A demo showing the real impact of table bloat