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 19 hours. Failing since 2 days.
Additional links previous successfully applied patch (outdated):
Summary
Stats (from CFBot) Unknown
Tags Performance
Created 2025-06-23 21:42:46
Last modified 2026-03-31 13:45:33 (15 hours ago)
Latest email 2026-03-31 22:55:54 (5 hours ago)
Status
PG19-Final (2026-03-01 – 2026-03-31): Committed
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-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 Melanie Plageman (melanieplageman)
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-03-31 22:55:54 by Melanie Plageman <melanieplageman at gmail.com>
Latest attachment (v1-0001-Use-foreach_int-foreach_node-for-resultRelationRe.patch) at 2026-03-31 16:19:20 from Melanie Plageman <melanieplageman at gmail.com>
    Attachment (v1-0001-Use-foreach_int-foreach_node-for-resultRelationRe.patch) at 2026-03-31 16:19:20 from Melanie Plageman <melanieplageman at gmail.com> (Patch: Yes)
    Attachment (v48-0001-Make-it-cheap-to-check-if-a-relation-is-modified.patch) at 2026-03-29 17:16:39 from Melanie Plageman <melanieplageman at gmail.com> (Patch: Yes)
    Attachment (v47-0001-Make-it-cheap-to-check-with-relations-are-modifi.patch) at 2026-03-27 19:17:45 from Melanie Plageman <melanieplageman at gmail.com> (Patch: Yes)
    Attachment (v46-0001-Track-which-relations-are-modified-by-a-query.patch) at 2026-03-25 23:14:17 from Melanie Plageman <melanieplageman at gmail.com> (Patch: Yes)
    Attachment (v45-0001-Track-which-relations-are-modified-by-a-query.patch) at 2026-03-24 23:44:24 from Melanie Plageman <melanieplageman at gmail.com> (Patch: Yes)
    Attachment (v44-0001-Use-GlobalVisState-in-vacuum-to-determine-page-l.patch) at 2026-03-23 21:54:13 from Melanie Plageman <melanieplageman at gmail.com> (Patch: Yes)
    Attachment (v43-0001-Use-GlobalVisState-in-vacuum-to-determine-page-l.patch) at 2026-03-22 19:58:27 from Melanie Plageman <melanieplageman at gmail.com> (Patch: Yes)
    Attachment (v42-0001-Fix-visibility-map-corruption-in-more-cases.patch) at 2026-03-20 23:37:08 from Melanie Plageman <melanieplageman at gmail.com> (Patch: Yes)
    Attachment (v41-0001-Fix-visibility-map-corruption-in-more-cases.patch) at 2026-03-20 02:38:47 from Melanie Plageman <melanieplageman at gmail.com> (Patch: Yes)
    Attachment (v40-0001-Fix-visibility-map-corruption-in-more-cases.patch) at 2026-03-17 14:48:55 from Melanie Plageman <melanieplageman at gmail.com> (Patch: Yes)
    Attachment (v39-0001-Fix-visibility-map-corruption-in-more-cases.patch) at 2026-03-16 14:53:32 from Melanie Plageman <melanieplageman at gmail.com> (Patch: Yes)
    Attachment (v38-0001-Fix-visibility-map-corruption-in-more-cases.patch) at 2026-03-15 19:10:54 from Melanie Plageman <melanieplageman at gmail.com> (Patch: Yes)
    Attachment (v37-0001-Save-vmbuffer-in-heap-specific-scan-descriptors-.patch) at 2026-03-11 17:01:36 from Melanie Plageman <melanieplageman at gmail.com> (Patch: Yes)
    Attachment (v36-0001-Use-the-newest-to-be-frozen-xid-as-the-conflict-.patch) at 2026-03-06 23:33:10 from Melanie Plageman <melanieplageman at gmail.com> (Patch: Yes)
    Attachment (v35-0001-Move-commonly-used-context-into-PruneState-and-s.patch) at 2026-03-02 23:38:07 from Melanie Plageman <melanieplageman at gmail.com> (Patch: Yes)
    Attachment (v1-0001-Create-test-tables-as-temporary-to-avoid-autovacu.patch) at 2026-01-31 05:09:35 from Kirill Reshke <reshkekirill at gmail.com> (Patch: Yes)
    Attachment (v1-0001-Reimplement-regression-tests-from-21796c267-as-TA.patch) at 2026-01-30 09:59:57 from Kirill Reshke <reshkekirill at gmail.com> (Patch: Yes)
    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-03-31 13:45:33 Melanie Plageman (melanieplageman) Closed in commitfest PG19-Final with status: Committed
2026-03-31 13:45:33 Melanie Plageman (melanieplageman) Changed committer to melanieplageman
2026-03-31 09:21:31 CFbot Patch needs rebase
2026-03-25 23:32:41 CFbot Patch does not need rebase anymore
2026-03-25 00:09:33 CFbot Patch needs rebase
2026-03-23 22:07:43 CFbot Patch does not need rebase anymore
2026-03-22 20:20:35 CFbot Patch needs rebase
2026-03-20 03:10:40 CFbot Patch does not need rebase anymore
2026-03-19 13:08:38 CFbot Patch needs rebase
2026-03-17 15:18:42 CFbot Patch does not need rebase anymore
2026-03-15 19:32:41 CFbot Patch needs rebase
2026-02-01 00:00:08 CFbot Moved from CF PG19-4 to CF PG19-Final
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