Top.Mail.Ru
Struggle against database bloating (Alexander Nikitin) | PGConf.Russia 2023 | PGConf.Russia

title

text

Alexander Nikitin
Alexander Nikitin ЗАО «ЦФТ»
15:45 03 April
45 min

Struggle against database bloating

Every DBA has in one way or another experienced the situation when PostgreSQL tables and indexes grow significantly in size. While looking for the reason for such behavior, we often conclude that database objects have "bloated". In this talk, we'll discuss the reasons behind bloating, create a testing environment to define the best method to reduce bloating. We'll also compare several anti-bloating utilities and get familiar with one more tool that helps us to efficiently struggle against bloating. We expect this presentation to become helpful for PostgreSQL DBAs of any experience level.

Slides

Никитин.pptx

Video

Other talks