Eliminate xl_heap_visible to reduce vacuum and COPY FREEZE WAL volume

Edit
ID 5841
Title Eliminate xl_heap_visible to reduce vacuum and COPY FREEZE WAL volume
CI (CFBot) Needs rebase! Needs rebase since yesterday. Failing since yesterday.
Additional links previous successfully applied patch (outdated):
Summary
Stats (from CFBot) Unknown
Topic Performance
Tags
Created 2025-06-23 21:42:46
Last modified 2025-11-12 16:03:57 (1 week ago)
Latest email 2025-11-21 01:09:21 (2 days ago)
Status
PG19-4 (2026-01-01 – 2026-01-31): Needs review
PG19-3 (2025-11-01 – 2025-11-30): Moved to different CF
PG19-2 (2025-09-01 – 2025-09-30): Moved to different CF
PG19-1 (2025-07-01 – 2025-07-31): Moved to different CF
Target version 19
Authors Melanie Plageman (melanieplageman)
Reviewers Become reviewer
Committer
Links
Emails
eliminate xl_heap_visible to reduce WAL (and eventually set VM on-access)
First at 2025-06-23 20:25:16 by Melanie Plageman <melanieplageman at gmail.com>
Latest at 2025-11-21 01:09:21 by Chao Li <li.evan.chao at gmail.com>
Latest attachment (v22-0001-Split-heap_page_prune_and_freeze-into-helpers.patch) at 2025-11-20 17:19:58 from Melanie Plageman <melanieplageman at gmail.com>
    Attachment (v22-0001-Split-heap_page_prune_and_freeze-into-helpers.patch) at 2025-11-20 17:19:58 from Melanie Plageman <melanieplageman at gmail.com> (Patch: Yes)
    Attachment (v21-0001-Refactor-heap_page_prune_and_freeze-parameters-i.patch) at 2025-11-19 23:13:30 from Melanie Plageman <melanieplageman at gmail.com> (Patch: Yes)
    Attachment (v20-0001-Refactor-heap_page_prune_and_freeze-parameters-i.patch) at 2025-11-17 23:07:27 from Melanie Plageman <melanieplageman at gmail.com> (Patch: Yes)
    Attachment (v19-0001-Refactor-heap_page_prune_and_freeze-parameters-i.patch) at 2025-11-04 16:48:15 from Melanie Plageman <melanieplageman at gmail.com> (Patch: Yes)
    Attachment (v18-0001-Refactor-heap_page_prune_and_freeze-parameters-i.patch) at 2025-10-14 23:26:57 from Melanie Plageman <melanieplageman at gmail.com> (Patch: Yes)
    Attachment (v17-0001-Eliminate-COPY-FREEZE-use-of-XLOG_HEAP2_VISIBLE.patch) at 2025-10-08 22:54:25 from Melanie Plageman <melanieplageman at gmail.com> (Patch: Yes)
    Attachment (v16-0005-Make-heap_page_is_all_visible-independent-of-LVR.patch) at 2025-10-06 22:40:20 from Melanie Plageman <melanieplageman at gmail.com> (Patch: Yes)
    Attachment (v15-0002-Reorder-heap_page_prune_and_freeze-parameters.patch) at 2025-09-24 17:07:46 from Melanie Plageman <melanieplageman at gmail.com> (Patch: Yes)
    Attachment (v14-0003-Reorder-heap_page_prune_and_freeze-parameters.patch) at 2025-09-18 00:10:07 from Melanie Plageman <melanieplageman at gmail.com> (Patch: Yes)
    Attachment (v13-0004-Use-xl_heap_prune-record-for-setting-empty-pages.patch) at 2025-09-09 23:07:58 from Melanie Plageman <melanieplageman at gmail.com> (Patch: Yes)
    Attachment (v12-0002-Make-heap_page_is_all_visible-independent-of-LVR.patch) at 2025-09-09 16:24:20 from Melanie Plageman <melanieplageman at gmail.com> (Patch: Yes)
    Attachment (v11-0001-Eliminate-xl_heap_visible-in-COPY-FREEZE.patch) at 2025-09-08 22:28:46 from Melanie Plageman <melanieplageman at gmail.com> (Patch: Yes)
    Attachment (v10-0002-Add-error-codes-to-vacuum-VM-corruption-case-log.patch) at 2025-09-08 15:44:24 from Melanie Plageman <melanieplageman at gmail.com> (Patch: Yes)
    Attachment (v9-0002-Remove-unused-xl_heap_prune-member-reason.patch) at 2025-09-05 22:20:21 from Melanie Plageman <melanieplageman at gmail.com> (Patch: Yes)
    Attachment (v8-0002-Add-assert-and-log-message-to-visibilitymap_set.patch) at 2025-09-02 23:11:01 from Melanie Plageman <melanieplageman at gmail.com> (Patch: Yes)
    Attachment (v7-0005-Eliminate-xl_heap_visible-from-vacuum-phase-III.patch) at 2025-08-27 19:02:01 from Melanie Plageman <melanieplageman at gmail.com> (Patch: Yes)
    Attachment (attach.txt) at 2025-08-27 12:55:27 from Kirill Reshke <reshkekirill at gmail.com> (Patch: No)
    Attachment (v6-0001-Eliminate-xl_heap_visible-in-COPY-FREEZE.patch) at 2025-08-01 21:36:19 from Melanie Plageman <melanieplageman at gmail.com> (Patch: Yes)
    Attachment (Set-pd_prune_xid-on-insert.txt) at 2025-07-31 22:58:11 from Melanie Plageman <melanieplageman at gmail.com> (Patch: Yes)
    Attachment (v4-0002-Eliminate-xl_heap_visible-in-COPY-FREEZE.patch) at 2025-07-11 22:19:15 from Melanie Plageman <melanieplageman at gmail.com> (Patch: Yes)
    Attachment (v3-0001-Add-assert-to-heap_prune_record_unchanged_lp_norm.patch) at 2025-07-09 21:59:26 from Melanie Plageman <melanieplageman at gmail.com> (Patch: Yes)
    Attachment (v2-0002-Introduce-unlogged-versions-of-VM-functions.patch) at 2025-06-26 22:04:34 from Melanie Plageman <melanieplageman at gmail.com> (Patch: Yes)
    Attachment (v1-0002-Simplify-vacuum-VM-update-logging-counters.patch) at 2025-06-23 20:25:16 from Melanie Plageman <melanieplageman at gmail.com> (Patch: Yes)
