PostgreSQL Join Optimization: Nested Loop, Hash, and Merge

If you've ever watched a query go from 30 ms to 30 seconds after a data load — without a single line of SQL changing — you've been on the wrong side of a join-strategy flip. Joins are the part of PostgreSQL that's most sensitive to statistics. A 10× ...