EPISODE · Sep 23, 2022 · 32 MIN
Index maintenance
from Postgres FM · host Nikolay Samokhvalov and Michael Christofides
Important correction from this episode: amcheck promises no false positives, not no false negatives, sorry!Here are links to a few things we mentioned: pgstattuplepg_repackpostgres-checkup Workload Analysis for GitLab.comBloat Analysis (also from GitLab)Bloat, pg_repack, and deferred constraints (blog post by Miro) amcheckPeter Geoghegan interview (on Postgres TV) ------------------------What did you like or not like? What should we discuss next time? Let us know by tweeting us on @samokhvalov and @michristofides or by commenting on our topic ideas Google doc.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.aiMichael Christofides, founder of pgMustardWith special thanks to:Jessie Draws for the elephant artwork
What this episode covers
Nikolay and Michael discuss index maintenance — how do we know if or when we need it, and what we need to do.
NOW PLAYING
Index maintenance
No transcript for this episode yet
Similar Episodes
Dec 4, 2025 ·32m
Nov 8, 2025 ·36m
Sep 18, 2025 ·26m