Understanding Hash Join performance

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

Предыдущее
От: Robert James
Дата:
Сообщение: CLUSTER versus a dedicated table
Следующее
От: "mark"
Дата:
Сообщение: Re: CLUSTER versus a dedicated table