How to optimize correlated subqueries in Postgres
Find the article on our blog here: https://pganalyze.com/blog/5mins-post...
In episode 76 of “5mins of Postgres”, we are going to talk about how to optimize subqueries in Postgres by understanding the Postgres planner better. We look at correlated vs. uncorrelated subqueries, as well as scalar subqueries vs. tabular subqueries.
Learn more about pganalyze:
https://pganalyze.com
https://pganalyze.com/newsletter
/ pganalyze
Check out the pganalyze library for eBooks, webinars, and more:
https://pganalyze.com/resources
📑 What we have discussed in this episode of 5mins of Postgres:
Subqueries and performance in PostgreSQL - by Laurenz Albe
https://www.cybertec-postgresql.com/e...
Laurenz Albe on GitHub
http://localhost:8000/blog/5mins-postgres-optimize-subqueries
The Basics of Postgres Query Planning
https://pganalyze.com/docs/explain/ba...
How Postgres Chooses Which Index To Use For A Query
https://pganalyze.com/blog/how-postgr...
Webinar Recording: How to use the Postgres query planner to debug bad plans and speed up queries
• Webinar Recording: How to use the Postgres...
Postgres performance with IN vs ANY
https://pganalyze.com/blog/5mins-post...