summaryrefslogtreecommitdiff
path: root/src/include/optimizer
AgeCommit message (Expand)Author
2007-09-26Create a function variable "join_search_hook" to let plugins override theTom Lane
2007-09-22Fix cost estimates for EXISTS subqueries that are evaluated as initPlansTom Lane
2007-09-20HOT updates. When we update a tuple without changing any of its indexedTom Lane
2007-07-25Rename DLLIMPORT macro to PGDLLIMPORT to avoid conflict withMagnus Hagander
2007-05-25Create hooks to let a loadable plugin monitor (or even replace) the plannerTom Lane
2007-05-22Fix best_inner_indexscan to return both the cheapest-total-cost andTom Lane
2007-05-21Teach tuplestore.c to throw away data before the "mark" point when the callerTom Lane
2007-05-04Teach tuplesort.c about "top N" sorting, in which only the first N tuplesTom Lane
2007-04-16Expose more cursor-related functionality in SPI: specifically, allowTom Lane
2007-04-15Avoid running build_index_pathkeys() in situations where there cannotTom Lane
2007-02-22Turn the rangetable used by the executor into a flat list, and avoid storingTom Lane
2007-02-20Remove the Query structure from the executor's API. This allows us to stopTom Lane
2007-02-19Get rid of some old and crufty global variables in the planner. WhenTom Lane
2007-02-16Restructure code that is responsible for ensuring that clauseless joins areTom Lane
2007-01-22Add COST and ROWS options to CREATE/ALTER FUNCTION, plus underlying pg_procTom Lane
2007-01-20Refactor planner's pathkeys data structure to create a separate, explicitTom Lane
2007-01-10Change the planner-to-executor API so that the planner tells the executorTom Lane
2007-01-05Update CVS HEAD for 2007 copyright. Back branches are typically notBruce Momjian
2006-12-23Restructure operator classes to allow improved handling of cross-data-typeTom 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