Understanding Hash Join performance

Поиск
Список
Период
Сортировка
От Robert James
Тема Understanding Hash Join performance
Дата
Msg-id BANLkTikh3k=TcezOUk86k6CFw39oF6=uGA@mail.gmail.com
обсуждение исходный текст
Ответы Re: Understanding Hash Join performance
Re: Understanding Hash Join performance
Список 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 по дате отправления: