Bloat in PostgreSQL: a taxonomy
Talk by Peter Geoghegan
https://www.socallinuxexpo.org/scale/...
This talk will show how bloat can accumulate, what that looks like at the page level and at the level of entire tables and indexes, and how that may impact production queries. It goes into depth about the theory of operation behind VACUUM in Postgres.