Re: Merge Join vs Nested Loop

Поиск
Список
Период
Сортировка
От Tobias Brox
Тема Re: Merge Join vs Nested Loop
Дата
Msg-id 20060927153619.GG17834@oppetid.no
обсуждение исходный текст
Ответ на Merge Join vs Nested Loop  (Tobias Brox <tobias@nordicbet.com>)
Ответы Re: Merge Join vs Nested Loop  (Tobias Brox <tobias@nordicbet.com>)
Список pgsql-performance
[Scott Marlowe - Wed at 10:31:35AM -0500]
> And remember, you can always change any of those settings in session for
> just this one query to force the planner to make the right decision.

sure ... I could identify the most problematic queries, and hack up the
software application to modify the config settings for those exact
queries ... but it's a very ugly solution. :-)  Particularly if Tom Lane
is correct saying the preferance of merge join instead of nested loop is
indeed a bug.

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

Предыдущее
От: Scott Marlowe
Дата:
Сообщение: Re: Merge Join vs Nested Loop
Следующее
От: "Dave Dutcher"
Дата:
Сообщение: Re: Forcing the use of particular execution plans