5mins of Postgres E14: HOT Updates vs Bottom-Up Index Deletion in Postgres 14 скачать в хорошем качестве

5mins of Postgres E14: HOT Updates vs Bottom-Up Index Deletion in Postgres 14

Today, we're going to talk about bottom-up index deletion for B-tree indexes, Postgres pages, Postgres page splits in B-Tree indexes, the bt_page_items function, and how Bottom-Up Index Deletions compare to HOT updates. Find the article on our blog here: https://pganalyze.com/blog/5mins-post... Learn more about pganalyze: https://pganalyze.com https://pganalyze.com/newsletter   / pganalyze   📑 What we have discussed in this episode of 5mins of Postgres: PostgreSQL 14 B-Tree Index: Reduced Bloat with Bottom-Up Deletion: https://www.percona.com/blog/postgres... Hamid Akhtar on Twitter:   / engineeredvirus   B-Tree Index Implementation Documentation: https://www.postgresql.org/docs/curre... HOT updates in PostgreSQL for better performance: https://www.cybertec-postgresql.com/e...