From ff9f72c68f678ded340b431c3e280fe56644a3e7 Mon Sep 17 00:00:00 2001 From: Alexander Korotkov Date: Wed, 10 Apr 2024 02:07:34 +0300 Subject: 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 --- src/backend/utils/misc/guc_tables.c | 12 ------------ 1 file changed, 12 deletions(-) (limited to 'src/backend/utils/misc/guc_tables.c') 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 -- cgit v1.2.3