summaryrefslogtreecommitdiff
path: root/src/backend/optimizer
AgeCommit message (Expand)Author
2006-09-19Improve usage of effective_cache_size parameter by assuming that all theTom Lane
2006-09-08Put back plan-time check for trying to apply SELECT FOR UPDATE/SHARETom Lane
2006-09-06Change processing of extended-Query mode so that an unnamed statementTom Lane
2006-08-28Tweak trivial_subqueryscan() to consider a SubqueryScan's targetlistTom Lane
2006-08-25Add the ability to create indexes 'concurrently', that is, withoutTom Lane
2006-08-19Suppress subquery pullup/pushdown when a subquery contains volatileTom Lane
2006-08-17Fix an oversight in mergejoin planning: the planner would reject aTom Lane
2006-08-17Teach convert_subquery_pathkeys() to handle the case where theTom Lane
2006-08-12Tweak SPI_cursor_open to allow INSERT/UPDATE/DELETE RETURNING; this wasTom Lane
2006-08-12Add INSERT/UPDATE/DELETE RETURNING, with basic docs and regression tests.Tom Lane
2006-08-10Fix UNION/INTERSECT/EXCEPT so that when two inputs being merged haveTom Lane
2006-08-05Fix inheritance_planner() to delete dummy subplans from its Append planTom Lane
2006-08-05Extend relation_excluded_by_constraints() to check for mutuallyTom Lane
2006-08-05Teach predicate_refuted_by() how to do proofs involving NOT-clauses.Tom Lane
2006-08-04Teach eval_const_expressions to simplify BooleanTest nodes that haveTom 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-27Aggregate functions now support multiple input arguments. I also tookTom Lane
2006-07-26Code review for bigint-LIMIT patch. Fix missed planner dependency,Tom 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-14Remove 576 references of include files that were not needed.Bruce Momjian
2006-07-13More include file adjustments.Bruce Momjian
2006-07-11Alphabetically order reference to include files, "S"-"Z".Bruce Momjian
2006-07-11Alphabetically order reference to include files, "N" - "S".Bruce Momjian
2006-07-11Alphabetically order reference to include files, "G" - "M".Bruce Momjian
2006-07-11Sort reference of include files, "A" - "F".Bruce Momjian
2006-07-01Fix oversight in planning for multiple indexscans driven byTom Lane
2006-07-01Revise the planner's handling of "pseudoconstant" WHERE clauses, that isTom Lane
2006-06-28Improve planner estimates for size of tuple hash tables.Tom Lane
2006-06-16Fix problems with cached tuple descriptors disappearing while still in useTom Lane
2006-06-07Remove "fuzzy comparison" logic in qsort comparison function forTom Lane
2006-06-06Make the planner estimate costs for nestloop inner indexscans on the basisTom Lane
2006-06-05While making the seq_page_cost changes, I was struck by the fact thatTom Lane
2006-06-05Add a GUC parameter seq_page_cost, and use that everywhere we formerlyTom Lane
2006-05-18Fix choose_bitmap_and() so that partial index predicates are considered whenTom Lane
2006-05-18When a bitmap indexscan is using a partial index, it is necessary to includeTom Lane
2006-05-18Fix thinko in recent changes to handle ScalarArrayOpExpr as an indexableTom Lane
2006-05-03Fix calculation of plan node extParams to account for the possibility that oneTom Lane
2006-05-02Avoid assuming that statistics for a parent relation reflect the properties ofTom Lane
2006-04-30Improve the representation of FOR UPDATE/FOR SHARE so that we canTom Lane
2006-04-28Remove the restriction originally coded into optimize_minmax_aggregates() thatTom Lane
2006-04-25The 8.1 planner removes WHERE quals from the plan when the quals areTom Lane
2006-04-22Simplify ParamListInfo data structure to support only numbered parameters,Tom Lane
2006-04-09Revert my best_inner_indexscan patch of yesterday, which turns out to haveTom Lane
2006-04-08Fix best_inner_indexscan to actually enforce that an "inner indexscan" useTom Lane
2006-04-07Fix make_restrictinfo_from_bitmapqual() to preserve AND/OR flatness of itsTom Lane
2006-04-05Fix a bunch of problems with domains by making them use special input functionsTom Lane