Re: explicit joins wrong planning

Dnia 2003-11-28 22:57, Użytkownik Tom Lane napisał:
>     Restructure planning of nestloop inner indexscans so that the set
>     of usable joinclauses is determined accurately for each join. 
>     Formerly, the code only considered joinclauses that used all of the
>     rels from the outer side of the join; thus for example       FROM (a
>     CROSS JOIN b) JOIN c ON (c.f1 = a.x AND c.f2 = b.y) could not
>     exploit a two-column index on c(f1,f2), since neither of the qual
>     clauses would be in the joininfo list it looked in.  The new code
>     does this correctly, and also is able to eliminate redundant
>     clauses, thus fixing the problem noted 24-Oct-02 by Hans-Jürgen
>     Schönig.

Yes, this is a description of my problem. Thanks a lot.

Regards,
Tomasz Myrta