Eliminate xl_heap_visible to reduce vacuum and COPY FREEZE WAL volume

Title

CI (CFBot)

Summary

Stats (from CFBot)

Patch version: v6, Patch count: 20, First patch: +132−23, All patches: +1479−965

Topic

Performance

Tags

Created

2025-06-23 21:42:46

Last modified

2025-08-01 21:45:30 (2 weeks ago)

Latest email

2025-08-01 21:36:19 (2 weeks ago)

Status

PG19-2 (2025-09-01 - 2025-09-30): Needs review

PG19-1 (2025-07-01 - 2025-07-31): Moved to different CF

Target version

Authors

Melanie Plageman (melanieplageman)

Reviewers

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-08-01 21:36:19 by Melanie Plageman <melanieplageman at gmail.com>
Latest 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>
    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-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