Subqueries and performance in PostgreSQL - CYBERTECwww.cybertec-postgresql.comexternal-link Jason Novinger ( @jnovinger@programming.dev ) M PostgreSQL@programming.dev • 1 year ago message-square1fedilinkarrow-up19
arrow-up19external-linkSubqueries and performance in PostgreSQL - CYBERTECwww.cybertec-postgresql.com Jason Novinger ( @jnovinger@programming.dev ) M PostgreSQL@programming.dev • 1 year ago message-square1fedilink
minus-square Gamma ( @GammaGames@beehaw.org ) linkfedilinkEnglish2•1 year agoI 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)
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)