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: v8, Patch count: 1, First patch: +680−20, All patches: +680−20
Tags Performance
Created 2025-01-03 11:32:58
Last modified 2026-09-24 16:09:44 (2 hours ago)
Latest email 2026-09-24 16:05:53 (2 hours ago)
Status
PG20-3 (2026-11-01 – 2026-11-30): Needs review
PG20-Drafts (2026-03-01 – 2027-02-28): Moved to different CF
PG20-2 (2026-09-01 – 2026-09-30): Moved to different CF
PG20-1 (2026-07-01 – 2026-07-31): Moved to different CF
PG19-Final (2026-03-01 – 2026-04-09): Moved to different CF
PG19-4 (2026-01-01 – 2026-01-31): Moved to different CF
PG19-3 (2025-11-01 – 2025-11-30): Moved to different CF
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), Solaimurugan V (solaimurugan) 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 2026-09-24 16:05:53 by Alena Rybakina <lena.ribackina at yandex.ru>
Latest attachment (v8-0001-Allow-pulling-up-EXISTS-sublinks-with-correlated-.patch) at 2026-09-24 16:05:53 from Alena Rybakina <lena.ribackina at yandex.ru>
    Attachment (v8-0001-Allow-pulling-up-EXISTS-sublinks-with-correlated-.patch) at 2026-09-24 16:05:53 from Alena Rybakina <lena.ribackina at yandex.ru> (Patch: No)
    Attachment (v7-0001-Enables-pull-up-of-EXISTS-subqueries-that-contain-IN.patch) at 2026-03-30 05:41:07 from Alena Rybakina <lena.ribackina at yandex.ru> (Patch: Yes)
    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
2026-09-24 16:09:44 Alena Rybakina (a.rybakina) Moved from CF PG20-Drafts to CF PG20-3
2026-09-24 16:09:09 Alena Rybakina (a.rybakina) New status: Needs review
2026-07-28 13:09:35 Alena Rybakina (a.rybakina) Moved from CF PG20-2 to CF PG20-Drafts
2026-07-28 13:09:32 Alena Rybakina (a.rybakina) Moved from CF PG20-1 to CF PG20-2
2026-07-28 13:09:27 Alena Rybakina (a.rybakina) New status: Waiting on Author
2026-05-16 12:39:35 Solaimurugan V (solaimurugan) Added solaimurugan as reviewer
2026-03-30 05:17:51 Alena Rybakina (a.rybakina) New status: Needs review
2026-03-21 16:41:57 Alena Rybakina (a.rybakina) Moved from CF PG19-Final to CF PG20-1
2026-02-23 23:23:56 Alena Rybakina (a.rybakina) Moved from CF PG19-4 to CF PG19-Final
2026-02-23 23:23:47 Alena Rybakina (a.rybakina) New status: Waiting on Author
2025-12-01 18:59:16 Alena Rybakina (alenka) Moved from CF PG19-3 to CF PG19-4
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