Pull-up subquery if INNER JOIN-ON contains refs to upper-query

Edit
ID 5487
Title Pull-up subquery if INNER JOIN-ON contains refs to upper-query
CI (CFBot) Summary
Stats (from CFBot) Patch version: v6, Patch count: 1, First patch: +1487−46, All patches: +1487−46
Topic Performance
Tags Performance
Created 2025-01-03 11:32:58
Last modified 2025-10-10 11:19:36 (21 hours ago)
Latest email 2025-10-10 11:15:58 (21 hours ago)
Status
PG19-3 (2025-11-01 – 2025-11-30): Needs review
PG19-2 (2025-09-01 – 2025-09-30): Moved to different CF
PG19-1 (2025-07-01 – 2025-07-31): Moved to different CF
2025-03 (2025-03-01 – 2025-04-08): Moved to different CF
Target version 19
Authors Alena Rybakina (a.rybakina)
Reviewers Ilia Evdokimov (ilidock95)Become reviewer
Committer
Links
Emails
Exists pull-up application with JoinExpr
First at 2024-12-24 04:44:38 by Alena Rybakina <a.rybakina at postgrespro.ru>
Latest at 2025-10-10 11:15:58 by Alena Rybakina <lena.ribackina at yandex.ru>
Latest attachment (v6-0001-Enables-pull-up-of-EXISTS-subqueries-that-contain-IN.patch) at 2025-10-10 11:15:58 from Alena Rybakina <lena.ribackina at yandex.ru>
    Attachment (v6-0001-Enables-pull-up-of-EXISTS-subqueries-that-contain-IN.patch) at 2025-10-10 11:15:58 from Alena Rybakina <lena.ribackina at yandex.ru> (Patch: Yes)
    Attachment (v5-0001-Enables-pull-up-of-EXISTS-subqueries-tha.patch) at 2025-09-05 11:31:04 from Alena Rybakina <a.rybakina at postgrespro.ru> (Patch: Yes)
    Attachment (pull_up.diff) at 2025-09-02 21:20:46 from Alena Rybakina <a.rybakina at postgrespro.ru> (Patch: Yes)
    Attachment (convert_EXISTS_sublink_to_lateral_join.patch) at 2025-09-02 21:07:01 from Ilia Evdokimov <ilya.evdokimov at tantorlabs.com> (Patch: Yes)
    Attachment (v4-0001-Teach-the-planner-to-convert-EXISTS-and-NOT-EXISTS-s.patch) at 2025-06-04 10:40:07 from Alena Rybakina <a.rybakina at postgrespro.ru> (Patch: Yes)
    Attachment (regression.diffs) at 2025-02-10 20:51:29 from Ilia Evdokimov <ilya.evdokimov at tantorlabs.com> (Patch: Yes)
    Attachment (v3-0001-Add-appling-the-pull-up-transformation-for-expressio.patch) at 2025-02-09 15:14:09 from Alena Rybakina <a.rybakina at postgrespro.ru> (Patch: Yes)
    Attachment (v2-0001-Teach-the-planner-to-convert-EXISTS-and-NOT-EXISTS-s.patch) at 2025-01-13 17:19:42 from Alena Rybakina <a.rybakina at postgrespro.ru> (Patch: Yes)
    Attachment (v1-0001-Add-EXISTS-pull-up-if-subquery-join-expressions.patch) at 2024-12-24 10:25:37 from Ranier Vilela <ranier.vf at gmail.com> (Patch: Yes)
    Attachment (0001-Add-EXISTS-pull-up-if-subquery-join-expressions.patch) at 2024-12-24 04:44:38 from Alena Rybakina <a.rybakina at postgrespro.ru> (Patch: Yes)
History
When Who What
2025-10-10 11:36:25 CFbot Patch does not need rebase anymore
2025-10-10 11:19:36 Alena Rybakina (a.rybakina) Changed authors to Alena Rybakina (a.rybakina)
2025-10-10 11:17:57 Alena Rybakina (a.rybakina) New status: Needs review
2025-10-10 11:17:52 Alena Rybakina (a.rybakina) Changed tags to Performance
2025-10-10 11:17:52 Alena Rybakina (a.rybakina) Changed targetversion to 19
2025-10-10 11:17:52 Alena Rybakina (a.rybakina) Changed name to Pull-up subquery if INNER JOIN-ON contains refs to upper-query
2025-10-08 18:22:54 Alena Rybakina (a.rybakina) Moved from CF PG19-2 to CF PG19-3
2025-10-03 11:52:35 Alena Rybakina (a.rybakina) New status: Waiting on Author
2025-10-03 11:52:23 Alena Rybakina (a.rybakina) New status: Needs review
2025-09-05 20:48:19 CFbot Patch needs rebase
2025-07-15 08:26:53 Alena Rybakina (a.rybakina) Moved from CF PG19-1 to CF PG19-2
2025-06-10 09:48:07 Ilia Evdokimov (ilidock95) Added ilidock95 as reviewer
2025-06-04 11:54:32 CFbot Patch does not need rebase anymore
2025-04-02 16:51:39 CFbot Patch needs rebase
2025-04-02 16:40:42 Alena Rybakina (a.rybakina) Closed in commitfest 2025-03 with status: Moved to next CF
2025-03-17 06:02:14 vigneshwaran C (vignesh.postgres) New status: Waiting on Author
2025-01-03 11:33:23 Alena Rybakina (alenka) Changed authors to Alena Rybakina (alenka)
2025-01-03 11:32:58 Alena Rybakina (alenka) Attached mail thread 0b1f670d-b39d-4966-bf32-f0d502ebc564@postgrespro.ru
2025-01-03 11:32:58 Alena Rybakina (alenka) Created patch record
Edit