iframe-proxy | Sunbelt Computer Software

ID

Title

Eliminate xl_heap_visible to reduce vacuum and COPY FREEZE WAL volume

CI (CFBot)

Needs rebase! Needs rebase sinceÂ 2Â months. Failing sinceÂ 2Â months.
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 (2Â monthsÂ ago)

Latest email

2026-04-06 15:32:03 (2Â monthsÂ ago)

Status

PG19-Final (2026-03-01 â€“ 2026-04-09): 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-04-06 15:32:03 by Alexey Makhmutov <a.makhmutov at postgrespro.ru>
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

Sunbelt Computer Software

PL/B Language Development and Support

Eliminate xl_heap_visible to reduce vacuum and COPY FREEZE WAL volume

Open statuses

Closed statuses

Move to

Open statuses

Closed statuses

Move to