r/PostgreSQL • u/Koushik5586 • Mar 20 '22
How-To Mastering SQL Query Optimization
https://tvkoushik.medium.com/mastering-sql-query-optimization-622cc6addef2?sk=8e8edbfd5cd370461aa25cfb8d667c12
12
Upvotes
r/PostgreSQL • u/Koushik5586 • Mar 20 '22
4
u/coyoteazul2 Mar 20 '22
Some were new to me, like cte spilling or In being required to scan the whole table (I knew EXISTS was better but I didn't know why)
A few of the points felt under explained
I think it would have been a more interesting read with some benchmarks.