Re: eliminate xl_heap_visible to reduce WAL (and eventually set VM on-access)
Melanie Plageman <melanieplageman@gmail.com>
Commits
GET /api/v1/messages/:b64id/commits
the thread's linked commits as JSON, with link sources.
API reference →
-
Remove table_scan_analyze_next_tuple unneeded parameter OldestXmin
- 284925508ae6 19 (unreleased) landed
-
Simplify visibility check in heap_page_would_be_all_visible()
- 3efe58febc3c 19 (unreleased) landed
-
Eliminate use of cached VM value in lazy_scan_prune()
- 648a7e28d7c2 19 (unreleased) landed
-
Combine visibilitymap_set() cases in lazy_scan_prune()
- 21796c267d0a 19 (unreleased) landed
-
Fix const qualification in prune_freeze_setup()
- 4877391ce894 19 (unreleased) landed
-
Simplify vacuum visibility assertion
- bd298f54a0d6 19 (unreleased) landed
-
Split heap_page_prune_and_freeze() into helpers
- e135e044572e 19 (unreleased) landed
-
Assert that cutoffs are provided if freezing will be attempted
- cd38b7e77315 19 (unreleased) landed
-
Split PruneFreezeParams initializers to one field per line
- 1e14edcea5e1 19 (unreleased) landed
-
Refactor heap_page_prune_and_freeze() parameters into a struct
- 1937ed70621e 19 (unreleased) landed
-
Make heap_page_is_all_visible independent of LVRelState
- 3e4705484e0c 19 (unreleased) landed
-
Inline TransactionIdFollows/Precedes[OrEquals]()
- 43b05b38ea4d 19 (unreleased) landed
-
Add helper for freeze determination to heap_page_prune_and_freeze
- c8dd6542bae4 19 (unreleased) landed
-
Bump XLOG_PAGE_MAGIC after xl_heap_prune change
- 4a8fb58671d3 19 (unreleased) landed
-
Correct prune WAL record opcode name in comment
- ae8ea7278c16 19 (unreleased) landed
-
Add error codes when vacuum discovers VM corruption
- 8ec97e78a771 19 (unreleased) landed
-
Remove unused xl_heap_prune member, reason
- 4b5f206de2bb 19 (unreleased) landed
-
Remove unneeded VM pin from VM replay
- 3399c265543e 19 (unreleased) landed
-
Add assert and log message to visibilitymap_set
- e3d5ddb7ca91 19 (unreleased) landed
-
Add error codes to some corruption log messages
- fd6ec93bf890 13.0 cited
Attachments
- v2-0002-Introduce-unlogged-versions-of-VM-functions.patch (text/x-patch) patch v2-0002
- v2-0001-Introduce-heap-specific-wrapper-for-visibilitymap.patch (text/x-patch) patch v2-0001
- v2-0004-Make-heap_page_is_all_visible-independent-of-LVRe.patch (text/x-patch) patch v2-0004
- v2-0005-Eliminate-xl_heap_visible-from-vacuum-phase-III.patch (text/x-patch) patch v2-0005
- v2-0003-Eliminate-xl_heap_visible-in-COPY-FREEZE.patch (text/x-patch) patch v2-0003
- v2-0008-Combine-vacuum-phase-I-VM-update-cases.patch (text/x-patch) patch v2-0008
- v2-0007-Combine-lazy_scan_prune-VM-corruption-cases.patch (text/x-patch) patch v2-0007
- v2-0009-Find-and-fix-VM-corruption-in-heap_page_prune_and.patch (text/x-patch) patch v2-0009
- v2-0010-Update-VM-in-pruneheap.c.patch (text/x-patch) patch v2-0010
- v2-0006-Use-xl_heap_prune-record-for-setting-empty-pages-.patch (text/x-patch) patch v2-0006
- v2-0011-Eliminate-xl_heap_visible-from-vacuum-phase-I-pru.patch (text/x-patch) patch v2-0011
- v2-0012-Remove-xl_heap_visible-entirely.patch (text/x-patch) patch v2-0012
On Mon, Jun 23, 2025 at 4:25 PM Melanie Plageman <melanieplageman@gmail.com> wrote: > > The attached patch set eliminates xl_heap_visible, the WAL record > emitted when a block of the heap is set all-visible/frozen in the > visibility map. Instead, it includes the information needed to update > the VM in the WAL record already emitted by the operation modifying > the heap page. Rebased in light of recent changes on master: 0001: cleanup 0002: preparatory work 0003: eliminate xl_heap_visible for COPY FREEZE 0004 - 0005: eliminate xl_heap_visible for vacuum's phase III 0006: eliminate xl_heap_visible for vacuum phase I empty pages 0007 - 0010: preparatory refactoring 0011: eliminate xl_heap_visible from vacuum phase I prune/freeze 0012: remove xl_heap_visible - Melanie