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.
