Block Range Index
E427690
Block Range Index is a compact PostgreSQL index type that summarizes ranges of table blocks to speed up queries on large, naturally ordered datasets while using minimal storage.
All labels observed (1)
| Label | Occurrences |
|---|---|
| Block Range Index canonical | 2 |
How this entity was disambiguated
This entity first appeared as the object of triple T4279438 — resolving that mention is where its identity was fixed. The disambiguator weighed these candidate entities and picked the highlighted one (or “None”, minting a new entity). This is how homonymy is resolved: the same surface form can point to different entities.
NED1
Entity disambiguation (via context triple)
gpt-5-mini-2025-08-07
Target entity: Block Range Index Context triple: [BRIN, fullName, Block Range Index]
-
A.
B-tree
A B-tree is a self-balancing tree data structure that maintains sorted data and allows efficient insertion, deletion, and search operations, commonly used to implement database indexes.
-
B.
Boundary Ranges
Boundary Ranges are a major subrange of the Coast Mountains spanning the border region between southeastern Alaska and northwestern British Columbia, known for their rugged, glaciated peaks and remote wilderness.
-
C.
Merkle tree
A Merkle tree is a cryptographic data structure that uses a tree of hash values to efficiently and securely verify the integrity and consistency of large sets of data.
-
D.
Block 1B
Block 1B is an upgraded configuration of NASA’s Space Launch System designed to carry heavier payloads and support crewed deep-space missions beyond low Earth orbit.
-
E.
Block 1
Block 1 is the initial operational configuration of NASA’s Space Launch System heavy-lift rocket, designed to carry the Orion spacecraft and payloads beyond low Earth orbit for early Artemis missions.
- F. None of above. chosen
- G. Unsure - the case is ambiguous/there is not enough information to decide.
NED2
Entity disambiguation (via description)
gpt-5-mini-2025-08-07
Target entity: Block Range Index Target entity description: Block Range Index is a compact PostgreSQL index type that summarizes ranges of table blocks to speed up queries on large, naturally ordered datasets while using minimal storage.
-
A.
B-tree
A B-tree is a self-balancing tree data structure that maintains sorted data and allows efficient insertion, deletion, and search operations, commonly used to implement database indexes.
-
B.
Boundary Ranges
Boundary Ranges are a major subrange of the Coast Mountains spanning the border region between southeastern Alaska and northwestern British Columbia, known for their rugged, glaciated peaks and remote wilderness.
-
C.
Merkle tree
A Merkle tree is a cryptographic data structure that uses a tree of hash values to efficiently and securely verify the integrity and consistency of large sets of data.
-
D.
Block 1B
Block 1B is an upgraded configuration of NASA’s Space Launch System designed to carry heavier payloads and support crewed deep-space missions beyond low Earth orbit.
-
E.
Block 1
Block 1 is the initial operational configuration of NASA’s Space Launch System heavy-lift rocket, designed to carry the Orion spacecraft and payloads beyond low Earth orbit for early Artemis missions.
- F. None of above. chosen
Statements (46)
| Predicate | Object |
|---|---|
| instanceOf |
PostgreSQL index type
ⓘ
database index structure ⓘ |
| abbreviation | BRIN ⓘ |
| accessMethodName | brin ⓘ |
| advantage |
fast index creation
ⓘ
good for very large tables ⓘ low maintenance overhead ⓘ much smaller than B-tree indexes ⓘ |
| benefitsFrom | correlation between indexed column and physical row order ⓘ |
| category | indexing and search ⓘ |
| designedFor |
large tables
ⓘ
naturally ordered datasets ⓘ |
| documentationURL | https://www.postgresql.org/docs/current/brin.html ⓘ |
| granularity | block ranges ⓘ |
| hasProperty |
compact
ⓘ
minimal storage usage ⓘ space-efficient ⓘ summarizes table block ranges ⓘ |
| implementedAs | access method in PostgreSQL ⓘ |
| introducedInVersion | PostgreSQL 9.5 ⓘ |
| notRecommendedFor |
highly random data distributions
ⓘ
small tables ⓘ |
| operatesOn | table blocks ⓘ |
| optimizes |
queries on large tables
ⓘ
range queries ⓘ |
| rangeSizeConfigurable | true ⓘ |
| requires | VACUUM or autovacuum to maintain visibility map ⓘ |
| stores |
all-equal flags per block range
ⓘ
maximum values per block range ⓘ minimum values per block range ⓘ nulls presence flags per block range ⓘ summary information about block ranges ⓘ |
| supports |
append-only workloads
ⓘ
log-like tables ⓘ multi-column indexes ⓘ parallel index scans ⓘ partial indexes ⓘ sequentially correlated data ⓘ time-series data ⓘ |
| supportsOperatorClassesFor |
array data types
ⓘ
geometric data types ⓘ network address data types ⓘ scalar data types ⓘ |
| tradeOff |
less precise than B-tree indexes
ⓘ
may scan more pages than B-tree ⓘ |
| usedIn | PostgreSQL NERFINISHED ⓘ |
How these facts were elicited
The pipeline generated the facts above by prompting gpt-5.1 with this entity's name + description and the instruction below.
Instruction
You are a knowledge base construction expert. Given a subject entity and a description of it, return factual statements that you know for the subject as a JSON list of dictionaries(triples), where keys must be "subject", "predicate" and "object". The number of facts may be very high, between 25 to 50 or more, for very popular subjects. For less popular subjects, the number of facts can be very low, like 5 or 10. # Requirements - If you don't know the subject at all, return an empty list. - If the subject is not a named entity, return an empty list. - Include at least one triple where predicate is "instanceOf". - Do not get too wordy. - Separate several objects into multiple triples with one object.
Input
Subject: Block Range Index Description of subject: Block Range Index is a compact PostgreSQL index type that summarizes ranges of table blocks to speed up queries on large, naturally ordered datasets while using minimal storage.
Referenced by (2)
Full triples — surface form annotated when it differs from this entity's canonical label.