How to optimize correlated subqueries in Postgres

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:*

*Check out the pganalyze library for eBooks, webinars, and more:*

📑 *What we have discussed in this episode of 5mins of Postgres:*

*Subqueries and performance in PostgreSQL - by Laurenz Albe*

*Laurenz Albe on GitHub*

*The Basics of Postgres Query Planning*

*How Postgres Chooses Which Index To Use For A Query*

*Webinar Recording: How to use the Postgres query planner to debug bad plans and speed up queries*

*Postgres performance with IN vs ANY*

[raphaelsantanaguitar]

I am very glad to have found this channel! Got some performance concerns when working with a correlated subquery and this was very enlightening! Thanks