Schedule - PGDay UK 2023

BRIN improvements and new opclasses

Date: 2023-09-12
Time: 14:40–15:30
Room: Council Chamber
Level: Intermediate
Feedback: Leave feedback

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. In the first half of the talk I'll briefly explain how BRIN indexes work, and how the improvements in PG14 and PG16 (minmax-multi and bloom opclasses and HOT improvements) improve some of the use cases. In the second half I'll talk about improvement we're currently working on - using BRIN for sorting, better handling of ARRAY queries, etc. I'll also present a couple ideas that might be a good topic for patches and research.

Speaker

Tomas Vondra