summaryrefslogtreecommitdiff
path: root/src/backend/optimizer
AgeCommit message (Expand)Author
2003-02-16Back off previous patch to skip projection step in scan plan nodes,Tom Lane
2003-02-16COALESCE() and NULLIF() are now first-class expressions, not macrosTom Lane
2003-02-15Marginal tweaks to make sure that roundoff error won't cause us to makeTom Lane
2003-02-15Teach planner how to propagate pathkeys from sub-SELECTs in FROM up toTom Lane
2003-02-10Fix thinko in new logic about pushing down non-nullability constraints:Tom Lane
2003-02-09Detect case where an outer join can be reduced to a plain inner joinTom Lane
2003-02-09Create a distinction between Lists of integers and Lists of OIDs, to getTom Lane
2003-02-09Remove bogus comment (too freely copied & pasted).Tom Lane
2003-02-09Make further use of new bitmapset code: executor's chgParam, extParam,Tom Lane
2003-02-08Replace planner's representation of relation sets, per pghackers discussion.Tom Lane
2003-02-06Make flatten_join_alias_vars() do the right thing when expanding an aliasTom Lane
2003-02-04Minor code cleanup: remove no-longer-useful pull_subplans() function,Tom Lane
2003-02-03Determine the set of constraints applied to a domain at executorTom Lane
2003-02-03Tweak planner and executor to avoid doing ExecProject() in table scanTom Lane
2003-01-28Extend join-selectivity API (oprjoin interface) so that join type isTom Lane
2003-01-27Upgrade cost estimation for joins, per discussion with Bradley Baetz.Tom Lane
2003-01-25Allow the planner to collapse explicit inner JOINs together, rather thanTom Lane
2003-01-24Modify planner's implied-equality-deduction code so that when a setTom Lane
2003-01-22Make estimation of mergejoin scan selectivities more robust, per recentTom Lane
2003-01-22Implement choice between hash-based and sort-based grouping for doingTom Lane
2003-01-20IN clauses appearing at top level of WHERE can now be handled as joins.Tom Lane
2003-01-17Fix parse_agg.c to detect ungrouped Vars in sub-SELECTs; remove codeTom Lane
2003-01-17Adjust API of expression_tree_mutator and query_tree_mutator toTom Lane
2003-01-16Ooops, didn't cut-and-paste quite enough code from ResolveNew;Tom Lane
2003-01-15Now that switch_outer processing no longer relies on being run afterTom Lane
2003-01-15Allow merge and hash joins to occur on arbitrary expressions (anything notTom Lane
2003-01-13Reconsider mechanism for marking sub-selects that are at top level ofTom Lane
2003-01-13Cause planner to account for evaluation costs in targetlists andTom Lane
2003-01-12Revise cost_qual_eval() to compute both startup (one-time) and per-tupleTom Lane
2003-01-12First cut at implementing IN (and NOT IN) via hashtables. There isTom Lane
2003-01-10Further tweaking of parsetree & plantree representation of SubLinks.Tom Lane
2003-01-09Adjust parser so that 'x NOT IN (subselect)' is converted toTom Lane
2003-01-05Fix inherited UPDATE for cases where child column numbering doesn'tTom Lane
2002-12-30Better solution to integer overflow problem in hash batch-numberTom Lane
2002-12-26Clamp the output of estimate_hash_bucketsize() to a sane range;Tom Lane
2002-12-19Cause planner to include costs of InitPlans in startup cost of parentTom Lane
2002-12-17To suppress memory leakage in long-lived Lists, lremove() should pfreeTom Lane
2002-12-16Fix GEQO to work again in CVS tip, by being more careful about memoryTom Lane
2002-12-15Revise executor APIs so that all per-query state structure is built inTom Lane
2002-12-14Clean up plantree representation of SubPlan-s --- SubLink does not appearTom Lane
2002-12-13Phase 3 of read-only-plans project: ExecInitExpr now builds expressionTom Lane
2002-12-13Adjust costsize calculations to avoid introducing unnecessary roundoffTom Lane
2002-12-12Preliminary code review for domain CHECK constraints patch: add documentation,Tom Lane
2002-12-12Phase 2 of read-only-plans project: restructure expression-tree nodesTom Lane
2002-12-05Avoid pulling up sublinks from a subselect's targetlist. Works aroundTom Lane
2002-12-05Phase 1 of read-only-plans project: cause executor state nodes to pointTom Lane
2002-12-01Teach planner to expand sufficiently simple SQL-language functionsTom Lane
2002-11-30Code review for IS DISTINCT FROM patch. Fix incorrect constant-foldingTom Lane
2002-11-30Be more realistic about plans involving Materialize nodes: take theirTom Lane
2002-11-30Upgrade planner and executor to allow multiple hash keys for a hash join,Tom Lane