Episode 6
Vacuum
Nikolay and Michael discuss vacuum — what it is, why we need it, some improvements in recent years, and even a creative use for vacuum full.
Postgres FM · Nikolay Samokhvalov and Michael Christofides
August 12, 202232m 21s
Audio is streamed directly from the publisher (media.transistor.fm) as published in their RSS feed. Play Podcasts does not host this file. Rights-holders can request removal through the copyright & takedown page.
Show Notes
Here are links to a few things we mentioned:
- Do you vacuum everyday? (talk by Hannu Krosing)
- Autovacuum tuning (EDB guide)
- When autovacuum does not vacuum (2ndQuadrant blog post by Tomas Vondra)
- Autovacuum tuning basics (old 2ndQuadrant blog post)
- Discussion with Anastasia Lubennikova (on RuPostgres, in Russian)
- B-tree indexes (talk by Anastasia Lubennikova, in English)
- Discussion with Peter Geoghegan (on Postgres TV)
- pg_repack
- pg_squeeze
------------------------
What did you like or not like? What should we discuss next time? Let us know by tweeting us on @samokhvalov and @michristofides
If you would like to share this episode, here's a good link (and thank you!)
Postgres FM is brought to you by:
- Nikolay Samokhvalov, founder of Postgres.ai
- Michael Christofides, founder of pgMustard
With special thanks to:
- Jessie Draws for the elephant artwork
Topics
PostgresPostgreSQLDatabasesSQLtechnology