Postgres FM

BRIN indexes

Jul 21, 2022
The podcast discusses the importance of BRIN indexes in Postgres and compares their performance to B-tree indexes. The concept of correlation in indexes is explored, along with the use of hidden column CTID to determine correlation. The podcast also emphasizes the need for indexes to reduce I/O operations and highlights the potential of the improved BRIN index for UID versions data. Additionally, the importance of row numbers and upgrade recommendations are discussed.
Ask episode
Chapters
Transcript
Episode notes
1
Introduction
00:00 • 3min
2
The Importance of Subscribing and BRIN Indexes in Postgres
03:15 • 7min
3
Correlation in Indexes and Hidden Column CTID
10:11 • 9min
4
Performance of BRIN Index vs B3 Index
18:52 • 13min
5
Exploring the Use of UID Versions and the Potential of the Improved Brain Index
31:22 • 2min
6
Importance of Row Numbers and Upgrade Recommendations
33:42 • 2min