Re: *_collapse_limit, geqo_threshold

Поиск
Список
Период
Сортировка
От Dimitri Fontaine
Тема Re: *_collapse_limit, geqo_threshold
Дата
Msg-id D98046E0-6DF0-4074-9AF6-694523CE6770@hi-media.com
обсуждение исходный текст
Ответ на Re: *_collapse_limit, geqo_threshold  (Robert Haas <robertmhaas@gmail.com>)
Ответы Re: *_collapse_limit, geqo_threshold  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
Список pgsql-hackers
Le 7 juil. 09 à 21:16, Robert Haas a écrit :
> Now, here's another thought: if we think it's reasonable for people
> to want to explicitly specify the join order, a GUC isn't really the
> best fit, because it's all or nothing.  Maybe we'd be better off
> dropping the GUCs entirely and adding some other bit of syntax that
> forces the join order, but only for that particular join.

MySQL calls them Straight Joins: http://www.mysqlperformanceblog.com/2006/12/28/mysql-session-variables-and-hints/

I'm not sure our best move here would be in this direction :)
--
dim

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

Предыдущее
От: Dimitri Fontaine
Дата:
Сообщение: Re: *_collapse_limit, geqo_threshold
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Have \d show child tables that inherit from the specified parent