Hash joins are finest if none of the involved relations are small, but the hash desk for the scaled-down table fits in work_mem. It is because or else PostgreSQL would Develop the hash in many batches and shop them in short-term disk files, which hurts overall performance. In this kind of conditions