Re: Merge Join vs Nested Loop

Поиск
Список
Период
Сортировка
От Tobias Brox
Тема Re: Merge Join vs Nested Loop
Дата
Msg-id 20060927150512.GE17834@oppetid.no
обсуждение исходный текст
Ответ на Re: Merge Join vs Nested Loop  (Scott Marlowe <smarlowe@g2switchworks.com>)
Ответы Re: Merge Join vs Nested Loop  (Scott Marlowe <smarlowe@g2switchworks.com>)
Список pgsql-performance
[Scott Marlowe - Wed at 09:58:30AM -0500]
> Have you tried chaning the cpu_* cost options to see how they affect
> merge versus nested loop?

As said in the original post, increasing any of them shifts the planner
towards nested loops instead of merge_join.  I didn't check which one of
the cost constants made the most impact.

В списке pgsql-performance по дате отправления:

Предыдущее
От: Scott Marlowe
Дата:
Сообщение: Re: Merge Join vs Nested Loop
Следующее
От: Scott Marlowe
Дата:
Сообщение: Re: Merge Join vs Nested Loop