BRIN indexes
Postgres FM
00:00
Performance of BRIN Index vs B3 Index
The chapter analyzes the performance of the BRIN index compared to the B3 index in PostgreSQL. The speakers share their experiences of finding B3 indexes to perform better, especially for point searches. They discuss the importance of considering buffer hits and reads when discussing timing and emphasize the need for indexes to reduce I/O operations.
Transcript
Play full episode
