summaryrefslogtreecommitdiff
path: root/src/include/optimizer
AgeCommit message (Expand)Author
2008-11-11Get rid of adjust_appendrel_attr_needed(), which has been broken ever sinceTom Lane
2007-10-04Keep the planner from failing on "WHERE false AND something IN (SELECT ...)".Tom Lane
2007-07-31Fix a bug in the original implementation of redundant-join-clause removal:Tom Lane
2007-05-22Fix best_inner_indexscan to return both the cheapest-total-cost andTom Lane
2007-02-16Restructure code that is responsible for ensuring that clauseless joins areTom Lane
2006-12-12Fix planner to do the right thing when a degenerate outer join (one whoseTom Lane
2006-10-04pgindent run for 8.2.Bruce Momjian
2006-09-25Increase default value of effective_cache_size to 128MB, per discussion.Tom Lane
2006-09-19Improve usage of effective_cache_size parameter by assuming that all theTom Lane
2006-08-12Add INSERT/UPDATE/DELETE RETURNING, with basic docs and regression tests.Tom Lane
2006-08-02Add support for multi-row VALUES clauses as part of INSERT statementsJoe Conway
2006-07-31Change the relation_open protocol so that we obtain lock on a relationTom Lane
2006-07-26Convert effective_cache_size to an integer, for better integration withPeter Eisentraut
2006-07-26Change LIMIT/OFFSET to use int8Bruce Momjian
2006-07-22In the recent changes to make the planner account better for cacheTom Lane
2006-07-15Fix some missing inclusions identified with new pgcheckdefines tool.Tom Lane
2006-07-13Allow include files to compile own their own.Bruce Momjian
2006-07-01Revise the planner's handling of "pseudoconstant" WHERE clauses, that isTom Lane
2006-06-06Make the planner estimate costs for nestloop inner indexscans on the basisTom Lane
2006-06-05Increase the default value of cpu_index_tuple_cost from 0.001 to 0.005.Tom Lane
2006-06-05Add a GUC parameter seq_page_cost, and use that everywhere we formerlyTom Lane
2006-03-05Update copyright for 2006. Update scripts.Bruce Momjian
2006-02-05Improve my initial, rather hacky implementation of joins to appendTom Lane
2006-02-04Fix constraint exclusion to work in inherited UPDATE/DELETE queriesTom Lane
2006-02-03Teach planner to convert simple UNION ALL subqueries into append relations,Tom Lane
2006-02-03Update random() usage so ranges are inclusive/exclusive as required.Bruce Momjian
2006-01-31Restructure planner's handling of inheritance. Rather than processingTom Lane
2006-01-29Fix code that checks to see if an index can be considered to match the query'sTom Lane
2006-01-25Allow row comparisons to be used as indexscan qualifications.Tom Lane
2005-12-20Teach planner how to rearrange join order for some classes of OUTER JOIN.Tom Lane
2005-11-26Teach tid-scan code to make use of "ctid = ANY (array)" clauses, so thatTom Lane
2005-11-25Teach planner and executor to handle ScalarArrayOpExpr as an indexableTom Lane
2005-11-14Restore the former RestrictInfo field valid_everywhere (but invert the flagTom Lane
2005-10-15Standard pgindent run for 8.1.Bruce Momjian
2005-09-28Repair planning bug introduced in 7.4: outer-join ON clauses that referencedTom Lane
2005-08-27Change the division of labor between grouping_planner and query_plannerTom Lane
2005-08-22enable_constraint_exclusion => constraint_exclusionBruce Momjian
2005-08-18Fix up LIMIT/OFFSET planning so that we cope with non-constant LIMITTom Lane
2005-07-28Fix a bunch of bad interactions between partial indexes and the newTom Lane
2005-07-23Simple constraint exclusion. For now, only child tables of inheritanceTom Lane
2005-07-02Teach planner about some cases where a restriction clause can beTom Lane
2005-06-10Separate predicate-testing code out of indxpath.c, making it a moduleTom Lane
2005-06-10If a LIMIT is applied to a UNION ALL query, plan each UNION arm asTom Lane
2005-06-09Simplify the planner's join clause management by storing join clausesTom Lane
2005-06-05Remove planner's private fields from Query struct, and put them intoTom Lane
2005-05-22Teach the planner to remove SubqueryScan nodes from the plan if theyTom Lane
2005-04-25Replace slightly klugy create_bitmap_restriction() function with aTom Lane
2005-04-25Remove support for OR'd indexscans internal to a single IndexScan planTom Lane
2005-04-22First cut at planner support for bitmap index scans. Lots to do yet,Tom Lane
2005-04-21Rethink original decision to use AND/OR Expr nodes to represent bitmapTom Lane