Re: Improving planning of outer joins

Поиск
Список
Период
Сортировка
От Christopher Kings-Lynne
Тема Re: Improving planning of outer joins
Дата
Msg-id 43A22428.6090208@familyhealth.com.au
обсуждение исходный текст
Ответ на Improving planning of outer joins  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
> I'm not sure whether we'd need any additional planner knobs to control
> this.  I think that the existing join_collapse_limit GUC variable should
> continue to exist, but its effect on left/right joins will be the same as
> for inner joins.  If anyone wants to force join order for outer joins more
> than for inner joins, we'd need some other control setting, but I don't
> currently see why that would be very useful.
> 
> Does this seem like a reasonable agenda, or am I thinking too small?
> 
>             regards, tom lane
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 6: explain analyze is your friend




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

Предыдущее
От: "Jim C. Nasby"
Дата:
Сообщение: Re: Automatic function replanning
Следующее
От: Christopher Kings-Lynne
Дата:
Сообщение: Re: [pgadmin-hackers] Client-side password encryption