summaryrefslogtreecommitdiff
path: root/src/backend/optimizer
AgeCommit message (Expand)Author
2000-03-17Fix a bunch of minor portability problems and maybe-bugs revealed byTom Lane
2000-03-14Implement column aliases on views "CREATE VIEW name (collist)".Thomas G. Lockhart
2000-03-14Fix some bogosities in the code that deals with estimating the fractionTom Lane
2000-03-12Fix performance bug in constant-expression simplifier. After findingTom Lane
2000-03-11Further tweaking of logic that decides when to materialize an uncorrelatedTom Lane
2000-03-09Trial implementation of ALTER DROP COLUMN.Hiroshi Inoue
2000-03-02Apply a MATERIAL node to the result of an uncorrelated subplan, if itTom Lane
2000-02-27Avoid a little bit of unnecessary computation in canonicalize_qual.Tom Lane
2000-02-21Tweak planner to use OFFSET+LIMIT, not just LIMIT, as estimate of theTom Lane
2000-02-20Create a new expression node type RelabelType, which exists solely toTom Lane
2000-02-18Plug some more memory leaks in the planner. It still leaks like a sieve,Tom Lane
2000-02-18Implement reindex commandHiroshi Inoue
2000-02-17Finish repairing 6.5's problems with r-tree indexes: create appropriateTom Lane
2000-02-15Remove long-dead code.Tom Lane
2000-02-15New cost model for planning, incorporating a penalty for random pageTom Lane
2000-02-15Carry column aliases from the parser frontend. Enables queries likeThomas G. Lockhart
2000-02-07Repair planning bugs caused by my misguided removal of restrictinfo linkTom Lane
2000-02-06Rename same() to sameseti() to have a slightly less generic name. MoveTom Lane
2000-02-05Further cleanup for OR-of-AND WHERE-clauses. orindxpath can now handleTom Lane
2000-02-03Make EXPLAIN results for Append, Group, Agg, Unique nodes more plausible.Tom Lane
2000-01-28Apply the heuristic proposed by Taral (see pgsql-general archives forTom Lane
2000-01-27Redesign DISTINCT ON as discussed in pgsql-sql 1/25/00: syntax is nowTom Lane
2000-01-26Add:Bruce Momjian
2000-01-24First cut at making useful selectivity estimates for range queriesTom Lane
2000-01-23First cut at unifying regular selectivity estimation with indexscanTom Lane
2000-01-22Revise handling of index-type-specific indexscan cost estimation, perTom Lane
2000-01-15Fixed all elog related warnings, as well as a few others.Peter Eisentraut
2000-01-12Put back erroneously removed zeroing of sentinel elementsTom Lane
2000-01-11More cleanups. Still doesn't work.Bruce Momjian
2000-01-09Another round of planner/optimizer work. This is just restructuring andTom Lane
1999-12-31Generate double-sided LIKE indexquals that work even in weird locales,Tom Lane
1999-12-31Clean up loose end in LIKE optimization fix: parser's code would generateTom Lane
1999-12-14fix_parsetree_attnums was not nearly smart enough about walking parseTom Lane
1999-12-13New LDOUT makefile variable for QNX os.Bruce Momjian
1999-12-13aggregate(DISTINCT ...) works, per SQL spec.Tom Lane
1999-12-09Make LD -r as macros that can be changed for QNX.Bruce Momjian
1999-12-09Replace generic 'Illegal use of aggregates' error message with one thatTom Lane
1999-11-23Tid access method feature from Hiroshi Inoue, Inoue@tpf.co.jpBruce Momjian
1999-11-22Add system indexes to match all caches.Bruce Momjian
1999-11-21Combine index_info and find_secondary_indexes into a single routine thatTom Lane
1999-11-15Implement subselects in target lists. Also, relax requirement thatTom Lane
1999-11-07New NameStr macro to convert Name to Str. No need for var.data anymore.Bruce Momjian
1999-10-30Skip invoking set_uppernode_references() for a RESULT nodeTom Lane
1999-10-30Rewrite preprocess_targetlist() to reduce overhead for simple INSERTs.Tom Lane
1999-10-07Fix planner and rewriter to follow SQL semantics for tables that areTom Lane
1999-10-02Fix make_clause and make_opclause to record valid type infoTom Lane
1999-09-26Implement constant-expression simplification per BernardTom Lane
1999-09-21values.h patch from Alex HowanskyBruce Momjian
1999-09-18Mega-commit to make heap_open/heap_openr/heap_close take anTom Lane
1999-09-13First cut at doing something reasonable with OR-of-ANDs WHERETom Lane