reducing memory usage during join search

Title

CI (CFBot)

Summary

Stats (from CFBot)

Patch version: v2, Patch count: 6, First patch: +8−10, All patches: +118−16

Tags

Performance

Created

2026-06-16 10:19:59

Last modified

2026-06-16 10:20:00 (3 hours ago)

Latest email

2026-06-13 19:56:10 (2 days ago)

Status

PG20-Drafts (2026-03-01 – 2027-02-28): Needs review

Target version

Authors

Tom Lane (tgl), Tomas Vondra (fuzzycz)

Reviewers

Become reviewer

Committer

Links

Emails

Subquery pull-up increases jointree search space: First at 2026-02-09 17:22:17 by Andrei Lepikhov <lepihov at gmail.com>
Latest at 2026-06-13 19:56:10 by Andrei Lepikhov <lepihov at gmail.com>
Latest attachment (massif.txt) at 2026-06-13 13:54:01 from Tomas Vondra <tomas at vondra.me>
    Attachment (massif.txt) at 2026-06-13 13:54:01 from Tomas Vondra <tomas at vondra.me> (Patch: No)
    Attachment (v2-0001-Tom-s-patch.patch) at 2026-06-09 10:43:04 from Tomas Vondra <tomas at vondra.me> (Patch: Yes)
    Attachment (release-some-transient-sublists.patch) at 2026-06-07 18:57:38 from Tom Lane <tgl at sss.pgh.pa.us> (Patch: Yes)
    Attachment (create.sql) at 2026-06-07 18:10:09 from Tomas Vondra <tomas at vondra.me> (Patch: No)
    Attachment (join planning stats.pdf) at 2026-06-05 10:43:03 from Tomas Vondra <tomas at vondra.me> (Patch: No)
    Attachment (v0-0001-Push-pulled-up-SEMI-ANTI-joins-next-to-their-refe.patch) at 2026-05-13 15:11:18 from Andrei Lepikhov <lepihov at gmail.com> (Patch: Yes)
    Attachment (trivial-example.sql) at 2026-05-09 10:51:27 from Andrei Lepikhov <lepihov at gmail.com> (Patch: No)
    Attachment (exp1.sql) at 2026-02-09 17:22:17 from Andrei Lepikhov <lepihov at gmail.com> (Patch: No)

History

When	Who	What
2026-06-16 10:20:00	Tomas Vondra (fuzzycz)	Attached mail thread CAMMNXXnUnRs6CZA5+67dHtdf4Hyk45Th6Dfsk_n_yaMsUMHD8A@mail.gmail.com
2026-06-16 10:19:59	Tomas Vondra (fuzzycz)	Created patch record