Gourav Kumar <[email protected]> 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 ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers