Hello, Peter. > * Instead of avoiding the FPI when this happens, proactively call > _bt_simpledel_pass() just before _bt_killitems() returns. Accept the > immediate cost of setting an LP_DEAD bit, just like today, but avoid > repeated FPIs.
Hm, not sure here AFAIK current implementation does not produce repeated FPIs. Page is marked as dirty on the first bit. So, others LP_DEAD (if not set by single scan) do not generate FPI until checkpoint is ready. Also, the issue affects GITS and HASH indexes and HEAP pages. Best regards, Michail.
