summaryrefslogtreecommitdiff
path: root/src/backend/optimizer
AgeCommit message (Expand)Author
2008-09-12Skip opfamily check in eclass_matches_any_index() when the index isn't aTom Lane
2008-09-09Improve the plan cache invalidation mechanism to make it invalidate plansTom Lane
2008-09-05Fix an oversight in the 8.2 patch that improved mergejoin performance byTom Lane
2008-09-01Add a bunch of new error location reports to parse-analysis error messages.Tom Lane
2008-08-28Extend the parser location infrastructure to include a location field inTom Lane
2008-08-26Teach eval_const_expressions() to simplify an ArrayCoerceExpr to a constantTom Lane
2008-08-25Move exprType(), exprTypmod(), expression_tree_walker(), and related routinesTom Lane
2008-08-22Arrange to convert EXISTS subqueries that are equivalent to hashable INTom Lane
2008-08-20Marginal improvement in sublink planning: allow unknownEqFalse optimizationTom Lane
2008-08-20Fix obsolete comment. It's no longer the case that Param nodes don'tTom Lane
2008-08-17Add some defenses against constant-FALSE outer join conditions. SinceTom Lane
2008-08-17Remove prohibition against SubLinks in the WHERE clause of an EXISTS subqueryTom Lane
2008-08-17Improve sublink pullup code to handle ANY/EXISTS sublinks that are at topTom Lane
2008-08-16Clean up the loose ends in selectivity estimation left by my patch for semiTom Lane
2008-08-14Fix pull_up_simple_union_all to copy all rtable entries from child subquery toHeikki Linnakangas
2008-08-14Implement SEMI and ANTI joins in the planner and executor. (Semijoins replaceTom Lane
2008-08-07Improve INTERSECT/EXCEPT hashing by realizing that we don't need to make anyTom Lane
2008-08-07Support hashing for duplicate-elimination in INTERSECT and EXCEPT queries.Tom Lane
2008-08-07Teach the system how to use hashing for UNION. (INTERSECT/EXCEPT will follow,Tom Lane
2008-08-05Department of second thoughts: fix newly-added code in planner.c to make realTom Lane
2008-08-05Improve SELECT DISTINCT to consider hash aggregation, as well as sort/uniq,Tom Lane
2008-08-03Make GROUP BY work properly for datatypes that only support hashing and notTom Lane
2008-08-02Rearrange the querytree representation of ORDER BY/GROUP BY/DISTINCT itemsTom Lane
2008-07-31Fix parser so that we don't modify the user-written ORDER BY list in orderTom Lane
2008-07-13Clean up the use of some page-header-access macros: principally, useTom Lane
2008-07-10Tighten up SS_finalize_plan's computation of valid_params to exclude Params ofTom Lane
2008-07-10Fix mis-calculation of extParam/allParam sets for plan nodes, as seen inTom Lane
2008-06-27Consider a clause to be outerjoin_delayed if it references the nullable sideTom Lane
2008-06-27Improve planner's estimation of the size of an append relation: rather thanTom Lane
2008-06-19Improve our #include situation by moving pointer types away from theAlvaro Herrera
2008-06-17Fix the code that adds regclass constants to a plan's list of relation OIDsTom Lane
2008-05-27Alter the xxx_pattern_ops opclasses to use the regular equality operator ofTom Lane
2008-05-16Extend GIN to support partial-match searches, and extend tsquery to supportTom Lane
2008-05-15Add code to eval_const_expressions() to support const-simplification ofTom Lane
2008-05-12Restructure some header files a bit, in particular heapam.h, by removing someAlvaro Herrera
2008-05-02Allow the planner's estimate of the fraction of a cursor's rows that will beTom Lane
2008-04-21Fix convert_IN_to_join to properly handle the case where the subselect'sTom Lane
2008-04-21Allow float8, int8, and related datatypes to be passed by value on machinesTom Lane
2008-04-17Fix a couple of oversights associated with the "physical tlist" optimization:Tom Lane
2008-04-13Since createplan.c no longer cares whether index operators are lossy, it hasTom Lane
2008-04-13Phase 2 of project to make index operator lossiness be determined at runtimeTom Lane
2008-04-09Small wording improvements for source code READMEs.Bruce Momjian
2008-04-09Revert README cleanups.Bruce Momjian
2008-04-09Revert sentence removal from nickname in FAQ.Bruce Momjian
2008-04-01Fix an oversight I made in a cleanup patch over a year ago:Tom Lane
2008-03-31Apply my original fix for Taiki Yamaguchi's bug report about DISTINCT MAX().Tom Lane
2008-03-29Revert my erroneous fix for Taiki Yamaguchi's DISTINCT MAX() bug.Tom Lane
2008-03-28Department of second thoughts: the rule that ORDER BY and DISTINCT areTom Lane
2008-03-27When we have successfully optimized a MIN or MAX aggregate into an indexscan,Tom Lane
2008-03-26Move the HTSU_Result enum definition into snapshot.h, to avoid includingAlvaro Herrera