Re: [HACKERS] Turn off transitive joins - Mailing list pgsql-hackers

From Tom Lane
Subject Re: [HACKERS] Turn off transitive joins
Date
Msg-id 32036.1508011675@sss.pgh.pa.us
Whole thread Raw
In response to [HACKERS] Turn off transitive joins  (Gourav Kumar <gourav1905@gmail.com>)
Responses Re: [HACKERS] Turn off transitive joins
List pgsql-hackers
Gourav Kumar <gourav1905@gmail.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


-- 
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers

pgsql-hackers by date:

Previous
From: Gourav Kumar
Date:
Subject: [HACKERS] Turn off transitive joins
Next
From: Gourav Kumar
Date:
Subject: Re: [HACKERS] Turn off transitive joins