Vacuum | Postgres.FM 006 |
[Please subscribe, like, and share the materials in your social networks and groups!] 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.
Subscribe via a popular podcast service: https://postgres.fm/subscribe
Here are links to a few things we mentioned:
- Do you vacuum everyday? (talk by Hannu Krosing) • Hannu Krosing. Do you vacuum #Postgre...
- autovacuum tuning (EDB guide) https://www.enterprisedb.com/postgres...
- When autovacuum does not vacuum (2ndQuadrant blog post by Tomas Vondra) https://www.2ndquadrant.com/en/blog/w...
- Autovacuum tuning basics (2ndQuadrant blog post by Tomas Vondra) https://web.archive.org/web/202104170...
- Discussion with Anastasia Lubennikova (on RuPostgres, in Russian) • Postgres-вторник №11: развитие btree ...
- B-tree indexes (talk by Anastasia Lubennikova, in English) • B-tree indexes - learn more about the...
- Discussion with Peter Geoghegan (on Postgres TV) • Postgres Thursday s01e02: Peter Geogh...
- pg_repack https://github.com/reorg/pg_repack
- pg_squeeze https://github.com/cybertec-postgresq...
What did you like or not like? What should we discuss next time? Let us know by tweeting us on @samokhvalov / samokhvalov and @michristofides / michristofides