Glossary: PostgreSQL Beyond the Basics

Hash Join, Merge Join, Nested Loop

Also written: Hash Join, Merge Join, Nested Loop, Hash, enable_nestloop

The three join methods. A Nested Loop searches the second input once per row of the first, a Hash Join probes a hash table of the second input, and a Merge Join walks two sorted inputs side by side.