Eliminate COPY FREEZE use of XLOG_HEAP2_VISIBLE
Melanie Plageman <melanieplageman@gmail.com>
Author:
Melanie Plageman <melanieplageman@gmail.com>
Date: 2025-10-09T20:29:01Z
Releases:
19 (unreleased)
Eliminate COPY FREEZE use of XLOG_HEAP2_VISIBLE Instead of emitting a separate WAL XLOG_HEAP2_VISIBLE record for setting bits in the VM, specify the VM block changes in the XLOG_HEAP2_MULTI_INSERT record. This halves the number of WAL records emitted by COPY FREEZE. Author: Melanie Plageman <melanieplageman@gmail.com> Reviewed-by: Andres Freund <andres@anarazel.de> Reviewed-by: Robert Haas <robertmhaas@gmail.com> Reviewed-by: Kirill Reshke <reshkekirill@gmail.com> Discussion: https://postgr.es/m/flat/CAAKRu_ZMw6Npd_qm2KM%2BFwQ3cMOMx1Dh3VMhp8-V7SOLxdK9-g%40mail.gmail.com
Files
| Path | Change | +/− |
|---|---|---|
| src/backend/access/heap/heapam.c | modified | +27 −16 |
| src/backend/access/heap/heapam_xlog.c | modified | +48 −1 |
| src/backend/access/heap/visibilitymap.c | modified | +69 −1 |
| src/backend/access/rmgrdesc/heapdesc.c | modified | +6 −0 |
| src/include/access/visibilitymap.h | modified | +4 −0 |
Discussion
Cited messages not in the archive:
flat/CAAKRu_ZMw6Npd_qm2KM+FwQ3cMOMx1Dh3VMhp8-V7SOLxdK9-g@mail.gmail.com