This article discusses how subqueries perform in PostgreSQL and how to rewrite queries to improve their performance.
  • GammaEnglish
    2•10 months 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)