We can't find the internet
Attempting to reconnect
Something went wrong!
Hang in there while we get back on track
BRIN improvements and new opclasses: Tomas Vondra - PGCon 2023
"Discover how Brin indexes, a new indexing method, can accelerate range queries and improve query speed by eliminating unnecessary data. Learn about the benefits and uses of Brin indexes in this informative conference talk."
- Brin indexes can improve query speed by eliminating a large portion of the table from consideration
- Brin indexes use a combination of bloom filters and bitmaps to accelerate range queries
- Brin indexes are particularly well-suited for queries with monotonic data, such as timestamp ranges
- Brin indexes can reduce the size of the B-tree index by eliminating unnecessary data
- Brin indexes can be used for sorting and filtering data
- Brin indexes can improve query speed by using a combination of bloom filters and bitmaps to accelerate range queries
- Brin indexes are not widely used because they are relatively new and require significant changes to the database
- Brin indexes can be used in combination with other indexing methods, such as B-trees and hash indexes
- Brin indexes can improve query speed by reducing the number of disk reads required to answer a query