From: | Gourav Kumar <gourav1905(at)gmail(dot)com> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | pgsql-hackers <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: Turn off transitive joins |
Date: | 2017-10-14 20:11:13 |
Message-ID: | CAPzqDmg4Uutqw-=_7YQDCM7Z9=JCRsshSvC4_HZNCTzcOKWpnw@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
I don't think there is any need to add any such capability in postgresql,
but I need it for my work.
I need the join qualifiers.
On 15-Oct-2017 1:37 AM, "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> Gourav Kumar <gourav1905(at)gmail(dot)com> writes:
> > Is there some way by which I can tell postgresql to not to consider
> > transitive joins while considering join pairs.
>
> No ... and you have presented no reason whatever why we should consider
> adding such a capability.
>
> Maybe you should be trying to construct your join graph someplace
> earlier, before the optimizer processes the join quals.
>
> regards, tom lane
>
From | Date | Subject | |
---|---|---|---|
Next Message | Peter Eisentraut | 2017-10-14 21:04:41 | Re: pg_regress help output |
Previous Message | Tom Lane | 2017-10-14 20:07:55 | Re: Turn off transitive joins |