summaryrefslogtreecommitdiff
path: root/src/backend/optimizer
Commit message (Expand)AuthorAgeFilesLines
* Fix extremely nasty little bug observed when a sub-SELECT appears inTom Lane2000-04-044-125/+157
* Tweak indexscan cost estimation: round estimated # of tuples visited upTom Lane2000-03-301-5/+5
* Save a few cycles in simple cases: no need to call cost_sort() when thereTom Lane2000-03-241-8/+8
* A little further tweaking of the range-query selectivity logic:Tom Lane2000-03-231-13/+25
* If we cannot get a real estimate for the selectivity of a range query,Tom Lane2000-03-231-3/+5
* Repair logic flaw in cost estimator: cost_nestloop() was estimating CPUTom Lane2000-03-225-55/+57
* Restructure planning code so that preprocessing of targetlist and qualsTom Lane2000-03-216-156/+182
* Minor code rearrangement & doc improvement in eval_const_expressions().Tom Lane2000-03-191-105/+129
* Fix a bunch of minor portability problems and maybe-bugs revealed byTom Lane2000-03-172-6/+6
* Implement column aliases on views "CREATE VIEW name (collist)".Thomas G. Lockhart2000-03-141-3/+3
* Fix some bogosities in the code that deals with estimating the fractionTom Lane2000-03-143-29/+42
* Fix performance bug in constant-expression simplifier. After findingTom Lane2000-03-121-5/+13
* Further tweaking of logic that decides when to materialize an uncorrelatedTom Lane2000-03-111-24/+15
* Trial implementation of ALTER DROP COLUMN.Hiroshi Inoue2000-03-091-3/+34
* Apply a MATERIAL node to the result of an uncorrelated subplan, if itTom Lane2000-03-021-5/+71
* Avoid a little bit of unnecessary computation in canonicalize_qual.Tom Lane2000-02-271-2/+3
* Tweak planner to use OFFSET+LIMIT, not just LIMIT, as estimate of theTom Lane2000-02-211-16/+32
* Create a new expression node type RelabelType, which exists solely toTom Lane2000-02-201-1/+44
* Plug some more memory leaks in the planner. It still leaks like a sieve,Tom Lane2000-02-185-37/+68
* Implement reindex commandHiroshi Inoue2000-02-181-2/+7
* Finish repairing 6.5's problems with r-tree indexes: create appropriateTom Lane2000-02-171-18/+19
* Remove long-dead code.Tom Lane2000-02-151-191/+0
* New cost model for planning, incorporating a penalty for random pageTom Lane2000-02-1519-1195/+2023
* Carry column aliases from the parser frontend. Enables queries likeThomas G. Lockhart2000-02-152-6/+6
* Repair planning bugs caused by my misguided removal of restrictinfo linkTom Lane2000-02-0715-957/+1077
* Rename same() to sameseti() to have a slightly less generic name. MoveTom Lane2000-02-065-57/+17
* Further cleanup for OR-of-AND WHERE-clauses. orindxpath can now handleTom Lane2000-02-052-54/+90
* Make EXPLAIN results for Append, Group, Agg, Unique nodes more plausible.Tom Lane2000-02-032-35/+59
* Apply the heuristic proposed by Taral (see pgsql-general archives forTom Lane2000-01-281-53/+106
* Redesign DISTINCT ON as discussed in pgsql-sql 1/25/00: syntax is nowTom Lane2000-01-275-47/+77
* Add:Bruce Momjian2000-01-2639-77/+116
* First cut at making useful selectivity estimates for range queriesTom Lane2000-01-241-10/+235
* First cut at unifying regular selectivity estimation with indexscanTom Lane2000-01-233-62/+118
* Revise handling of index-type-specific indexscan cost estimation, perTom Lane2000-01-229-382/+115
* Fixed all elog related warnings, as well as a few others.Peter Eisentraut2000-01-152-6/+6
* Put back erroneously removed zeroing of sentinel elementsTom Lane2000-01-121-1/+3
* More cleanups. Still doesn't work.Bruce Momjian2000-01-111-3/+1
* Another round of planner/optimizer work. This is just restructuring andTom Lane2000-01-0918-1217/+915
* Generate double-sided LIKE indexquals that work even in weird locales,Tom Lane1999-12-311-45/+163
* Clean up loose end in LIKE optimization fix: parser's code would generateTom Lane1999-12-311-54/+115
* fix_parsetree_attnums was not nearly smart enough about walking parseTom Lane1999-12-141-128/+149
* New LDOUT makefile variable for QNX os.Bruce Momjian1999-12-136-12/+12
* aggregate(DISTINCT ...) works, per SQL spec.Tom Lane1999-12-131-3/+35
* Make LD -r as macros that can be changed for QNX.Bruce Momjian1999-12-096-12/+12
* Replace generic 'Illegal use of aggregates' error message with one thatTom Lane1999-12-093-23/+53
* Tid access method feature from Hiroshi Inoue, Inoue@tpf.co.jpBruce Momjian1999-11-238-9/+442
* Add system indexes to match all caches.Bruce Momjian1999-11-224-14/+14
* Combine index_info and find_secondary_indexes into a single routine thatTom Lane1999-11-212-187/+109
* Implement subselects in target lists. Also, relax requirement thatTom Lane1999-11-153-74/+88
* New NameStr macro to convert Name to Str. No need for var.data anymore.Bruce Momjian1999-11-071-2/+2