summaryrefslogtreecommitdiff
path: root/src/backend/optimizer/path
AgeCommit message (Expand)Author
2001-12-10Suppress subquery pullup and pushdown when the subquery has anyTom Lane
2001-11-11In find_mergeclauses_for_pathkeys, it's okay to return multiple mergeTom Lane
2001-11-11sort_inner_and_outer needs a check to ensure that it's consumed all theTom Lane
2001-11-05New pgindent run with fixes suggested by Tom. Patch manually reviewed,Bruce Momjian
2001-10-30Fix small problem Tom Lane found with pgindent run.Bruce Momjian
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-08-21Restructure pg_opclass, pg_amop, and pg_amproc per previous discussions inTom Lane
2001-08-06Modify partial-index-predicate applicability tester to test whetherTom Lane
2001-07-31Fix optimizer to not try to push WHERE clauses down into a sub-SELECT thatTom Lane
2001-07-16Do not push down quals into subqueries that have LIMIT/OFFSET clauses,Tom Lane
2001-07-16Partial indexes work again, courtesy of Martijn van Oosterhout.Tom Lane
2001-06-25Optimizer can now estimate selectivity of IS NULL, IS NOT NULL,Tom Lane
2001-06-17Make inet/cidr << and <<= operators indexable. From Alex Pilosov <alex@pilos...Tom Lane
2001-06-11Make planner compute the number of hash buckets the same way thatTom Lane
2001-06-10Fix thinko in hash cost estimation: average frequencyTom Lane
2001-06-05Improve planning of OR indexscan plans: for quals likeTom 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-09First cut at making indexscan cost estimates depend on correlationTom Lane
2001-05-09Cause planner to make use of average-column-width statistic that is nowTom Lane
2001-05-08Add newlines around debug output in optimizer showing total costs.Bruce Momjian
2001-05-07Rewrite of planner statistics-gathering code. ANALYZE is now available asTom Lane
2001-04-25Tweak nestloop costing to weight restart cost of inner path more heavily.Tom Lane
2001-04-15Prevent generation of invalid plans for RIGHT or FULL joins with multipleTom Lane
2001-03-23Fix comments that were mis-wrapped, for Tom Lane.Bruce Momjian
2001-03-22Remove dashes in comments that don't need them, rewrap with pgindent.Bruce Momjian
2001-03-22pgindent run. Make it all clean.Bruce Momjian
2001-02-16Clean up two rather nasty bugs in operator selection code.Tom Lane
2001-02-16Take OUTER JOIN semantics into account when estimating the size of joinTom Lane
2001-02-15Update a couple of obsolete comments.Tom Lane
2001-02-03Fix inappropriate attempt to push down qual clauses into a view thatTom 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
2001-01-17Change lcons(x, NIL) to makeList(x) where appropriate.Bruce Momjian
2000-12-18Make sure make_rels_by_clause_joins doesn't return multiple referencesTom Lane
2000-12-14Planner speedup hacking. Avoid saving useless pathkeys, so that pathTom Lane
2000-12-12Cache eval cost of qualification expressions in RestrictInfo nodes toTom Lane
2000-11-25Store current LC_COLLATE and LC_CTYPE settings in pg_control during initdb;Tom Lane
2000-11-23Ensure that mergejoin plan will be considered for FULL OUTER JOIN evenTom Lane
2000-11-16Change SearchSysCache coding conventions so that a reference count isTom Lane
2000-11-12Restructure handling of inheritance queries so that they work with outerTom Lane
2000-10-25Ensure clause_selectivity() behaves sanely when examining an uplevel VarTom Lane
2000-10-05Add proofreader's changes to docs.Bruce Momjian
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-19Fix GEQO optimizer to work correctly with new outer-join-capableTom Lane
2000-09-15Reimplement LIKE/ESCAPE as operators so that indexscan optimizationTom Lane
2000-09-12First cut at full support for OUTER JOINs. There are still a few looseTom Lane