Expanding HOT updates for expression and partial indexes

Edit
ID 5556
Title Expanding HOT updates for expression and partial indexes
CI (CFBot) Summary
Stats (from CFBot) Patch version: v38, Patch count: 2, First patch: +1355−0, All patches: +1928−224
Tags Performance
Created 2025-02-07 12:42:11
Last modified 2026-04-01 14:27:26 (5 hours ago)
Latest email 2026-03-27 17:01:48 (5 days ago)
Status
PG20-1 (2026-07-01 – 2026-07-31): Needs review
PG19-Final (2026-03-01 – 2026-04-09): Moved to different CF
PG19-4 (2026-01-01 – 2026-01-31): Moved to different CF
PG19-3 (2025-11-01 – 2025-11-30): Moved to different CF
PG19-1 (2025-07-01 – 2025-07-31): Moved to different CF
2025-03 (2025-03-01 – 2025-04-08): Moved to different CF
Target version 19
Authors Greg Burd (gregburd)
Reviewers Nathan Bossart (bossartn)Become reviewer
Committer
Links Git
Emails
Expanding HOT updates for expression and partial indexes
First at 2025-02-06 22:24:34 by "Burd, Greg" <gregburd at amazon.com>
Latest at 2026-03-27 17:01:48 by Jeff Davis <pgsql at j-davis.com>
Latest attachment (v38-0001-Add-tests-to-cover-a-variety-of-heap-HOT-update-.patch) at 2026-03-24 18:02:07 from "Greg Burd" <greg at burd.me>
    Attachment (v38-0001-Add-tests-to-cover-a-variety-of-heap-HOT-update-.patch) at 2026-03-24 18:02:07 from "Greg Burd" <greg at burd.me> (Patch: Yes)
    Attachment (v37-0001-Add-tests-to-cover-a-variety-of-heap-HOT-update-.patch) at 2026-03-17 18:04:11 from "Greg Burd" <greg at burd.me> (Patch: Yes)
    Attachment (v36-0001-Add-tests-to-cover-a-variety-of-heap-HOT-update-.patch) at 2026-03-16 20:51:31 from "Greg Burd" <greg at burd.me> (Patch: Yes)
    Attachment (v35-0001-Add-tests-to-cover-a-variety-of-heap-HOT-update-.patch) at 2026-03-11 15:51:03 from "Greg Burd" <greg at burd.me> (Patch: Yes)
    Attachment (v33-0001-Add-comprehensive-tests-for-HOT-updates-and-repl.patch) at 2026-03-02 19:08:50 from "Greg Burd" <greg at burd.me> (Patch: Yes)
    Attachment (v31-0001-Idenfity-modified-indexed-attributes-in-the-exec.patch) at 2026-02-26 23:01:53 from "Greg Burd" <greg at burd.me> (Patch: No)
    Attachment (v30-0001-Idenfity-modified-indexed-attributes-in-t.patch) at 2026-02-26 22:08:17 from "Greg Burd" <greg at burd.me> (Patch: No)
    Attachment (v20260226-0001-Idenfity-modified-indexed-attributes-in-th.patch) at 2026-02-23 19:23:39 from "Greg Burd" <greg at burd.me> (Patch: Yes)
    Attachment (v20260219-0001-Idenfity-modified-indexed-attributes-in-th.patch) at 2026-02-19 20:32:25 from "Greg Burd" <greg at burd.me> (Patch: Yes)
    Attachment (v20260217-0001-Idenfity-modified-indexed-attributes-in-th.patch) at 2026-02-17 21:15:02 from "Greg Burd" <greg at burd.me> (Patch: Yes)
    Attachment (v20260215-0001-Idenfity-modified-indexed-attributes-in-th.patch) at 2026-02-15 20:39:42 from "Greg Burd" <greg at burd.me> (Patch: Yes)
    Attachment (v20260211-0001-Idenfity-modified-indexed-attributes-in-th.patch) at 2026-02-13 21:06:08 from "Greg Burd" <greg at burd.me> (Patch: Yes)
    Attachment (perf-cf5556) at 2026-02-10 15:09:36 from "Greg Burd" <greg at burd.me> (Patch: No)
    Attachment (v28-0001-Prepare-heapam_tuple_update-and-simple_heap_upda.patch) at 2026-01-13 14:54:10 from Greg Burd <greg at burd.me> (Patch: Yes)
    Attachment (v27-0001-Prepare-heapam_tuple_update-and-simple_heap_upda.patch) at 2026-01-08 20:25:55 from Greg Burd <greg at burd.me> (Patch: Yes)
    Attachment (v26-0001-Prepare-heapam_tuple_update-and-simple_heap_upda.patch) at 2025-12-15 21:46:11 from Greg Burd <greg at burd.me> (Patch: Yes)
    Attachment (v25-0001-Prepare-heapam_tuple_update-and-simple_heap_upda.patch) at 2025-12-03 22:06:06 from Greg Burd <greg at burd.me> (Patch: Yes)
    Attachment (v23-0001-Reorganize-heap-update-logic.patch) at 2025-11-22 21:30:39 from Greg Burd <greg at burd.me> (Patch: Yes)
    Attachment (v22-0001-Reorganize-heap-update-logic.patch) at 2025-11-19 18:21:51 from Greg Burd <greg at burd.me> (Patch: Yes)
    Attachment (v21-0001-Reorganize-heap-update-logic.patch) at 2025-11-19 18:00:29 from Greg Burd <greg at burd.me> (Patch: Yes)
    Attachment (v19-0001-Reorganize-heap-update-logic.patch) at 2025-11-16 18:53:09 from Greg Burd <greg at burd.me> (Patch: Yes)
    Attachment (v18-0001-Expand-HOT-update-path-to-include-expression-and.patch) at 2025-10-07 21:36:11 from Greg Burd <greg at burd.me> (Patch: Yes)
    Attachment (v17-0001-Expand-HOT-update-path-to-include-expression-and.patch) at 2025-07-02 18:10:19 from "Greg Burd" <greg at burd.me> (Patch: Yes)
    Attachment (v15-0001-Expand-HOT-update-path-to-include-expression-and.patch) at 2025-03-25 14:21:14 from "Burd, Greg" <gregburd at amazon.com> (Patch: Yes)
    Attachment (v14-0001-Expand-HOT-update-path-to-include-expression-and.patch) at 2025-03-25 11:47:21 from "Burd, Greg" <gregburd at amazon.com> (Patch: Yes)
    Attachment (v10-0001-Expand-HOT-update-path-to-include-expression-and.patch) at 2025-03-05 17:20:34 from "Burd, Greg" <gregburd at amazon.com> (Patch: Yes)
    Attachment (v7-0001-Expand-HOT-update-path-to-include-expression-and-.patch) at 2025-02-18 18:09:22 from "Burd, Greg" <gregburd at amazon.com> (Patch: Yes)
    Attachment (v6-0001-Expand-HOT-update-path-to-include-expression-and-.patch) at 2025-02-17 19:53:47 from "Burd, Greg" <gregburd at amazon.com> (Patch: Yes)
    Attachment (v5-0001-Expand-HOT-update-path-to-include-expression-and-.patch) at 2025-02-13 18:46:18 from "Burd, Greg" <gregburd at amazon.com> (Patch: Yes)
    Attachment (prototype.diff.txt) at 2025-02-11 21:18:45 from Matthias van de Meent <boekewurm+postgres at gmail.com> (Patch: Yes)
    Attachment (v3-0001-Expand-HOT-update-path-to-include-expression-and-.patch) at 2025-02-06 22:24:34 from "Burd, Greg" <gregburd at amazon.com> (Patch: Yes)
