102 Query optimization | Postgres.FM 014 | #PostgreSQL #Postgres podcast

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.

Links:

- pg_plan_advsr https://github.com/ossc-db/pg_plan_advsr
- How partial, covering, and multicolumn indexes may slow down UPDATEs (blog post by Nikolay) https://postgres.ai/blog/20211029-how-partial-and-covering-indexes-affect-update-performance-in-postgresql
- Why Uber Switched from Postgres to MySQL (blog post) https://www.uber.com/en-GB/blog/postgres-to-mysql-migration/
- pganalyze Index Advisor feature https://pganalyze.com/docs/index-advisor/getting-started
- Nancy bot (project is not active at the moment) https://gitlab.com/postgres-ai/nancy
- pgreplay https://laurenz.github.io/pgreplay/
- pgreplay go https://github.com/gocardless/pgreplay-go
- Real Application Testing on YugabyteDB with pgreplay (blog post by Franck Pachot) https://dev.to/yugabyte/real-application-testing-on-yugabytedb-with-pgreplay-4ibm
- pg_query https://github.com/pganalyze/pg_query
- Database Lab thin clones https://postgres.ai/products/how-it-works
- Migrating to Aurora: easy except the bill (blog post by Kimberley Nicholls) https://gridium.com/migrating-to-aurora-easy-except-the-bill/

-----------------------

What did you like or not like? What should we discuss next time? Let us know by tweeting us on @samokhvalov https://twitter.com/samokhvalov and @michristofides https://twitter.com/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.