PostgreSQL BRIN Indexes: When & How to Use Block Range Indexes

PostgreSQL BRIN Indexes: When & How to Use Block Range Indexes I recently replaced a 14 GB B-tree index with a 90 KB BRIN index on a time-series table. Same query, same results, 99.9% less disk usage. Insert performance improved by 15% because the BR...