History
When Who What
2026-04-01 14:27:26 Nathan Bossart (bossartn) Moved from CF PG19-Final to CF PG20-1
2026-03-03 18:55:54 Nathan Bossart (bossartn) Added bossartn as reviewer
2026-02-26 23:20:33 CFbot Patch does not need rebase anymore
2026-02-26 22:18:28 CFbot Patch needs rebase
2026-02-01 00:00:09 CFbot Moved from CF PG19-4 to CF PG19-Final
2026-01-08 20:32:34 CFbot Patch does not need rebase anymore
2025-12-31 22:53:25 CFbot Patch needs rebase
2025-12-09 13:02:15 Greg Burd (gregburd) Moved from CF PG19-3 to CF PG19-4
2025-12-04 12:57:31 CFbot Patch does not need rebase anymore
2025-11-26 18:41:23 CFbot Patch needs rebase
2025-11-19 18:31:43 Greg Burd (gregburd) Changed gitlink to https://github.com/gburd/postgres/tree/cf-5556
2025-11-16 19:15:32 CFbot Patch does not need rebase anymore
2025-11-01 11:01:23 CFbot Patch needs rebase
2025-10-08 13:30:16 Greg Burd (gregburd) Moved from CF PG19-1 to CF PG19-3
2025-07-03 11:21:40 Greg Burd (gregburd) Changed tags to Performance
2025-07-02 18:44:25 CFbot Patch does not need rebase anymore
2025-06-30 19:49:38 CFbot Patch needs rebase
2025-04-09 14:04:19 Greg Burd (gregburd) Closed in commitfest 2025-03 with status: Moved to next CF
2025-03-25 12:26:43 CFbot Patch does not need rebase anymore
2025-03-22 22:26:31 CFbot Patch needs rebase
2025-03-17 12:47:20 Greg Burd (gregburd) Changed targetversion to 19
2025-02-07 12:47:02 Greg Burd (gregburd) Changed authors to Greg Burd (gregburd)
2025-02-07 12:47:02 Greg Burd (gregburd) Changed targetversion to 18
2025-02-07 12:42:11 Greg Burd (gregburd) Attached mail thread 78574B24-BE0A-42C5-8075-3FA9FA63B8FC@amazon.com
2025-02-07 12:42:11 Greg Burd (gregburd) Created patch record
Edit