OR-clauses for index

Edit
Title OR-clauses for index
Topic Performance
Created 2015-12-26 18:06:58
Last modified 2016-03-29 14:02:03 (7 years, 11 months ago)
Latest email 2024-02-24 11:28:01 (1 day, 13 hours ago)
Status
2016-03: Returned with feedback
2016-01: Moved to next CF
Target version
Authors Fedor Sigaev (sigaev)
Reviewers 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 2024-02-24 11:28:01 by jian he <jian.universality at gmail.com>
Latest attachment (v1-0001-Add-enable_or_transformation-doc-entry.no-cfbot) at 2024-02-24 11:28:01 from jian he <jian.universality at gmail.com>
    Attachment (v1-0001-Add-enable_or_transformation-doc-entry.no-cfbot) at 2024-02-24 11:28:01 from jian he <jian.universality at gmail.com> (Patch: Yes)
    Attachment (fix.diff) at 2024-02-20 03:18:23 from Andrei Lepikhov <a.lepikhov at postgrespro.ru> (Patch: Yes)
    Attachment (v17-0001-Transform-OR-clause-to-ANY-expressions.patch) at 2024-02-19 08:35:19 from Andrei Lepikhov <a.lepikhov at postgrespro.ru> (Patch: Yes)
    Attachment (expression_num_or_1_100.sql) at 2024-02-16 00:00:00 from jian he <jian.universality at gmail.com> (Patch: No)
    Attachment (0002-Teach-generate_bitmap_or_paths-to-build-BitmapOr-pat-20240213.patch) at 2024-02-13 10:43:21 from Andrei Lepikhov <a.lepikhov at postgrespro.ru> (Patch: Yes)
    Attachment (0002-Teach-generate_bitmap_or_paths-to-build-BitmapOr-pat-20240212.patch) at 2024-02-12 05:52:13 from Andrei Lepikhov <a.lepikhov at postgrespro.ru> (Patch: Yes)
    Attachment (v1-0001-minor-refactor-generate_saop_pathlist.no-cfbot) at 2024-02-10 05:00:00 from jian he <jian.universality at gmail.com> (Patch: Yes)
    Attachment (v16-0001-Transform-OR-clause-to-ANY-expressions.patch) at 2024-02-08 05:34:38 from Andrei Lepikhov <a.lepikhov at postgrespro.ru> (Patch: Yes)
    Attachment (v15-1-0001-Transform-OR-clause-to-ANY-expressions.patch) at 2024-02-02 19:06:17 from Alena Rybakina <a.rybakina at postgrespro.ru> (Patch: Yes)
    Attachment (v14_comments.no-cfbot) at 2024-01-31 10:15:00 from jian he <jian.universality at gmail.com> (Patch: Yes)
    Attachment (v14-1-0001-Transform-OR-clause-to-ANY-expressions.patch) at 2023-12-05 10:55:00 from Andrei Lepikhov <a.lepikhov at postgrespro.ru> (Patch: Yes)
    Attachment (v14-0001-Transform-OR-clause-to-ANY-expressions.patch) at 2023-12-04 06:50:34 from Andrei Lepikhov <a.lepikhov at postgrespro.ru> (Patch: Yes)
    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
2016-03-29 14:02:03 David Steele (dsteele) Closed in commitfest 2016-03 with status: Returned with feedback
2016-03-20 22:30:29 David Rowley (davidrowley) Removed davidrowley from reviewers
2016-03-19 14:53:11 Robert Haas (rhaas) New status: Waiting on Author
2016-03-19 00:20:39 Andreas Karlsson (kandreas) Removed kandreas from reviewers
2016-03-19 00:20:02 Andreas Karlsson (kandreas) Added kandreas as reviewer
2016-02-29 18:05:32 Fedor Sigaev (sigaev) Closed in commitfest 2016-01 with status: Moved to next CF
2016-01-28 11:16:16 Álvaro Herrera (alvherre) Closed in commitfest 2016-01 with status: Returned with feedback
2016-01-11 03:21:36 David Rowley (davidrowley) New status: Waiting on Author
2016-01-11 03:21:31 David Rowley (davidrowley) Added davidrowley as reviewer
2015-12-26 18:07:18 Fedor Sigaev (sigaev) Changed authors to Fedor Sigaev (sigaev)
2015-12-26 18:06:58 Fedor Sigaev (sigaev) Attached mail thread 567ED6CA.2040504@sigaev.ru
2015-12-26 18:06:58 Fedor Sigaev (sigaev) Created patch record
Edit