BRIN
E97114
BRIN (Block Range Index) is a lightweight PostgreSQL index type optimized for very large tables by summarizing ranges of physical data blocks instead of indexing every individual row.
All labels observed (1)
| Label | Occurrences |
|---|---|
| BRIN canonical | 2 |
How this entity was disambiguated
This entity first appeared as the object of triple T816975 — 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: BRIN Context triple: [PostgreSQL, supportsIndexType, BRIN]
-
A.
Brin
Brin is a surname most prominently associated with Sergey Brin, the co-founder of Google and a leading figure in the technology industry.
-
B.
BR
BR is the upper house of Austria’s parliament, representing the federal states in the legislative process.
-
C.
BR2
BR2 is a UK postcode district covering parts of Hayes and surrounding areas in the London Borough of Bromley in southeast England.
-
D.
Bing
Bing is Microsoft's web search engine that provides internet search, image, video, and mapping services.
-
E.
BdM
BdM is the central bank of Mexico, responsible for maintaining the country’s monetary stability and issuing its currency.
- 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: BRIN Target entity description: BRIN (Block Range Index) is a lightweight PostgreSQL index type optimized for very large tables by summarizing ranges of physical data blocks instead of indexing every individual row.
-
A.
Brin
Brin is a surname most prominently associated with Sergey Brin, the co-founder of Google and a leading figure in the technology industry.
-
B.
BR
BR is the upper house of Austria’s parliament, representing the federal states in the legislative process.
-
C.
BR2
BR2 is a UK postcode district covering parts of Hayes and surrounding areas in the London Borough of Bromley in southeast England.
-
D.
Bing
Bing is Microsoft's web search engine that provides internet search, image, video, and mapping services.
-
E.
BdM
BdM is the central bank of Mexico, responsible for maintaining the country’s monetary stability and issuing its currency.
- F. None of above. chosen
Statements (56)
| Predicate | Object |
|---|---|
| instanceOf | PostgreSQL index type ⓘ |
| abbreviationOf | Block Range Index ⓘ |
| benefit |
faster index creation on huge tables
ⓘ
lower maintenance overhead ⓘ reduced storage requirements ⓘ |
| category | block-range index ⓘ |
| contrastedWith |
B-tree index
ⓘ
GIN index ⓘ GiST index ⓘ GiST ⓘ
surface form:
SP-GiST index
|
| definedIn | PostgreSQL documentation ⓘ |
| designedFor | very large tables ⓘ |
| doesNotIndex | every individual row ⓘ |
| fullName | Block Range Index ⓘ |
| implementedIn |
PostgreSQL
ⓘ
surface form:
PostgreSQL core
|
| indexes | ranges of physical data blocks ⓘ |
| indexingStrategy | block range summarization ⓘ |
| indexSize | very small compared to B-tree ⓘ |
| introducedInVersion | PostgreSQL 9.5 ⓘ |
| limitation |
less selective than B-tree for random data
ⓘ
performance degrades if data is not physically correlated ⓘ |
| optimizedFor |
append-only workloads
ⓘ
log tables ⓘ tables with natural physical ordering ⓘ time-series data ⓘ |
| parameter |
autosummarize
ⓘ
autovacuum settings ⓘ pages_per_range ⓘ |
| partOf | PostgreSQL ⓘ |
| sqlSyntaxExample | CREATE INDEX idx ON table USING brin(column); ⓘ |
| stores | summary tuples per block range ⓘ |
| summaryIncludes |
maximum values
ⓘ
minimum values ⓘ null presence information ⓘ other aggregate metadata ⓘ |
| supports |
CLUSTER
ⓘ
REINDEX ⓘ VACUUM ⓘ custom operator classes ⓘ equality queries ⓘ index-only scans ⓘ multi-column indexes ⓘ operator classes ⓘ parallel index scans ⓘ partitioned tables ⓘ pg_dump and pg_restore ⓘ range queries ⓘ |
| supportsDataTypes |
boolean
ⓘ
date and time types ⓘ geometric types ⓘ network address types ⓘ numeric types ⓘ text types ⓘ |
| tradeoff | lower index size vs less precise lookups ⓘ |
| useCase |
historical archival tables
ⓘ
large fact tables in data warehouses ⓘ |
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: BRIN Description of subject: BRIN (Block Range Index) is a lightweight PostgreSQL index type optimized for very large tables by summarizing ranges of physical data blocks instead of indexing every individual row.
Referenced by (2)
Full triples — surface form annotated when it differs from this entity's canonical label.