This is the last part of a three part series examining the Postgres join algorithms.

While a hash join is usually the fastest join algorithm, it is only so when it can be performed in memory. When Postgres thinks the hash … Read the rest

This is part two of a three part series examining the Postgres join algorithms.

Of the join algorithms Postgres has available, the hash join is usually the fastest. The main downside is hash joins only work where the join condition is an … Read the rest

This is the first part of a three part series examining the Postgres join algorithms.

For those who need a reminder, a join between two tables results in every pair of rows where some condition is true. Given a query of … Read the rest