#PostgreSQL 14 B-Tree Index: Reduced Bloat with Bottom-Up Deletion
#Percona #opensource #databases
https://www.percona.com/blog/postgresql-14-b-tree-index-reduced-bloat-with-bottom-up-deletion/
#Percona #opensource #databases
https://www.percona.com/blog/postgresql-14-b-tree-index-reduced-bloat-with-bottom-up-deletion/
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.Hamid Akthar (Percona Database Performance Blog)