• T
    Arrange to convert EXISTS subqueries that are equivalent to hashable IN · bd3dadda
    Tom Lane 提交于
    subqueries into the same thing you'd have gotten from IN (except always with
    unknownEqFalse = true, so as to get the proper semantics for an EXISTS).
    I believe this fixes the last case within CVS HEAD in which an EXISTS could
    give worse performance than an equivalent IN subquery.
    
    The tricky part of this is that if the upper query probes the EXISTS for only
    a few rows, the hashing implementation can actually be worse than the default,
    and therefore we need to make a cost-based decision about which way to use.
    But at the time when the planner generates plans for subqueries, it doesn't
    really know how many times the subquery will be executed.  The least invasive
    solution seems to be to generate both plans and postpone the choice until
    execution.  Therefore, in a query that has been optimized this way, EXPLAIN
    will show two subplans for the EXISTS, of which only one will actually get
    executed.
    
    There is a lot more that could be done based on this infrastructure: in
    particular it's interesting to consider switching to the hash plan if we start
    out using the non-hashed plan but find a lot more upper rows going by than we
    expected.  I have therefore left some minor inefficiencies in place, such as
    initializing both subplans even though we will currently only use one.
    bd3dadda
parse_expr.c 68.7 KB