[ 🇬🇧_🇺🇸 Check out the subtitles - we now edit them, ChatGPT+manually! You can also try RU-vid's auto-translation of them from English to your language; try it and share it with people interested in Postgres!]
Michael is joined by Chelsea Dole, Staff Software Engineer and Tech Lead of the Data Storage Team at Brex, to discuss bloat. They cover what it is, why it's a problem, strategies for minimising it, and the options when it's really bad.
Here are some links to things they mentioned:
* Managing your tuple graveyard (talk by Chelsea) • Understanding & Managi...
* pgstattuple www.postgresql...
* pg_class www.postgresql...
* Bloat in PostgreSQL: a taxonomy (talk by Peter Geoghegan) • Bloat in PostgreSQL: a...
* It's Not You, It's Me: Breaking Up with Massive Tables via Partitioning (talk by Chelsea) • Chelsea Dole: It's Not...
* pg_repack github.com/reo...
* pg_squeeze github.com/cyb...
* VACUUM www.postgresql...
* autovacuum www.postgresql...
* CLUSTER www.postgresql...
* HOT updates www.postgresql...
* Our episode on BUFFERS postgres.fm/ep...
* Our episode on TOAST postgres.fm/ep...
* Our episode on index maintenance postgres.fm/ep...
* Chelsea's website chelseadole.com/
~~~
What did you like or not like? What should we discuss next time? Let us know in the comments, on social media (postgres.fm/pe..., or on our shared Google doc (docs.google.co...)
~~~
Postgres FM is produced by:
- Nikolay Samokhvalov, founder of Postgres.ai postgres.ai/
- Michael Christofides, founder of pgMustard pgmustard.com/
With special thanks to
- Jessie Draws for the artwork jessiedraws.com/
27 авг 2024