102 Query optimization | Postgres.FM 014 |
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...
Why Uber Switched from Postgres to MySQL (blog post) https://www.uber.com/en-GB/blog/postg...
pganalyze Index Advisor feature https://pganalyze.com/docs/index-advi...
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/pgrepla...
Real Application Testing on YugabyteDB with pgreplay (blog post by Franck Pachot) https://dev.to/yugabyte/real-applicat...
pg_query https://github.com/pganalyze/pg_query
Database Lab thin clones https://postgres.ai/products/how-it-w...
Migrating to Aurora: easy except the bill (blog post by Kimberley Nicholls) https://gridium.com/migrating-to-auro...
-----------------------
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.