• T
    Major revision of sort-node handling: push knowledge of query · db436adf
    Tom Lane 提交于
    sort order down into planner, instead of handling it only at the very top
    level of the planner.  This fixes many things.  An explicit sort is now
    avoided if there is a cheaper alternative (typically an indexscan) not
    only for ORDER BY, but also for the internal sort of GROUP BY.  It works
    even when there is no other reason (such as a WHERE condition) to consider
    the indexscan.  It works for indexes on functions.  It works for indexes
    on functions, backwards.  It's just so cool...
    
    CAUTION: I have changed the representation of SortClause nodes, therefore
    THIS UPDATE BREAKS STORED RULES.  You will need to initdb.
    db436adf
outfuncs.c 32.4 KB