Replace a large number of OR clauses with ANY expression

Edit
Title Replace a large number of OR clauses with ANY expression
Topic Performance
Created 2023-07-18 14:09:00
Last modified 2023-11-24 03:17:21 (1 week ago)
Latest email 2023-11-30 10:57:26 (16 hours, 56 minutes ago)
Status
2023-11: Needs review
2023-09: Moved to next CF
Target version 17
Authors Andrei Lepikhov (lepikhov), Alena Rybakina (alenka)
Reviewers Ranier Vilela (raniervilela)Become reviewer
Committer
Links
Emails
POC, WIP: OR-clause support for indexes
First at 2015-12-26 18:04:58 by Teodor Sigaev <teodor at sigaev.ru>
Latest at 2023-11-30 10:57:26 by Alena Rybakina <a.rybakina at postgrespro.ru>
Latest attachment (v14-0001-Transform-OR-clause-to ANY-expressions.patch) at 2023-11-30 10:57:26 from Alena Rybakina <a.rybakina at postgrespro.ru>
    Attachment (v14-0001-Transform-OR-clause-to ANY-expressions.patch) at 2023-11-30 10:57:26 from Alena Rybakina <a.rybakina at postgrespro.ru> (Patch: Yes)
    Attachment (0001-OR-to-ANY-in-parser-and-ANY-to-OR-in-index.diff) at 2023-11-30 08:05:31 from Alena Rybakina <a.rybakina at postgrespro.ru> (Patch: Yes)
    Attachment (v13-0001-Transform-OR-clause-to-ANY-expressions.patch) at 2023-11-28 11:46:51 from Andrei Lepikhov <a.lepikhov at postgrespro.ru> (Patch: Yes)
    Attachment (cause_problem.diff.txt) at 2023-11-28 03:52:20 from Alena Rybakina <a.rybakina at postgrespro.ru> (Patch: Yes)
    Attachment (v12-0001-Transform-OR-clause-to-ANY-expressions.patch) at 2023-11-27 08:02:09 from Andrei Lepikhov <a.lepikhov at postgrespro.ru> (Patch: Yes)
    Attachment (v11-1-0001-Transform-OR-clause-to-ANY-expressions.patch) at 2023-11-24 03:30:39 from Andrei Lepikhov <a.lepikhov at postgrespro.ru> (Patch: Yes)
    Attachment (v11-0001-Transform-OR-clause-to-ANY-expressions.patch) at 2023-11-23 09:23:20 from Andrei Lepikhov <a.lepikhov at postgrespro.ru> (Patch: Yes)
    Attachment (v10-0001-PATCH-Replace-OR-clause-to-ANY-expressions.-Replace-.patch) at 2023-11-21 11:31:11 from Alena Rybakina <a.rybakina at postgrespro.ru> (Patch: Yes)
    Attachment (v9-0001-PATCH-Replace-OR-clause-to-ANY-expressions.patch) at 2023-11-21 00:50:15 from Alena Rybakina <a.rybakina at postgrespro.ru> (Patch: Yes)
    Attachment (changes.txt) at 2023-11-20 08:52:08 from Andrei Lepikhov <a.lepikhov at postgrespro.ru> (Patch: Yes)
    Attachment (v9-Replace-OR-clause-to-ANY-expressions.patch) at 2023-11-13 19:48:23 from "a.rybakina" <a.rybakina at postgrespro.ru> (Patch: Yes)
    Attachment (or_patch_changes.diff) at 2023-11-10 09:20:57 from Alena Rybakina <a.rybakina at postgrespro.ru> (Patch: Yes)
    Attachment (v8.1-Replace-OR-clause-to-ANY-expressions.patch) at 2023-11-06 13:51:45 from Alena Rybakina <a.rybakina at postgrespro.ru> (Patch: Yes)
    Attachment (v8.0-Replace-OR-clause-to-ANY-expressions.-Replace-X-N1-O.patch) at 2023-10-25 11:04:24 from "a.rybakina" <a.rybakina at postgrespro.ru> (Patch: Yes)
    Attachment (0001-Replace-OR-clause-to-ANY-expressions.diff) at 2023-10-04 19:19:59 from "a.rybakina" <a.rybakina at postgrespro.ru> (Patch: Yes)
    Attachment (experimantal_version.diff) at 2023-09-29 17:35:13 from "a.rybakina" <a.rybakina at postgrespro.ru> (Patch: Yes)
    Attachment (flamegraph1.png) at 2023-09-26 09:21:10 from "a.rybakina" <a.rybakina at postgrespro.ru> (Patch: No)
    Attachment (flamegraph1.png) at 2023-09-26 09:13:29 from "a.rybakina" <a.rybakina at postgrespro.ru> (Patch: No)
    Attachment (v7-v0-Replace-OR-clause-to-ANY.patch) at 2023-09-26 09:08:52 from "a.rybakina" <a.rybakina at postgrespro.ru> (Patch: Yes)
    Attachment (diff_fix_sel1.diff) at 2023-08-17 10:20:33 from "a.rybakina" <a.rybakina at postgrespro.ru> (Patch: Yes)
    Attachment (regresssion.diff) at 2023-08-17 10:08:03 from "a.rybakina" <a.rybakina at postgrespro.ru> (Patch: Yes)
    Attachment (v7-Replace-OR-clause-to-ANY-expressions.patch) at 2023-08-02 15:58:37 from Alena Rybakina <lena.ribackina at yandex.ru> (Patch: Yes)
    Attachment (v6-Replace-OR-clause-to-ANY-expressions.patch) at 2023-07-18 14:25:28 from Alena Rybakina <lena.ribackina at yandex.ru> (Patch: Yes)
    Attachment (diff-5.diff) at 2023-07-11 18:11:31 from Alena Rybakina <lena.ribackina at yandex.ru> (Patch: Yes)
    Attachment (v5-Replace-OR-clause-to-ANY-expressions.-Replace.patch) at 2023-07-11 14:13:05 from Alena Rybakina <lena.ribackina at yandex.ru> (Patch: Yes)
    Attachment (v5-Replace-OR-clause-to-ANY-expressions.patch) at 2023-07-11 12:29:21 from Alena Rybakina <lena.ribackina at yandex.ru> (Patch: Yes)
    Attachment (diff-4.diff) at 2023-07-11 08:47:45 from Andrey Lepikhov <a.lepikhov at postgrespro.ru> (Patch: Yes)
    Attachment (0001-Replace-OR-clause-to-ANY-expressions.patch) at 2023-07-10 08:38:17 from Alena Rybakina <lena.ribackina at yandex.ru> (Patch: Yes)
    Attachment (diff-3.diff) at 2023-07-10 03:12:23 from Andrey Lepikhov <a.lepikhov at postgrespro.ru> (Patch: Yes)
    Attachment (0001-Replace-OR-clause-to-ANY-expressions.patch) at 2023-07-07 08:20:20 from Alena Rybakina <lena.ribackina at yandex.ru> (Patch: Yes)
    Attachment (delta-2.diff) at 2023-07-07 02:43:26 from Andrey Lepikhov <a.lepikhov at postgrespro.ru> (Patch: Yes)
    Attachment (delta.diff) at 2023-07-06 10:20:46 from Andrey Lepikhov <a.lepikhov at postgrespro.ru> (Patch: Yes)
    Attachment (time_comsuption_with_indexes.png) at 2023-07-05 20:06:26 from Alena Rybakina <lena.ribackina at yandex.ru> (Patch: No)
    Attachment (time_comsuption_with_indexes.png) at 2023-07-05 19:39:08 from Alena Rybakina <lena.ribackina at yandex.ru> (Patch: No)
    Attachment (transform_or_v0.diff) at 2023-06-29 09:32:51 from Alena Rybakina <lena.ribackina at yandex.ru> (Patch: Yes)
    Attachment (graphs.html) at 2023-06-27 15:49:20 from Alena Rybakina <lena.ribackina at yandex.ru> (Patch: No)
    Attachment (regression.diffs) at 2023-06-27 13:19:48 from Alena Rybakina <lena.ribackina at yandex.ru> (Patch: Yes)
    Attachment (saop_patch_test.sql) at 2023-06-26 03:18:37 from Peter Geoghegan <pg at bowt.ie> (Patch: No)
    Attachment (regression.diffs) at 2023-06-26 02:38:14 from Alena Rybakina <lena.ribackina at yandex.ru> (Patch: Yes)
    Attachment (0001-Replace-clause-X-N1-OR-X-N2-.-with-X-ANY-N1-N2-on.patch) at 2023-06-26 01:47:43 from Alena Rybakina <lena.ribackina at yandex.ru> (Patch: Yes)
    Attachment (demo.sql) at 2022-12-28 04:19:27 from Andrey Lepikhov <a.lepikhov at postgrespro.ru> (Patch: No)
    Attachment (0001-idx_or_core-v4.patch.gz) at 2016-03-18 16:38:05 from Teodor Sigaev <teodor at sigaev.ru> (Patch: No)
    Attachment (index_or-3.patch.gz) at 2016-03-17 17:19:55 from Teodor Sigaev <teodor at sigaev.ru> (Patch: No)
    Attachment (index_or-2.patch.gz) at 2016-02-29 18:04:38 from Teodor Sigaev <teodor at sigaev.ru> (Patch: No)
    Attachment (index_or-1.patch.gz) at 2015-12-26 18:04:58 from Teodor Sigaev <teodor at sigaev.ru> (Patch: No)
History
When Who What
2023-11-24 03:17:21 Andrei Lepikhov (lepikhov) Changed name to Replace a large number of OR clauses with ANY expression
2023-10-04 15:06:46 Alena Rybakina (a.rybakina) New status: Needs review
2023-10-02 10:56:58 Peter Eisentraut (petere) Closed in commitfest 2023-09 with status: Moved to next CF
2023-09-20 12:42:37 Peter Eisentraut (petere) New status: Waiting on Author
2023-07-18 14:37:32 Alena Rybakina (a.rybakina) Changed targetversion to 17
2023-07-18 14:12:06 Alena Rybakina (a.rybakina) Changed reviewers to Ranier Vilela (raniervilela)
2023-07-18 14:12:06 Alena Rybakina (a.rybakina) Changed authors to Andrei Lepikhov (lepikhov), Alena Rybakina (alenka)
2023-07-18 14:09:00 Alena Rybakina (a.rybakina) Attached mail thread 567ED6CA.2040504@sigaev.ru
2023-07-18 14:09:00 Alena Rybakina (a.rybakina) Created patch record
Edit