On Wed, Jun 1, 2011 at 8:10 PM, Robert James <srobertjames@xxxxxxxxx> wrote: > 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? IME, hash joins usually are much faster than any other type. There's not enough information in your email to speculate as to what might be going wrong in your particular case, though. -- Robert Haas EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
