Remove inner joins based on foreign keys

Edit
ID 6720
Title Remove inner joins based on foreign keys
CI (CFBot) Summary
Stats (from CFBot) Patch version: v5, Patch count: 2, First patch: +1494−47, All patches: +1660−47
Tags
Created 2026-04-29 01:30:23
Last modified 2026-06-15 09:23:06 (1 hour ago)
Latest email 2026-06-05 14:07:53 (1 week ago)
Status
PG20-1 (2026-07-01 – 2026-07-31): Needs review
Target version
Authors Richard Guo (richardguo)
Reviewers Ilmar Yunusov (tanswis42.gmail.com) Become reviewer
Committer
Links
Emails
Remove inner joins based on foreign keys
First at 2026-03-21 02:47:03 by Richard Guo <guofenglinux at gmail.com>
Latest at 2026-06-05 14:07:53 by Ilmar Yunusov <tanswis42 at gmail.com>
Latest attachment (v5-0001-Remove-inner-joins-based-on-foreign-keys.patch) at 2026-05-25 21:01:08 from Richard Guo <guofenglinux at gmail.com>
    Attachment (v5-0001-Remove-inner-joins-based-on-foreign-keys.patch) at 2026-05-25 21:01:08 from Richard Guo <guofenglinux at gmail.com> (Patch: Yes)
    Attachment (v4-0001-Remove-inner-joins-based-on-foreign-keys.patch) at 2026-05-01 08:25:13 from Richard Guo <guofenglinux at gmail.com> (Patch: No)
    Attachment (v3-0001-Remove-inner-joins-based-on-foreign-keys.patch) at 2026-04-28 10:09:06 from Richard Guo <guofenglinux at gmail.com> (Patch: No)
    Attachment (v2-0001-Remove-inner-joins-based-on-foreign-keys.patch) at 2026-04-01 09:45:42 from Richard Guo <guofenglinux at gmail.com> (Patch: No)
    Attachment (v1-0001-Remove-inner-joins-based-on-foreign-keys.patch) at 2026-03-21 02:47:03 from Richard Guo <guofenglinux at gmail.com> (Patch: Yes)
History
When Who What
2026-06-15 09:23:06 Richard Guo (richardguo) New status: Needs review
2026-06-05 14:07:53 Ilmar Yunusov (tanswis42.gmail.com) Posted review with messageid <178066847358.594057.6986804936448401043.pgcf@coridan.postgresql.org>
2026-06-05 14:07:53 Ilmar Yunusov (tanswis42.gmail.com) New status: Waiting on Author
2026-06-05 14:07:03 Ilmar Yunusov (tanswis42.gmail.com) Added tanswis42.gmail.com as reviewer
2026-04-29 01:30:23 Richard Guo (richardguo) Attached mail thread CAMbWs49-v9FGX+B=tsCxUq_FPX09ZNvXjj+TaTx0m-MAVmY5TA@mail.gmail.com
2026-04-29 01:30:23 Richard Guo (richardguo) Created patch record
Edit