summaryrefslogtreecommitdiff
path: root/src/include/optimizer
AgeCommit message (Expand)Author
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
2005-04-21Install some slightly realistic cost estimation for bitmap index scans.Tom Lane
2005-04-19Create executor and planner-backend support for decoupled heap and indexTom Lane
2005-04-12Fix oversight in MIN/MAX optimization: must not return NULL entriesTom Lane
2005-04-11Create the planner mechanism for optimizing simple MIN and MAX queriesTom Lane
2005-04-06Merge Resdom nodes into TargetEntry nodes to simplify code and save aTom Lane
2005-03-28Rethink the order of expression preprocessing: eval_const_expressionsTom Lane
2005-03-27Add a back-link from IndexOptInfo structs to their parent RelOptInfoTom Lane
2005-03-26Expand the 'special index operator' machinery to handle special casesTom Lane
2005-03-17This patch moves some code for preprocessing FOR UPDATE fromNeil Conway