summaryrefslogtreecommitdiff
path: root/src/backend/optimizer
AgeCommit message (Expand)Author
2003-07-16Add defenses against trying to attach qual conditions to a setOperationTom Lane
2003-07-14Make cost estimates for SubqueryScan more realistic: charge cpu_tuple_costTom Lane
2003-07-03Do honest transformation and preprocessing of LIMIT/OFFSET clauses,Tom Lane
2003-07-03Code review for UPDATE tab SET col = DEFAULT patch ... whack it aroundTom Lane
2003-07-01Dept. of second thoughts: supporting inlining of polymorphic SQL functionsTom Lane
2003-07-01SQL functions can have arguments and results declared ANYARRAY orTom Lane
2003-06-29Restructure building of join relation targetlists so that a join planTom Lane
2003-06-29Support expressions of the form 'scalar op ANY (array)' andTom Lane
2003-06-25Back out array mega-patch.Bruce Momjian
2003-06-24Array mega-patch.Bruce Momjian
2003-06-16Allow GROUP BY, ORDER BY, DISTINCT targets to be unknown literals,Tom Lane
2003-06-15Adjust nestloop-with-inner-indexscan plan generation so that we catchTom Lane
2003-06-06Implement outer-level aggregates to conform to the SQL spec, withTom Lane
2003-05-28Knock down a couple more lappend() hotspots for large WHERE clauses.Tom Lane
2003-05-28Fix some planner performance problems with large WHERE clauses, byTom Lane
2003-05-28Replace functional-index facility with expressional indexes. Any columnTom Lane
2003-05-27Make debug_ GUC varables output DEBUG1 rather than LOG, and mention inBruce Momjian
2003-05-26Cause CHAR(n) to TEXT or VARCHAR conversion to automatically strip trailingTom Lane
2003-05-15Add missing #include.Tom Lane
2003-05-15Indexing support for pattern matching operations via separate operatorPeter Eisentraut
2003-05-13Change pg_amop's index on (amopclaid,amopopr) to index (amopopr,amopclaid).Tom Lane
2003-05-12Apply fixes for problems with dropped columns whose types have also beenTom Lane
2003-05-11Revert previous change --- turns out the underlying problem affectsTom Lane
2003-05-11Disable the recently-added use_physical_tlist optimization in casesTom Lane
2003-05-06Implement feature of new FE/BE protocol whereby RowDescription identifiesTom Lane
2003-05-02Portal and memory management infrastructure for extended query protocol.Tom Lane
2003-05-02Repair sloppiness about where cached mergeclause pathkeys are allocated.Tom Lane
2003-04-29Infrastructure for deducing Param types from context, in the same wayTom Lane
2003-04-27Put back encoding-conversion step in processing of incoming queries;Tom Lane
2003-04-24Adjust subquery qual pushdown rules so that we can push down a qualTom Lane
2003-04-08First phase of work on array improvements. ARRAY[x,y,z] constructorTom Lane
2003-03-23Tweak selectivity and related routines to cope with domains. Per reportTom Lane
2003-03-22Department of second thoughts: probably shouldn't use nth() to get theTom Lane
2003-03-22Adjust subquery qual pushdown rules to be more forgiving: if a qualTom Lane
2003-03-14Make eval_const_expressions simplify FieldSelect from a whole-row VarTom Lane
2003-03-13GROUP BY got confused if there were multiple equal() GROUP BY items.Tom Lane
2003-03-10Restructure parsetree representation of DECLARE CURSOR: now it's aTom Lane
2003-03-05Turns out new IN implementation has got some problems in an UPDATE orTom Lane
2003-03-05Repair bug reported by Laurent Perez: bad plan generated when UPDATE orTom Lane
2003-03-02Be smart about outer-join qualifications that mention only one side ofTom Lane
2003-02-16Back off previous patch to skip projection step in scan plan nodes,Tom Lane
2003-02-16COALESCE() and NULLIF() are now first-class expressions, not macrosTom Lane
2003-02-15Marginal tweaks to make sure that roundoff error won't cause us to makeTom Lane
2003-02-15Teach planner how to propagate pathkeys from sub-SELECTs in FROM up toTom Lane
2003-02-10Fix thinko in new logic about pushing down non-nullability constraints:Tom Lane
2003-02-09Detect case where an outer join can be reduced to a plain inner joinTom Lane
2003-02-09Create a distinction between Lists of integers and Lists of OIDs, to getTom Lane
2003-02-09Remove bogus comment (too freely copied & pasted).Tom Lane
2003-02-09Make further use of new bitmapset code: executor's chgParam, extParam,Tom Lane
2003-02-08Replace planner's representation of relation sets, per pghackers discussion.Tom Lane