Tepid: extend the heap-only tuple (HOT) update optimization model such that only those indexes directly impacted by the update need be updated

Edit
ID 6968
Title Tepid: extend the heap-only tuple (HOT) update optimization model such that only those indexes directly impacted by the update need be updated
CI (CFBot) Needs rebase! Needs rebase since 1 week. Failing since 1 week.
Additional links previous successfully applied patch (outdated):
Stats (from CFBot) Unknown
Tags Performance
Created 2026-07-01 18:50:24
Last modified 2026-07-01 18:50:24 (3 weeks ago)
Latest email 2026-07-20 21:34:41 (6 days ago)
Status
PG20-2 (2026-09-01 – 2026-09-30): Needs review
Target version 20
Authors Nathan Bossart (bossartn), Greg Burd (gregburd)
Reviewers Become reviewer
Committer
Links Wiki Git
Emails
Tepid: selective index updates for heap relations
First at 2026-06-30 17:21:07 by "Greg Burd" <greg at burd.me>
Latest at 2026-07-20 21:34:41 by "Greg Burd" <greg at burd.me>
Latest attachment (v67-tepid.tgz) at 2026-07-20 21:34:41 from "Greg Burd" <greg at burd.me>
    Attachment (v67-tepid.tgz) at 2026-07-20 21:34:41 from "Greg Burd" <greg at burd.me> (Patch: No)
    Attachment (v65-tepid.tar.gz) at 2026-07-16 10:04:43 from "Greg Burd" <greg at burd.me> (Patch: No)
    Attachment (v64-tepid.tar.gz) at 2026-07-13 21:06:49 from "Greg Burd" <greg at burd.me> (Patch: No)
    Attachment (v63-0001-Add-tests-to-cover-a-variety-of-heap-HOT-update-.patch) at 2026-07-13 16:26:23 from "Greg Burd" <greg at burd.me> (Patch: Yes)
    Attachment (v60-0001-Add-tests-to-cover-a-variety-of-heap-HOT-update-.patch) at 2026-07-11 22:04:34 from "Greg Burd" <greg at burd.me> (Patch: Yes)
    Attachment (v59-0001-Add-tests-to-cover-a-variety-of-heap-HOT-update-.patch) at 2026-07-11 17:37:19 from "Greg Burd" <greg at burd.me> (Patch: Yes)
    Attachment (v58-0001-Add-tests-to-cover-a-variety-of-heap-HOT-update-.patch) at 2026-07-09 15:41:08 from "Greg Burd" <greg at burd.me> (Patch: Yes)
    Attachment (v57-0001-Add-tests-to-cover-a-variety-of-heap-HOT-update-.patch) at 2026-07-08 14:05:24 from "Greg Burd" <greg at burd.me> (Patch: Yes)
    Attachment (v56-0001-Add-tests-to-cover-a-variety-of-heap-HOT-update-.patch) at 2026-07-06 13:16:22 from "Greg Burd" <greg at burd.me> (Patch: Yes)
    Attachment (v51-0001-Add-tests-to-cover-a-variety-of-heap-HOT-update-.patch) at 2026-07-03 10:54:37 from "Greg Burd" <greg at burd.me> (Patch: Yes)
    Attachment (v50-0001-Add-tests-to-cover-a-variety-of-heap-HOT-update-.patch) at 2026-07-02 16:40:51 from "Greg Burd" <greg at burd.me> (Patch: Yes)
    Attachment (v49-0001-Add-tests-to-cover-a-variety-of-heap-HOT-update-.patch) at 2026-07-01 20:49:01 from "Greg Burd" <greg at burd.me> (Patch: Yes)
    Attachment (v48-0001-Add-tests-to-cover-a-variety-of-heap-HOT-update-.patch) at 2026-06-30 17:21:07 from "Greg Burd" <greg at burd.me> (Patch: Yes)
History
When Who What
2026-07-18 20:19:30 CFbot Patch needs rebase
2026-07-16 10:36:37 CFbot Patch does not need rebase anymore
2026-07-16 07:12:28 CFbot Patch needs rebase
2026-07-12 06:34:42 CFbot Patch does not need rebase anymore
2026-07-11 18:04:33 CFbot Patch needs rebase
2026-07-09 10:36:40 CFbot Patch does not need rebase anymore
2026-07-08 23:12:32 CFbot Patch needs rebase
2026-07-05 23:14:36 CFbot Patch does not need rebase anymore
2026-07-01 18:53:31 CFbot Patch needs rebase
2026-07-01 18:50:24 Greg Burd (gregburd) Attached mail thread af02b486-6adc-494c-a357-1dd72f655dcf@app.fastmail.com
2026-07-01 18:50:24 Greg Burd (gregburd) Created patch record
Edit