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 10 hours. Failing since 10 hours.
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 (2 weeks ago)
Latest email 2026-07-17 20:12:43 (yesterday)
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-17 20:12:43 by Bharath Rupireddy <bharath.rupireddyforpostgres at gmail.com>
Latest attachment (v65-tepid.tar.gz) at 2026-07-16 10:04:43 from "Greg Burd" <greg at burd.me>
    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