PostgreSQL 14 B-Tree Index: Reduced Bloat with Bottom-Up Deletion

Bottom-up deletion is done during an index operation when a “version churn page split” is anticipated. Obsolete versions of logically unchanged index tuples are removed making space on the page for the newer version.