Gourav Kumar <gourav1...@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