r/PostgreSQL • • Mar 20 '22

How-To Mastering SQL Query Optimization

https://tvkoushik.medium.com/mastering-sql-query-optimization-622cc6addef2?sk=8e8edbfd5cd370461aa25cfb8d667c12
12 Upvotes

15 comments sorted by

View all comments

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.