Conference 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.

Speaker

Tomas Vondra