Statements (32)
| Predicate | Object |
|---|---|
| gptkbp:instanceOf |
gptkb: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 |
| 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 |
6
|
| https://www.w3.org/2000/01/rdf-schema#label |
BRIN indexes
|