[HACKERS] Turn off transitive joins

Поиск
Список
Период
Сортировка
От Gourav Kumar
Тема [HACKERS] Turn off transitive joins
Дата
Msg-id CAPzqDmif8k_ZQ4XR06VfKrKHqtWPwbr96SP8SbAOA_2ecZRQ=A@mail.gmail.com
обсуждение исходный текст
Ответы Re: [HACKERS] Turn off transitive joins  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers

Hi all,

Is there some way by which I can tell postgresql to not to consider transitive joins while considering join pairs.

I.e. Let's say a query has two join predicates one between A & B relations and the other between B and C relations.

While constructing the DP to find the best join order, the Optimizer also consider join between A & C, which can be thought of as a transitive join.

Is their some way to turn this off or tell postgresql to not to consider these type of joins ?

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

Предыдущее
От: Tomas Vondra
Дата:
Сообщение: [HACKERS] PATCH: enabling parallel execution for cursors explicitly(experimental)
Следующее
От: Tom Lane
Дата:
Сообщение: Re: [HACKERS] Turn off transitive joins