Skip to content
zarza zarza

102 Query optimization

07/10/2022 31 min Episodio 14
102 Query optimization

Listen "102 Query optimization"

Episode Synopsis


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 

More episodes of the podcast Postgres FM

pgrust 14/08/2026
MVCC 07/08/2026
Xata 31/07/2026
DBOS 24/07/2026
pg_stat_log 17/07/2026
pgBackRest 03/07/2026
autovacuum 29/05/2026
PgQue 08/05/2026

ZARZA Studio — Your station on air today: library, music clock, schedule, studio and reports, from the browser.

Meet ZARZA Studio
on air now stations in the catalogue 1,829,025 podcasts countries