PostgreSQL Join Optimization: Nested Loop, Hash, and Merge

PostgreSQL has three join algorithms. The planner picks between them for every join in every query,...