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) Summary
Stats (from CFBot) Patch count: 1, First patch: +11−5, All patches: +11−5
Tags Performance
Created 2025-06-23 21:42:46
Last modified 2025-11-12 16:03:57 (2 months ago)
Latest email 2026-01-29 15:16:26 (17 hours 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 Kirill Reshke (reshke)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 2026-01-29 15:16:26 by Melanie Plageman <melanieplageman at gmail.com>
Latest attachment (debug-pg_visibility.patch) at 2026-01-29 05:00:00 from Alexander Lakhin <exclusion at gmail.com>
    Attachment (debug-pg_visibility.patch) at 2026-01-29 05:00:00 from Alexander Lakhin <exclusion at gmail.com> (Patch: Yes)
    Attachment (v34-0001-Clarify-some-heap-tuple-freezing-related-comment.patch) at 2026-01-28 23:16:10 from Melanie Plageman <melanieplageman at gmail.com> (Patch: Yes)
    Attachment (v33-0001-Combine-visibilitymap_set-cases-in-lazy_scan_pru.patch) at 2026-01-06 17:31:57 from Melanie Plageman <melanieplageman at gmail.com> (Patch: Yes)
    Attachment (v32-0001-Combine-visibilitymap_set-cases-in-lazy_scan_pru.patch) at 2026-01-05 19:24:54 from Melanie Plageman <melanieplageman at gmail.com> (Patch: Yes)
    Attachment (v31-0001-Combine-visibilitymap_set-cases-in-lazy_scan_pru.patch) at 2025-12-22 18:20:59 from Melanie Plageman <melanieplageman at gmail.com> (Patch: Yes)
    Attachment (v30-0001-Combine-visibilitymap_set-cases-in-lazy_scan_pru.patch) at 2025-12-22 17:57:16 from Melanie Plageman <melanieplageman at gmail.com> (Patch: Yes)
    Attachment (v29-0001-Combine-visibilitymap_set-cases-in-lazy_scan_pru.patch) at 2025-12-19 21:09:47 from Melanie Plageman <melanieplageman at gmail.com> (Patch: Yes)
    Attachment (v1-0001-Add-TAP-test-for-empty-page-vacuum.patch) at 2025-12-18 18:07:20 from Kirill Reshke <reshkekirill at gmail.com> (Patch: Yes)
    Attachment (v28-0001-Combine-visibilitymap_set-cases-in-lazy_scan_pru.patch) at 2025-12-18 00:30:01 from Melanie Plageman <melanieplageman at gmail.com> (Patch: Yes)
    Attachment (v27-0001-Combine-visibilitymap_set-cases-in-lazy_scan_pru.patch) at 2025-12-16 16:58:50 from Melanie Plageman <melanieplageman at gmail.com> (Patch: Yes)
    Attachment (v26-0001-Combine-visibilitymap_set-cases-in-lazy_scan_pru.patch) at 2025-12-15 21:29:03 from Melanie Plageman <melanieplageman at gmail.com> (Patch: Yes)
    Attachment (0001-Fix-const-qualification-in-prune_freeze_setup.patch.nocfbot) at 2025-12-13 13:59:29 from Peter Eisentraut <peter at eisentraut.org> (Patch: Yes)
    Attachment (v25-0001-Combine-visibilitymap_set-cases-in-lazy_scan_pru.patch) at 2025-12-10 23:35:47 from Melanie Plageman <melanieplageman at gmail.com> (Patch: Yes)
    Attachment (v24-0001-Simplify-vacuum-visibility-assertion.patch) at 2025-12-09 17:48:45 from Melanie Plageman <melanieplageman at gmail.com> (Patch: Yes)
    Attachment (v23-0001-Simplify-vacuum-visibility-assertion.patch) at 2025-12-03 23:07:38 from Melanie Plageman <melanieplageman at gmail.com> (Patch: Yes)
    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
2026-01-28 23:35:37 CFbot Patch does not need rebase anymore
2026-01-28 15:28:39 CFbot Patch needs rebase
2026-01-09 17:17:03 Kirill Reshke (reshke) Added reshke as reviewer
2025-12-04 05:31:33 CFbot Patch does not need rebase anymore
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