BRIN indexes
Postgres FM
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.
00:00
Transcript
Play full episode
Remember Everything You Learn from Podcasts
Save insights instantly, chat with episodes, and build lasting knowledge - all powered by AI.
