Postgres In Production Ep1. Different Kinds of Bloat & How to Fix It (Part 1)
Автор: pganalyze
Загружено: 2025-09-04
Просмотров: 1000
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
Доступные форматы для скачивания:
Скачать видео mp4
-
Информация по загрузке: