Index maintenance | Postgres.FM 012 |
Nikolay and Michael discuss index maintenance — how do we know if or when we need it, and what we need to do.
Here are links to a few things we mentioned:
pgstattuple https://www.postgresql.org/docs/curre...
pg_repack https://github.com/reorg/pg_repack
postgres-checkup https://gitlab.com/postgres-ai/postgr...
Workload Analysis for GitLab.com https://about.gitlab.com/handbook/eng...
Bloat Analysis (also from GitLab) https://gitlab.com/gitlab-com/gl-infr...
Bloat, pg_repack, and deferred constraints (blog post by Miro) / postgresql-bloat-pg-repack-and-deferred-co...
amcheck https://www.postgresql.org/docs/curre...
Peter Geoghegan interview (on Postgres TV) • Postgres Thursday s01e02: Peter Geogh...
-----------------------
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
~~~
Postgres FM is brought to you by:
Nikolay Samokhvalov, founder of Postgres.ai
Michael Christofides, founder of pgMustard
~~~
This is the uncut version, with video. Check out https://Postgres.fm to find audio-only podcast episodes, edited for convenient listening.