EPISODE · Oct 7, 2022 · 31 MIN
102 Query optimization
from Postgres FM · host Nikolay Samokhvalov and Michael Christofides
Here are links to a few things we mentioned: pg_plan_advsr How partial, covering, and multicolumn indexes may slow down UPDATEs (blog post by Nikolay)Why Uber Switched from Postgres to MySQL (blog post)pganalyze index advisorNancy bot (project is not active)pgreplaypgreplay go Real Application Testing on YugabyteDB with pgreplay (blog post by Franck Pachot) pg_query Database Lab thin clones Migrating to Aurora: easy except the bill (blog post by Kimberley Nicholls) ------------------------What did you like or not like? What should we discuss next time? Let us know by tweeting us on @PostgresFM 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 amazing artwork
What this episode covers
Nikolay and Michael discuss the next step of query optimization work — the difficult topic of how to verify your changes won't make other things worse.
NOW PLAYING
102 Query optimization
No transcript for this episode yet
Similar Episodes
Dec 4, 2025 ·32m
Nov 8, 2025 ·36m
Sep 18, 2025 ·26m