BRIN indexes

GPTKB entity

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