Postgres Pro
Downloads
Home   >   mailing lists

pgsql: Be a little smarter about qual handling for semi-joins: a qual - Mailing list pgsql-committers

From tgl@postgresql.org (Tom Lane)
Subject pgsql: Be a little smarter about qual handling for semi-joins: a qual
Date
Msg-id 20081025195132.8D46B7545A4@cvs.postgresql.org
Whole thread Raw
List pgsql-committers
Tree view 
Log Message:
-----------
Be a little smarter about qual handling for semi-joins: a qual that mentions
only the outer side can be pushed down rather than having to be evaluated
at the join.

Modified Files:
--------------
    pgsql/src/backend/optimizer/plan:
        initsplan.c (r1.143 -> r1.144)
        (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/backend/optimizer/plan/initsplan.c?r1=1.143&r2=1.144)

pgsql-committers by date:

Previous
From: tgl@postgresql.org (Tom Lane)
Date:
Subject: pgsql: Add a heuristic to transformAExprIn() to make it prefer expanding
Next
From: tgl@postgresql.org (Tom Lane)
Date:
Subject: pgsql: Better solution to the IN-list issue: instead of having an