diff options
| author | Alexander Korotkov | 2024-04-09 23:07:34 +0000 |
|---|---|---|
| committer | Alexander Korotkov | 2024-04-09 23:28:09 +0000 |
| commit | ff9f72c68f678ded340b431c3e280fe56644a3e7 (patch) | |
| tree | 8e6e8e211c2451709c2efb76a49d7146cb899d58 /src/backend/utils | |
| parent | 5a15bdea3b791223b4cc708d4953a0086f4332a6 (diff) | |
revert: Transform OR clauses to ANY expression
This commit reverts 72bd38cc99 due to implementation and design issues.
Reported-by: Tom Lane
Discussion: https://postgr.es/m/3604469.1712628736%40sss.pgh.pa.us
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, 0 insertions, 13 deletions
diff --git a/src/backend/utils/misc/guc_tables.c b/src/backend/utils/misc/guc_tables.c index 72ee913dddd..c68fdc008b6 100644 --- a/src/backend/utils/misc/guc_tables.c +++ b/src/backend/utils/misc/guc_tables.c @@ -3668,18 +3668,6 @@ struct config_int ConfigureNamesInt[] = NULL, NULL, NULL }, - { - {"or_to_any_transform_limit", PGC_USERSET, QUERY_TUNING_OTHER, - gettext_noop("Sets 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 2bfd255108e..2166ea4a87a 100644 --- a/src/backend/utils/misc/postgresql.conf.sample +++ b/src/backend/utils/misc/postgresql.conf.sample @@ -392,7 +392,6 @@ # - Planner Method Configuration - #enable_async_append = on -#or_to_any_transform_limit = 5 #enable_bitmapscan = on #enable_gathermerge = on #enable_hashagg = on |