Date: 2023-06-01
Time: 11:00–11:45
Room: DMS 1120
Level: Intermediate
PostgreSQL supports BRIN indexes since version 9.5, allowing you to create very efficient (very small and still providing good performance) indexes. But BRIN indexes have a couple inherent limitations, making them less useful on poorly correlated data. PostgreSQL 14 includes a couple improvements and new opclasses, aiming to address some of those issues (at least partially), which is what most of this talk is about - I'll introduce the minmax-multi and bloom opclasses, show how it helps, etc.
I also plan to talk about a couple BRIN improvements that might get into future versions, some of which might be suitable for people looking for ideas for their first patch.