Hash join in batches
When the hash table does not fit work_mem the join splits into batches and spills to temp files.
task
Set work_mem to 64kB and hash_mem_multiplier to 1, then EXPLAIN (ANALYZE, COSTS OFF, TIMING OFF, SUMMARY OFF) the join of lab.h1 and lab.h2 on id. Batches must exceed 1.