| From: | Gourav Kumar <gourav1905(at)gmail(dot)com> |
|---|---|
| To: | pgsql-hackers <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Turn off transitive joins |
| Date: | 2017-10-14 19:57:03 |
| Message-ID: | CAPzqDmif8k_ZQ4XR06VfKrKHqtWPwbr96SP8SbAOA_2ecZRQ=A@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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 ?
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2017-10-14 20:07:55 | Re: Turn off transitive joins |
| Previous Message | Tomas Vondra | 2017-10-14 18:14:19 | PATCH: enabling parallel execution for cursors explicitly (experimental) |