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) Summary
Stats (from CFBot) Patch count: 21, First patch: +348−1, All patches: +17598−1021
Tags Performance
Created 2026-07-01 18:50:24
Last modified 2026-09-30 19:20:56 (4 weeks ago)
Latest email 2026-10-29 20:53:33 (7 hours ago)
Status
PG20-3 (2026-11-01 – 2026-11-30): Needs review
PG20-2 (2026-09-01 – 2026-09-30): Moved to different CF
Target version 20
Authors Greg Burd (gregburd)
Reviewers Bharath Rupireddy (bharathrupireddy) 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-28 03:36:54 by Chao Li <li.evan.chao at gmail.com>
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)
Re: Tepid: selective index updates for heap relations
First at 2026-09-28 01:27:33 by Greg Burd <greg at burd.me>
Latest at 2026-10-29 20:53:33 by Greg Burd <greg at burd.me>
Latest attachment (tepid-v79.tgz) at 2026-10-23 18:21:04 from Greg Burd <greg at burd.me>
    Attachment (tepid-v79.tgz) at 2026-10-23 18:21:04 from Greg Burd <greg at burd.me> (Patch: No)
    Attachment (tepid-v74.tar.gz) at 2026-10-15 18:15:08 from Greg Burd <greg at burd.me> (Patch: No)
    Attachment (tepid-v73.tar.gz) at 2026-10-12 22:00:45 from Greg Burd <greg at burd.me> (Patch: No)
    Attachment (tepid-v72.tar.gz) at 2026-10-12 19:19:03 from Greg Burd <greg at burd.me> (Patch: No)
    Attachment (tepid-v71.tar.gz) at 2026-10-10 16:14:37 from Greg Burd <greg at burd.me> (Patch: No)
    Attachment (tepid-v70.tgz) at 2026-10-06 12:25:50 from Greg Burd <greg at burd.me> (Patch: No)
    Attachment (tepid-v69.tgz) at 2026-10-03 16:52:56 from Greg Burd <greg at burd.me> (Patch: No)
    Attachment (v68-tepid.tgz) at 2026-09-28 01:27:33 from Greg Burd <greg at burd.me> (Patch: No)
History
When Who What
2026-10-15 18:48:36 CFbot Patch does not need rebase anymore
2026-10-15 07:11:30 CFbot Patch needs rebase
2026-10-06 12:35:41 CFbot Patch does not need rebase anymore
2026-10-06 02:40:34 CFbot Patch needs rebase
2026-10-03 17:23:39 CFbot Patch does not need rebase anymore
2026-10-03 05:27:33 CFbot Patch needs rebase
2026-09-30 19:21:39 CFbot Patch does not need rebase anymore
2026-09-30 19:20:56 Greg Burd (gregburd) Attached mail thread 3604ec98-147d-4ba5-b215-412fa2797633@app.fastmail.com
2026-09-28 17:47:48 Greg Burd (gregburd) Moved from CF PG20-2 to CF PG20-3
2026-09-28 10:41:10 Greg Burd (gregburd) New status: Needs review
2026-09-03 18:26:29 Nathan Bossart (bossartn) Changed authors to Greg Burd (gregburd)
2026-08-30 17:48:40 Andrey Borodin (x4m) New status: Waiting on Author
2026-08-04 23:58:16 Bharath Rupireddy (bharathrupireddy) Added bharathrupireddy as reviewer
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