Let an ordering index scan hand its ORDER BY value to the target list

Edit
ID 7392
Title Let an ordering index scan hand its ORDER BY value to the target list
CI (CFBot) Needs rebase! Needs rebase since 1 hour. Failing since 1 hour.
Additional links previous successfully applied patch (outdated):
Stats (from CFBot) Unknown
Tags Performance
Created 2026-10-04 15:31:46
Last modified 2026-10-04 15:31:46 (3 weeks ago)
Latest email 2026-10-24 21:48:37 (2 days ago)
Status
PG20-3 (2026-11-01 – 2026-11-30): Needs review
Target version 20
Authors Greg Burd (gregburd)
Reviewers Become reviewer
Committer
Links
Emails
Let an ordering index scan hand its ORDER BY value to the target list
First at 2026-10-01 19:10:21 by Greg Burd <greg at burd.me>
Latest at 2026-10-24 21:48:37 by Greg Burd <greg at burd.me>
Latest attachment (v11-0002-Let-an-ordering-index-scan-hand-its-ORDER-BY-val.patch) at 2026-10-24 21:48:37 from Greg Burd <greg at burd.me>
    Attachment (v11-0002-Let-an-ordering-index-scan-hand-its-ORDER-BY-val.patch) at 2026-10-24 21:48:37 from Greg Burd <greg at burd.me> (Patch: No)
    Attachment (v10-0005-Let-an-index-only-scan-win-on-the-index-expressi.patch) at 2026-10-23 21:47:54 from Greg Burd <greg at burd.me> (Patch: No)
    Attachment (v9-0003-Let-an-ordering-index-scan-below-a-join-emit-its-.patch) at 2026-10-21 15:45:11 from Greg Burd <greg at burd.me> (Patch: No)
    Attachment (cf7392-bench-hammerdb.tar.gz.nocfbot) at 2026-10-11 16:42:50 from Greg Burd <greg at burd.me> (Patch: No)
    Attachment (v8-0005-Let-an-index-only-scan-win-on-the-index-expressio.patch) at 2026-10-09 13:28:18 from Greg Burd <greg at burd.me> (Patch: No)
    Attachment (v7-0002-Don-t-charge-an-ordering-index-scan-for-ORDER-BY-.patch) at 2026-10-08 14:25:34 from Greg Burd <greg at burd.me> (Patch: No)
    Attachment (v5-0004-Don-t-charge-an-index-only-scan-for-index-express.patch) at 2026-10-07 11:43:50 from Greg Burd <greg at burd.me> (Patch: No)
    Attachment (v4-0002-Don-t-charge-an-ordering-index-scan-for-ORDER-BY-.patch) at 2026-10-06 21:18:43 from Greg Burd <greg at burd.me> (Patch: No)
    Attachment (v3-0001-Let-an-ordering-index-scan-hand-its-ORDER-BY-valu.patch) at 2026-10-05 18:14:37 from Greg Burd <greg at burd.me> (Patch: No)
    Attachment (v2-0001-Let-an-ordering-index-scan-hand-its-ORDER-BY-valu.patch) at 2026-10-05 12:39:08 from Greg Burd <greg at burd.me> (Patch: No)
    Attachment (v1-0001-Let-an-ordering-index-scan-hand-its-ORDER-BY-valu.patch) at 2026-10-01 19:10:21 from Greg Burd <greg at burd.me> (Patch: No)
History
When Who What
2026-10-27 12:26:34 CFbot Patch needs rebase
2026-10-04 15:31:46 Greg Burd (gregburd) Attached mail thread 8s5lT8erXzBMugXJQ6Wginbp_gc2B4hmCYhF0Q0GpnuK87eCAOcKs5K31AWCwraCNFIQt42wwkow_MPPubHg485MWv-zDBY4NL_JX9yJEEg=@burd.me
2026-10-04 15:31:46 Greg Burd (gregburd) Created patch record
Edit