Schedule - PGConf.EU 2022
BRIN improvements and new opclasses
Date: 2022-10-26
Time: 12:10–13:00
Room: Berlin 1
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 plan to talk about multiple BRIN improvements that might get into future versions.
Slides
The following slides have been made available for this session: