X-Git-Url: https://granicus.if.org/sourcecode?a=blobdiff_plain;f=src%2Finclude%2Foptimizer%2Fplanmain.h;h=0b46a173706bfacae48a97bf683b38882c0451c8;hb=db147b348345288c7b47f9527fc107a9bb063ad7;hp=37209dfd5c37a2a2857fda28d6101b2855f0be65;hpb=ea08e6cd5542cb269ecd3e735f1dfa3bb61fbc4f;p=postgresql diff --git a/src/include/optimizer/planmain.h b/src/include/optimizer/planmain.h index 37209dfd5c..0b46a17370 100644 --- a/src/include/optimizer/planmain.h +++ b/src/include/optimizer/planmain.h @@ -4,10 +4,10 @@ * prototypes for various files in optimizer/plan * * - * Portions Copyright (c) 1996-2001, PostgreSQL Global Development Group + * Portions Copyright (c) 1996-2008, PostgreSQL Global Development Group * Portions Copyright (c) 1994, Regents of the University of California * - * $Id: planmain.h,v 1.54 2001/11/05 17:46:34 momjian Exp $ + * $PostgreSQL: pgsql/src/include/optimizer/planmain.h,v 1.108 2008/05/02 21:26:10 tgl Exp $ * *------------------------------------------------------------------------- */ @@ -17,55 +17,94 @@ #include "nodes/plannodes.h" #include "nodes/relation.h" +/* GUC parameters */ +#define DEFAULT_CURSOR_TUPLE_FRACTION 0.1 +extern double cursor_tuple_fraction; + /* * prototypes for plan/planmain.c */ -extern Plan *query_planner(Query *root, List *tlist, double tuple_fraction); +extern void query_planner(PlannerInfo *root, List *tlist, + double tuple_fraction, double limit_tuples, + Path **cheapest_path, Path **sorted_path, + double *num_groups); + +/* + * prototypes for plan/planagg.c + */ +extern Plan *optimize_minmax_aggregates(PlannerInfo *root, List *tlist, + Path *best_path); /* * prototypes for plan/createplan.c */ -extern Plan *create_plan(Query *root, Path *best_path); +extern Plan *create_plan(PlannerInfo *root, Path *best_path); extern SubqueryScan *make_subqueryscan(List *qptlist, List *qpqual, - Index scanrelid, Plan *subplan); + Index scanrelid, Plan *subplan, List *subrtable); extern Append *make_append(List *appendplans, bool isTarget, List *tlist); -extern Sort *make_sort(Query *root, List *tlist, - Plan *lefttree, int keycount); -extern Sort *make_sort_from_pathkeys(Query *root, List *tlist, - Plan *lefttree, List *pathkeys); -extern Agg *make_agg(List *tlist, List *qual, Plan *lefttree); -extern Group *make_group(List *tlist, bool tuplePerGroup, int ngrp, - AttrNumber *grpColIdx, Plan *lefttree); -extern Material *make_material(List *tlist, Plan *lefttree); -extern Unique *make_unique(List *tlist, Plan *lefttree, List *distinctList); -extern Limit *make_limit(List *tlist, Plan *lefttree, - Node *limitOffset, Node *limitCount); -extern SetOp *make_setop(SetOpCmd cmd, List *tlist, Plan *lefttree, +extern Sort *make_sort_from_pathkeys(PlannerInfo *root, Plan *lefttree, + List *pathkeys, double limit_tuples); +extern Sort *make_sort_from_sortclauses(PlannerInfo *root, List *sortcls, + Plan *lefttree); +extern Sort *make_sort_from_groupcols(PlannerInfo *root, List *groupcls, + AttrNumber *grpColIdx, Plan *lefttree); +extern Agg *make_agg(PlannerInfo *root, List *tlist, List *qual, + AggStrategy aggstrategy, + int numGroupCols, AttrNumber *grpColIdx, Oid *grpOperators, + long numGroups, int numAggs, + Plan *lefttree); +extern Group *make_group(PlannerInfo *root, List *tlist, List *qual, + int numGroupCols, AttrNumber *grpColIdx, Oid *grpOperators, + double numGroups, + Plan *lefttree); +extern Plan *materialize_finished_plan(Plan *subplan); +extern Unique *make_unique(Plan *lefttree, List *distinctList); +extern Limit *make_limit(Plan *lefttree, Node *limitOffset, Node *limitCount, + int64 offset_est, int64 count_est); +extern SetOp *make_setop(SetOpCmd cmd, Plan *lefttree, List *distinctList, AttrNumber flagColIdx); -extern Result *make_result(List *tlist, Node *resconstantqual, Plan *subplan); +extern Result *make_result(PlannerInfo *root, List *tlist, + Node *resconstantqual, Plan *subplan); +extern bool is_projection_capable_plan(Plan *plan); /* * prototypes for plan/initsplan.c */ -extern void build_base_rel_tlists(Query *root, List *tlist); -extern Relids distribute_quals_to_rels(Query *root, Node *jtnode); -extern List *add_missing_rels_to_query(Query *root, Node *jtnode); -extern void process_implied_equality(Query *root, Node *item1, Node *item2, - Oid sortop1, Oid sortop2); +extern int from_collapse_limit; +extern int join_collapse_limit; -/* - * prototypes for plan/setrefs.c - */ -extern void set_plan_references(Plan *plan); -extern List *join_references(List *clauses, List *outer_tlist, - List *inner_tlist, Index acceptable_rel); -extern void fix_opids(Node *node); +extern void add_base_rels_to_query(PlannerInfo *root, Node *jtnode); +extern void build_base_rel_tlists(PlannerInfo *root, List *final_tlist); +extern void add_IN_vars_to_tlists(PlannerInfo *root); +extern void add_vars_to_targetlist(PlannerInfo *root, List *vars, + Relids where_needed); +extern List *deconstruct_jointree(PlannerInfo *root); +extern void distribute_restrictinfo_to_rels(PlannerInfo *root, + RestrictInfo *restrictinfo); +extern void process_implied_equality(PlannerInfo *root, + Oid opno, + Expr *item1, + Expr *item2, + Relids qualscope, + bool below_outer_join, + bool both_const); +extern RestrictInfo *build_implied_join_equality(Oid opno, + Expr *item1, + Expr *item2, + Relids qualscope); /* - * prep/prepkeyset.c + * prototypes for plan/setrefs.c */ -extern bool _use_keyset_query_optimizer; - -extern void transformKeySetQuery(Query *origNode); +extern Plan *set_plan_references(PlannerGlobal *glob, + Plan *plan, + List *rtable); +extern List *set_returning_clause_references(PlannerGlobal *glob, + List *rlist, + Plan *topplan, + Index resultRelation); +extern void fix_opfuncids(Node *node); +extern void set_opfuncid(OpExpr *opexpr); +extern void set_sa_opfuncid(ScalarArrayOpExpr *opexpr); #endif /* PLANMAIN_H */