Understanding Hash Join performance - Mailing list pgsql-performance

From Robert James
Subject Understanding Hash Join performance
Date
Msg-id BANLkTikh3k=TcezOUk86k6CFw39oF6=uGA@mail.gmail.com
Whole thread Raw
Responses Re: Understanding Hash Join performance
Re: Understanding Hash Join performance
List pgsql-performance
A query I has spends a long time on Hash Joins (and Hash Left Joins).
I have a few questions:

1. When does Postgres decide to do a Hash Join, over another type of Join?
2. Do Hash Joins normally perform poorly?  What can I do to speed them up?
3. What can I do to enable Postgres to use a faster type of join?

If there's a good resource for me to read on this, please let me know.

Thanks!

pgsql-performance by date:

Previous
From: Robert James
Date:
Subject: CLUSTER versus a dedicated table
Next
From: "mark"
Date:
Subject: Re: CLUSTER versus a dedicated table