Typical application mistakes that lead to bloat in PostgreSQL

on YouTube ↗51m

" summary

The talk examines common application-design and coding mistakes that cause table/index bloat in PostgreSQL, explaining how specific practices during development lead to bloat and consequent performance degradation. It focuses on concrete examples of those mistakes and their effects on PostgreSQL storage and performance.

AI-written summary · about

" chapters (7)

1. 0:00Introduction
2. 1:14Long transactions and consequences
3. 12:01How autovacuum works
4. 19:47Load balancing mistakes
5. 29:19Data migration problems
6. 35:44Tools to fight bloat
7. 40:05Q&A

" related talks

• 53mTop Development Mistakes When Working with PostgreSQLAleksey Lesovskiy · HighLoad++ Moscow 2018
• 47mPostgreSQL worst practicesIlya Kosmodemyanskiy · HighLoad++ 2017
• 25mUnderstanding & Managing Postgres Table BloatChelsea Dole · Citus Con: An Event for Postgres 2023
• 46mHow PostgreSQL Can Hurt You When You Least Expect ItMikhail Zhilin · Joker 2024
• 51mPostgreSQL: Practical Examples of SQL Query OptimizationIvan Frolkov · HighLoad++ 2016
• 50mPostgreSQL gotchas for app developersMagnus Hagander · foss-north 2019
• 50mAnomalies Under Load in PostgreSQL 2.0Mikhail Zhilin · HighLoad++ 2024
• 01h 00mThe 10 Deadly PostgreSQL SinsMatt Yonkovit · Percona Community Live 2022