The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/14/btree-implementation.html
Description:
on this url 64.4.2. Bottom-up Index Deletion,
https://www.postgresql.org/docs/14/btree-implementation.html#BTREE-DELETION
Would be nice to add a note: old tuple versions in the index referencing the
same logical row cannot be deleted by bottom up index deletion process when
older transactions that might require the old state the row are still
running That is what the LP_DEAD bit is for I believe?
hopefully my understanding is correct.
