Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1rTYuV-004BcK-GY for pgsql-hackers@arkaria.postgresql.org; Sat, 27 Jan 2024 02:59:12 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1rTYuU-003tyO-N5 for pgsql-hackers@arkaria.postgresql.org; Sat, 27 Jan 2024 02:59:10 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1rTYuU-003tyF-DV for pgsql-hackers@lists.postgresql.org; Sat, 27 Jan 2024 02:59:10 +0000 Received: from mail-yw1-x112f.google.com ([2607:f8b0:4864:20::112f]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1rTYuR-003vLc-KQ for pgsql-hackers@postgresql.org; Sat, 27 Jan 2024 02:59:09 +0000 Received: by mail-yw1-x112f.google.com with SMTP id 00721157ae682-602a0a45dd6so9101117b3.1 for ; Fri, 26 Jan 2024 18:59:07 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1706324346; x=1706929146; darn=postgresql.org; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:from:to:cc:subject:date:message-id:reply-to; bh=Qn+CI2EUJ1K+y39LwU6PKCylKCVbjND+T+yn8v4O+gc=; b=fZmUuM3iX7Mm1KNtwbIsqzJtRxxnV02wdGl4IvZJBgmMYcdG8N6DmFByVfJlN3jKs5 YqKfH4pIUfcGUsYlL7IRRnMdmxXX2wXvmIW2WoTH+wR1a6ZVHzW4NjVThgzkUBRQtHma 7EO8BOdxbmjdEU8+nxW+W0hlZBmocpGmnjyVDTf/MMg4wDMX7BUwSB5u639D1JFg//cv vbxBg7G4h60+dXjYbmwm8lkZmDSq+8Le81mHDCDSIS8HV+oy347Us5G6YvQCeRHMYtKS j8ZxSdWiielwOtmb1saPWn7Xc0EjlPUgAn0kYKJVOpPgY7ct5hm2K48chVI+qrO17YEM nfjA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1706324346; x=1706929146; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:x-gm-message-state:from:to:cc:subject:date:message-id :reply-to; bh=Qn+CI2EUJ1K+y39LwU6PKCylKCVbjND+T+yn8v4O+gc=; b=lEvEwu4mv2gv/Z0lWzkHKkKMdw8cUZkkgFhkHklmGUyx3QKVgYAaRfMfcZehY6MhUj DKG332Fswcy7h5kKd70K04e3pvDEZuJ6/Fcq0sw93I/5qNd721uUQa2fAZTcpbI9r8/6 LYrPcpVzO3ikMyMvNj5+KAWCinFrFEUZfVQYUivNn6DzVtMjdfgCwf/cECDaDeLhlXOQ EvUSHhDrTJ32bTjNW6QsFQcYLN/ezaGs5+7FPLphh3S/ztMzyLe8Yb9a+uI9U/zU9oiP GXgP+OqTbU7YGN8rGB+b+gdThgZCIKVyopaU1OWXJ4VloBSC0+Hu9uCJGcKZ1ckAe3v1 GXNw== X-Gm-Message-State: AOJu0Yyqx3stjOL74lNZio7wEGVrzWrgAO1tBoJBhmrpEOaL6yMvRFE3 qCdKcWPp4Q3ynUlOzAIzyG98itqiyyZ/LxJEd2bAL1hBtheVuksTQQIgj/xu36biD6wV9Z4MEmW 9oqV7zoGnoDKu76kqEs71AKszsus= X-Google-Smtp-Source: AGHT+IGtm9yzzauL/ndyWdrE5kQOpgdHdlt9fi3H2xexKm0hpPfuxOrxkiYVMIlp16vRMHNx9HOggcN7EQ0QEKHordY= X-Received: by 2002:a81:ac67:0:b0:5ff:9903:8346 with SMTP id z39-20020a81ac67000000b005ff99038346mr786146ywj.89.1706324345816; Fri, 26 Jan 2024 18:59:05 -0800 (PST) MIME-Version: 1.0 References: <567ED6CA.2040504@sigaev.ru> <16a7e3aa-24c0-4986-8820-ea2857bd7b6b@postgrespro.ru> <421656a9-5df7-41bb-9d58-1c1edbd5dc3e@postgrespro.ru> <28c727ba-5260-42a8-88b0-4ecdeeca6ef8@postgrespro.ru> <4c1c2c0b-802f-45ae-a7cd-007bfd8957cf@postgrespro.ru> <52f0d302-7963-452f-8c5a-f66d261514eb@postgrespro.ru> <43ad8a48-b980-410d-a83c-5beebf82a4ed@postgrespro.ru> <04ef16eb-46c1-4ce7-9f68-d1c80ef0be81@postgrespro.ru> <59e67a40-95a8-4d74-ae4e-027ea0f59084@postgrespro.ru> <59b77a8a-29d6-4727-bf26-4a30a6a9719a@postgrespro.ru> <32d23d97-d07f-4d44-9933-ba3295fb3ed8@postgrespro.ru> In-Reply-To: From: vignesh C Date: Sat, 27 Jan 2024 08:28:53 +0530 Message-ID: Subject: Re: POC, WIP: OR-clause support for indexes To: Andrei Lepikhov Cc: Alena Rybakina , Robert Haas , pgsql-hackers@postgresql.org, Alexander Korotkov , Peter Geoghegan , "Finnerty, Jim" , Marcos Pegoraro , teodor@sigaev.ru, Ranier Vilela , Tomas Vondra , Peter Eisentraut Content-Type: text/plain; charset="UTF-8" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Tue, 5 Dec 2023 at 16:25, Andrei Lepikhov wrote: > > Here is fresh version with the pg_dump.pl regex fixed. Now it must pass > buildfarm. > > Under development: > 1. Explanation of the general idea in comments (Robert's note) > 2. Issue with hiding some optimizations (Alexander's note and example > with overlapping clauses on two partial indexes) CFBot shows that the patch does not apply anymore as in [1]: === Applying patches on top of PostgreSQL commit ID 64444ce071f6b04d3fc836f436fa08108a6d11e2 === === applying patch ./v14-1-0001-Transform-OR-clause-to-ANY-expressions.patch .... patching file src/test/regress/expected/sysviews.out Hunk #1 succeeded at 124 (offset 1 line). Hunk #2 FAILED at 134. 1 out of 2 hunks FAILED -- saving rejects to file src/test/regress/expected/sysviews.out.rej Please post an updated version for the same. [1] - http://cfbot.cputube.org/patch_46_4450.log Regards, Vignesh