Replace IN VALUES with ANY in WHERE clauses during optimization

Edit
ID 5283
Title Replace IN VALUES with ANY in WHERE clauses during optimization
CI (CFBot) Needs rebase! Needs rebase since 7 months. Failing since 7 months.
Additional links previous successfully applied patch (outdated):
Summary
Stats (from CFBot) Unknown
Topic Performance
Tags
Created 2024-10-07 19:08:07
Last modified 2025-04-07 07:20:27 (7 months ago)
Latest email 2025-04-04 16:30:47 (7 months ago)
Status
2025-03 (2025-03-01 – 2025-04-08): Committed
2025-01 (2025-01-01 – 2025-01-31): Moved to different CF
2024-11 (2024-11-01 – 2024-11-30): Moved to different CF
Target version 18
Authors Andrei Lepikhov (lepikhov), Alena Rybakina (a.rybakina)
Reviewers newtglobal postgresql_contributors (newtpostgrescontributors)Become reviewer
Committer Alexander Korotkov (smagen)
Links
Emails
Replace IN VALUES with ANY in WHERE clauses during optimization
First at 2024-10-03 19:52:48 by Ivan Kush <ivan.kush at tantorlabs.com>
Latest at 2025-04-04 16:30:47 by Alena Rybakina <a.rybakina at postgrespro.ru>
Latest attachment (values_test.diff) at 2025-04-04 15:19:37 from Alena Rybakina <a.rybakina at postgrespro.ru>
    Attachment (values_test.diff) at 2025-04-04 15:19:37 from Alena Rybakina <a.rybakina at postgrespro.ru> (Patch: Yes)
    Attachment (v9-0001-Extract-make_SAOP_expr-function-from-match_orclau.patch) at 2025-04-03 15:26:48 from Alexander Korotkov <aekorotkov at gmail.com> (Patch: Yes)
    Attachment (values_to_any.diff.no-cfbot) at 2025-04-02 14:33:43 from Alena Rybakina <a.rybakina at postgrespro.ru> (Patch: Yes)
    Attachment (v8-0001-Extract-make_SAOP_expr-function-from-match_orclau.patch) at 2025-04-01 12:07:59 from Alexander Korotkov <aekorotkov at gmail.com> (Patch: Yes)
    Attachment (v7-0001-Extract-make_SAOP_expr-function-from-match_orclau.patch) at 2025-03-29 11:03:07 from Alexander Korotkov <aekorotkov at gmail.com> (Patch: Yes)
    Attachment (v6-0001-Move-the-function-for-generating-ArrayExpr-to-ano.patch) at 2025-03-06 08:23:29 from Alexander Korotkov <aekorotkov at gmail.com> (Patch: Yes)
    Attachment (consider_vars.diff.no-cfbot) at 2025-03-01 11:39:11 from Alena Rybakina <a.rybakina at postgrespro.ru> (Patch: Yes)
    Attachment (consider_vars.diff.no-cfbot) at 2025-02-28 11:48:47 from Alena Rybakina <a.rybakina at postgrespro.ru> (Patch: Yes)
    Attachment (v3-0002-Add-an-implementation-of-the-x-IN-VALUES-to-x-ANY-.-.patch) at 2025-02-20 21:09:27 from Alena Rybakina <a.rybakina at postgrespro.ru> (Patch: Yes)
    Attachment (v2-0001-Add-an-implementation-of-the-x-IN-VALUES-to-x-ANY.patch) at 2025-01-09 13:10:51 from Alena Rybakina <a.rybakina at postgrespro.ru> (Patch: Yes)
    Attachment (0001-Introduce-VALUES-ARRAY-transformation.patch) at 2024-10-04 09:05:01 from Andrei Lepikhov <lepihov at gmail.com> (Patch: Yes)
    Attachment (commands.sql) at 2024-10-03 19:52:48 from Ivan Kush <ivan.kush at tantorlabs.com> (Patch: No)

Annotations

When Who Mail Annotation
2024-12-11 03:49:41 newtglobal postgresql_contributors (newtpostgrescontributors) From Ivan Kush <ivan.kush@tantorlabs.com>
at 2024-10-03 19:52:48		 I tested the patch with `commands.sql` and observed noticeable improvements in planning and execution time, especially with multiple tables. Even single-table queries show small time reductions (0.02–0.04 ms). The patch optimizes `IN` clauses effectively, particularly with `VALUES`. For example, `col IN (VALUES ('a'), ('b'), ('c'))` now behaves similarly to `col IN ('a', 'b', 'c')`, leading to faster execution and reduced planning overhead. Regards, Postgresql Contributors - NewtGlobal
History
When Who What
2025-04-07 07:20:27 Alexander Korotkov (smagen) Changed targetversion to 18
2025-04-07 07:20:20 Alexander Korotkov (smagen) Closed in commitfest 2025-03 with status: Committed
2025-04-07 07:20:20 Alexander Korotkov (smagen) Changed committer to smagen
2025-04-04 15:59:38 CFbot Patch needs rebase
2025-02-27 11:09:02 newtglobal postgresql_contributors (newtpostgrescontributors) Posted review with messageid <174065454278.654.1011593946047422922.pgcf@coridan.postgresql.org>
2025-02-06 10:09:40 Alexander Korotkov (smagen) Changed targetversion to None
2025-02-06 10:09:29 Alexander Korotkov (smagen) Removed smagen from committers
2025-02-06 10:09:25 Alexander Korotkov (smagen) New status: Needs review
2025-02-05 19:54:06 Alexander Korotkov (smagen) Closed in commitfest 2025-03 with status: Committed
2025-02-05 19:54:06 Alexander Korotkov (smagen) Changed committer to smagen
2025-02-04 13:45:54 Alena Rybakina (a.rybakina) Closed in commitfest 2025-01 with status: Moved to next CF
2024-12-11 03:49:41 newtglobal postgresql_contributors (newtpostgrescontributors) Added annotation "I tested the patch with `commands.sql` and observed noticeable improvements in planning and [...]" to 0184212d-1248-4f1f-a42d-f5cb1c1976d2@tantorlabs.com
2024-12-09 03:54:03 newtglobal postgresql_contributors (newtpostgrescontributors) Added newtpostgrescontributors as reviewer
2024-12-02 13:58:52 Dmitry Dolgov (erthalion) Closed in commitfest 2024-11 with status: Moved to next CF
2024-10-07 19:09:29 Alena Rybakina (alenka) Changed authors to Andrei Lepikhov (lepikhov), Alena Rybakina (a.rybakina)
2024-10-07 19:09:28 Alena Rybakina (alenka) Changed targetversion to 18
2024-10-07 19:08:07 Alena Rybakina (alenka) Attached mail thread 0184212d-1248-4f1f-a42d-f5cb1c1976d2@tantorlabs.com
2024-10-07 19:08:07 Alena Rybakina (alenka) Created patch record
Edit