Statements (32)
Predicate | Object |
---|---|
gptkbp:instanceOf |
database index type
|
gptkbp:canBe |
automatically summarized
created concurrently dropped without locking the table manually summarized used with partitioned tables |
gptkbp:contrastsWith |
gptkb:B-tree_indexes
|
gptkbp:designedFor |
large tables
|
gptkbp:doNotSupport |
fast point lookups
|
gptkbp:efficientFor |
columns with natural ordering
|
gptkbp:heldBy |
fast to build
faster to scan than full table scan in some cases less precise than B-tree indexes lossy indexes space efficient suitable for append-only tables suitable for geospatial data suitable for large fact tables suitable for log data suitable for time-series data maintained automatically during inserts and updates |
https://www.w3.org/2000/01/rdf-schema#label |
BRIN indexes
|
gptkbp:introducedIn |
gptkb:PostgreSQL_9.5
|
gptkbp:numberOfLocations |
summary information about block ranges
|
gptkbp:requires |
rechecking of rows
|
gptkbp:standsFor |
Block Range Indexes
|
gptkbp:supports |
range queries
custom operator classes multi-column indexes |
gptkbp:usedIn |
gptkb:PostgreSQL
|
gptkbp:bfsParent |
gptkb:PostgreSQL
|
gptkbp:bfsLayer |
5
|