This article discusses how subqueries perform in PostgreSQL and how to rewrite queries to improve their performance.
  • Gamma@beehaw.orgEnglish
    2·
    1 year ago

    I wonder how CTEs perform compared to subqueries. I’ve mostly replaced subqueries with CTEs because they’re waaaay easier to maintain (especially when looking at someone else’s code)