Update FSM in COPY FREEZE replay d96f87332b3 folded COPY FREEZE visibility map updates into XLOG_HEAP2_MULTI_INSERT records. Unlike the former XLOG_HEAP2_VISIBLE redo path, multi-insert redo only updated the FSM when the record did not contain a heap page FPI and the heap page had less than 20% free space.
This can leave all-frozen pages with missing or stale FSM entries on a standby. After promotion, vacuum will skip those pages, preventing their free space from being discovered. When a multi-insert record sets the page all-frozen, record the heap page's free space unconditionally. Reported-by: Melanie Plageman <[email protected]> Discussion: https://postgr.es/m/CAAKRu_bS3nfMJCF2fjE%2Bceb5-t%3D2p_VPMk2PWuVomrOFxg5DGQ%40mail.gmail.com Backpatch-through: 19 Branch ------ REL_19_STABLE Details ------- https://git.postgresql.org/pg/commitdiff/f4b511ae93a587982ac025c7a2512586fe87489d Modified Files -------------- src/backend/access/heap/heapam_xlog.c | 46 ++++++++++++++++++++++++----------- 1 file changed, 32 insertions(+), 14 deletions(-)
