hamidakhtar

4 ms·

1. 1.▲
   by hamidakhtar 4y ago

   Reduction in index size due to bottom deletion is a huge plus in PostgreSQL version 14. Btree indexes have a mechanism where plain index scans set the LP_DEAD flag. This is not set for bitmap index scans though. Once this is set, the space
2. 2.▲
   PostgreSQL 14 B-Tree Index: Reduced Bloat with Bottom-Up Deletion(percona.com)

   1 points by hamidakhtar 4y ago|1 comments
3. 3.▲
   by hamidakhtar 5y ago

   Great tool for database observability.