summaryrefslogtreecommitdiff
path: root/src/backend/optimizer/plan/planner.c
AgeCommit message (Expand)Author
2001-12-10Suppress subquery pullup and pushdown when the subquery has anyTom Lane
2001-11-05New pgindent run with fixes suggested by Tom. Patch manually reviewed,Bruce Momjian
2001-10-30Fix problems with subselects used in GROUP BY expressions, per gripeTom Lane
2001-10-28Another pgindent run. Fixes enum indenting, and improves #endifBruce Momjian
2001-10-25pgindent run on all C files. Java run to follow. initdb/regressionBruce Momjian
2001-10-18Extend code that deduces implied equality clauses to detect whether aTom Lane
2001-06-05Further work on making use of new statistics in planner. Adjust APIsTom Lane
2001-05-20Modify optimizer data structures so that IndexOptInfo lists built forTom Lane
2001-05-07Rewrite of planner statistics-gathering code. ANALYZE is now available asTom Lane
2001-04-30Suppress pull-up of subqueries that are in the nullable side of an outerTom Lane
2001-04-18Make the world safe for passing whole rows of views to functions. ThisTom Lane
2001-04-01Planner wasn't correctly handling adjustment of tuple_fraction for theTom Lane
2001-03-22pgindent run. Make it all clean.Bruce Momjian
2001-01-27Don't crash if subquery appears multiple times in jointree. This shouldTom Lane
2001-01-24Change Copyright from PostgreSQL, Inc to PostgreSQL Global Development Group.Bruce Momjian
2001-01-18Fix performance issue with qualifications on VIEWs: outer query shouldTom Lane
2000-12-14Planner speedup hacking. Avoid saving useless pathkeys, so that pathTom Lane
2000-12-06Clean up handling of FOR UPDATE inside views and subselects ... make itTom Lane
2000-11-12Restructure handling of inheritance queries so that they work with outerTom Lane
2000-11-09Repair some bugs in new union/intersect/except code.Tom Lane
2000-11-05Allow ORDER BY, LIMIT in sub-selects. Fix most (not all) cases whereTom Lane
2000-10-26Re-implement LIMIT/OFFSET as a plan node type, instead of a hack inTom Lane
2000-10-05Reimplementation of UNION/INTERSECT/EXCEPT. INTERSECT/EXCEPT now meet theTom Lane
2000-09-29Subselects in FROM clause, per ISO syntax: FROM (SELECT ...) [AS] alias.Tom Lane
2000-09-25System neglected to complain about ungrouped variables passed toTom Lane
2000-09-12First cut at full support for OUTER JOINs. There are still a few looseTom Lane
2000-08-21Move pg_checkretval out of the planner (where it never belonged) intoTom Lane
2000-08-08Remove 'func_tlist' from Func expression nodes, likewise 'param_tlist'Tom Lane
2000-07-27Make planner safe for recursive calls --- needed for cases whereTom Lane
2000-06-20Make inheritance planning logic a little simpler and clearer,Tom Lane
2000-06-18Reimplement nodeMaterial to use a temporary BufFile (or even memory, if theTom Lane
2000-06-15Clean up #include's.Bruce Momjian
2000-06-09Cause inheritance patch to meet minimum coding standards (no gccTom Lane
2000-06-09Inheritance overhaul by Chris Bitmead <chris@bitmead.com>Bruce Momjian
2000-05-30Remove unused include files. Do not touch /port or includes used by defines.Bruce Momjian
2000-04-12Ye-old pgindent run. Same 4-space tabs.Bruce Momjian
2000-03-21Restructure planning code so that preprocessing of targetlist and qualsTom Lane
2000-03-14Fix some bogosities in the code that deals with estimating the fractionTom Lane
2000-02-21Tweak planner to use OFFSET+LIMIT, not just LIMIT, as estimate of theTom Lane
2000-02-15New cost model for planning, incorporating a penalty for random pageTom Lane
2000-01-27Redesign DISTINCT ON as discussed in pgsql-sql 1/25/00: syntax is nowTom Lane
2000-01-26Add:Bruce Momjian
1999-12-09Replace generic 'Illegal use of aggregates' error message with one thatTom Lane
1999-11-15Implement subselects in target lists. Also, relax requirement thatTom Lane
1999-10-07Fix planner and rewriter to follow SQL semantics for tables that areTom Lane
1999-09-26Implement constant-expression simplification per BernardTom Lane
1999-09-18Mega-commit to make heap_open/heap_openr/heap_close take anTom Lane
1999-09-13First cut at doing something reasonable with OR-of-ANDs WHERETom Lane
1999-08-26Clean up some mistakes in handling of uplevel Vars in planner.Tom Lane
1999-08-22Further sort-order twiddling in optimizer: be smart aboutTom Lane