diff options
Diffstat (limited to 'src/backend')
| -rw-r--r-- | src/backend/optimizer/path/allpaths.c | 6 | ||||
| -rw-r--r-- | src/backend/utils/misc/guc.c | 13 | ||||
| -rw-r--r-- | src/backend/utils/misc/postgresql.conf.sample | 2 |
3 files changed, 10 insertions, 11 deletions
diff --git a/src/backend/optimizer/path/allpaths.c b/src/backend/optimizer/path/allpaths.c index 124534914f8..aa14deacd0c 100644 --- a/src/backend/optimizer/path/allpaths.c +++ b/src/backend/optimizer/path/allpaths.c @@ -8,7 +8,7 @@ * * * IDENTIFICATION - * $PostgreSQL: pgsql/src/backend/optimizer/path/allpaths.c,v 1.135 2005/07/23 21:05:46 tgl Exp $ + * $PostgreSQL: pgsql/src/backend/optimizer/path/allpaths.c,v 1.136 2005/08/22 17:34:58 momjian Exp $ * *------------------------------------------------------------------------- */ @@ -36,7 +36,7 @@ /* These parameters are set by GUC */ -bool enable_constraint_exclusion = false; +bool constraint_exclusion = false; bool enable_geqo = false; /* just in case GUC doesn't set it */ int geqo_threshold; @@ -318,7 +318,7 @@ set_inherited_rel_pathlist(PlannerInfo *root, RelOptInfo *rel, * exclusion, just ignore it. (We have to have converted the * baserestrictinfo Vars before we can make the test.) */ - if (enable_constraint_exclusion) + if (constraint_exclusion) { List *constraint_pred; diff --git a/src/backend/utils/misc/guc.c b/src/backend/utils/misc/guc.c index 6fd3d9fc5c4..29e0e409307 100644 --- a/src/backend/utils/misc/guc.c +++ b/src/backend/utils/misc/guc.c @@ -10,7 +10,7 @@ * Written by Peter Eisentraut <peter_e@gmx.net>. * * IDENTIFICATION - * $PostgreSQL: pgsql/src/backend/utils/misc/guc.c,v 1.285 2005/08/21 03:39:34 tgl Exp $ + * $PostgreSQL: pgsql/src/backend/utils/misc/guc.c,v 1.286 2005/08/22 17:34:59 momjian Exp $ * *-------------------------------------------------------------------- */ @@ -453,13 +453,12 @@ static struct config_bool ConfigureNamesBool[] = true, NULL, NULL }, { - {"enable_constraint_exclusion", PGC_USERSET, QUERY_TUNING_OTHER, - gettext_noop("Enables the planner's use of constraints in queries."), - gettext_noop("Constraints will be examined to exclude tables " - "that can be proven not to be required to produce " - "a correct result for the query.") + {"constraint_exclusion", PGC_USERSET, QUERY_TUNING_OTHER, + gettext_noop("Enables the planner to use constraints to limit table access."), + gettext_noop("This prevents table access if the table constraints " + "guarantee that table access is necessary.") }, - &enable_constraint_exclusion, + &constraint_exclusion, false, NULL, NULL }, { diff --git a/src/backend/utils/misc/postgresql.conf.sample b/src/backend/utils/misc/postgresql.conf.sample index 48152e8ed26..6049aafe191 100644 --- a/src/backend/utils/misc/postgresql.conf.sample +++ b/src/backend/utils/misc/postgresql.conf.sample @@ -190,7 +190,7 @@ # - Other Planner Options - #default_statistics_target = 10 # range 1-1000 -#enable_constraint_exclusion = off +#constraint_exclusion = off #from_collapse_limit = 8 #join_collapse_limit = 8 # 1 disables collapsing of explicit # JOINs |