History
When Who What
2025-11-22 18:20:28 CFbot Patch needs rebase
2025-11-17 23:44:40 CFbot Patch does not need rebase anymore
2025-11-12 16:03:57 Melanie Plageman (melanieplageman) Moved from CF PG19-3 to CF PG19-4
2025-11-07 03:13:29 CFbot Patch needs rebase
2025-10-14 23:47:29 CFbot Patch does not need rebase anymore
2025-10-08 22:08:31 CFbot Patch needs rebase
2025-10-07 13:48:35 CFbot Patch does not need rebase anymore
2025-10-07 13:30:21 Melanie Plageman (melanieplageman) Moved from CF PG19-2 to CF PG19-3
2025-09-26 11:55:30 CFbot Patch needs rebase
2025-09-13 02:03:30 CFbot Patch does not need rebase anymore
2025-09-08 16:01:37 CFbot Patch needs rebase
2025-09-02 14:07:25 CFbot Patch does not need rebase anymore
2025-08-29 09:41:28 CFbot Patch needs rebase
2025-08-01 21:45:30 Melanie Plageman (melanieplageman) Moved from CF PG19-1 to CF PG19-2
2025-07-10 04:38:29 CFbot Patch does not need rebase anymore
2025-07-02 08:59:23 CFbot Patch needs rebase
2025-06-23 21:42:46 Melanie Plageman (melanieplageman) Attached mail thread CAAKRu_ZMw6Npd_qm2KM+FwQ3cMOMx1Dh3VMhp8-V7SOLxdK9-g@mail.gmail.com
2025-06-23 21:42:46 Melanie Plageman (melanieplageman) Created patch record
Edit