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: v41, Patch count: 10, First patch: +1528−1, All patches: +6687−311
Tags Performance
Created 2025-02-07 12:42:11
Last modified 2026-10-17 22:00:14 (3 days ago)
Latest email 2026-10-19 21:10:13 (yesterday)
Status
PG20-3 (2026-11-01 – 2026-11-30): Needs review
PG20-1 (2026-07-01 – 2026-07-31): Moved to different CF
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 20
Authors Greg Burd (gregburd)
Reviewers 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-10-19 21:10:13 by Matthias van de Meent <boekewurm+postgres at gmail.com>
Latest attachment (v41-0002-Identify-modified-indexed-attributes-in-the-exec.patch) at 2026-10-19 20:18:51 from Greg Burd <greg at burd.me>
    Attachment (v41-0002-Identify-modified-indexed-attributes-in-the-exec.patch) at 2026-10-19 20:18:51 from Greg Burd <greg at burd.me> (Patch: No)
    Attachment (v39-0003-Allow-HOT-updates-when-expression-and-partial-in.patch) at 2026-10-18 10:59:09 from Greg Burd <greg at burd.me> (Patch: No)
    Attachment (v39-0006-nbtree-implement-amcomparedatums.patch) at 2026-10-17 18:30:54 from Greg Burd <gregburd at protonmail.com> (Patch: No)
    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-10-18 11:02:42 CFbot Patch does not need rebase anymore
2026-10-17 22:00:14 Greg Burd (gregburd) New status: Needs review
2026-10-17 21:52:55 Greg Burd (gregburd) Changed targetversion to 20
2026-10-16 15:18:19 Greg Burd (gregburd) Moved from CF PG20-1 to CF PG20-3
2026-08-03 13:59:34 Nathan Bossart (bossartn) Removed bossartn from reviewers
2026-05-14 14:08:30 Nathan Bossart (bossartn) New status: Waiting on Author
2026-04-03 13:35:27 CFbot Patch needs rebase
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