diff options
Diffstat (limited to 'src/backend/utils')
| -rw-r--r-- | src/backend/utils/misc/guc_tables.c | 12 | ||||
| -rw-r--r-- | src/backend/utils/misc/postgresql.conf.sample | 1 |
2 files changed, 13 insertions, 0 deletions
diff --git a/src/backend/utils/misc/guc_tables.c b/src/backend/utils/misc/guc_tables.c index 7d4e4387cf5..f9bb2b0f9e5 100644 --- a/src/backend/utils/misc/guc_tables.c +++ b/src/backend/utils/misc/guc_tables.c @@ -3657,6 +3657,18 @@ struct config_int ConfigureNamesInt[] = NULL, NULL, NULL }, + { + {"or_to_any_transform_limit", PGC_USERSET, QUERY_TUNING_OTHER, + gettext_noop("Set the minimum length of the list of OR clauses to attempt the OR-to-ANY transformation."), + gettext_noop("Once the limit is reached, the planner will try to replace expression like " + "'x=c1 OR x=c2 ..' to the expression 'x = ANY(ARRAY[c1,c2,..])'"), + GUC_EXPLAIN + }, + &or_to_any_transform_limit, + 5, -1, INT_MAX, + NULL, NULL, NULL + }, + /* End-of-list marker */ { {NULL, 0, 0, NULL, NULL}, NULL, 0, 0, 0, NULL, NULL, NULL diff --git a/src/backend/utils/misc/postgresql.conf.sample b/src/backend/utils/misc/postgresql.conf.sample index 2166ea4a87a..15b14ba8507 100644 --- a/src/backend/utils/misc/postgresql.conf.sample +++ b/src/backend/utils/misc/postgresql.conf.sample @@ -392,6 +392,7 @@ # - Planner Method Configuration - #enable_async_append = on +#or_to_any_transform_limit = 0 #enable_bitmapscan = on #enable_gathermerge = on #enable_hashagg = on |