A Block Range Index or BRIN is a database indexing technique. They are intended to improve performance with extremely large[i] tables.
BRIN indexes provide similar benefits to horizontal partitioning or sharding but without needing to explicitly declare partitions.[1]
A BRIN is applicable to an index on a table that is large and where the index key value is easily sorted and evaluated with a MinMax function.[ii]
BRIN were originally proposed by Alvaro Herrera of 2ndQuadrant in 2013 as 'Minmax indexes'.[2] Implementations thus far are tightly coupled to internal implementation and storage techniques for the database tables. This makes them efficient, but limits them to particular vendors. So far PostgreSQL is the only vendor to have announced a live product with this specific feature, in PostgreSQL 9.5.[3][4] Other vendors have described some similar features,[2] including Oracle,[5][6] Netezza 'zone maps',[7] Infobright 'data packs',[8] MonetDB[9] and Apache Hive with ORC/Parquet.[10]
Cite error: There are <ref group=lower-roman> tags or {{efn-lr}} templates on this page, but the references will not show without a {{reflist|group=lower-roman}} template or {{notelist-lr}} template (see the help page).
^Mark Wong (October 10, 2014). "Loading Tables and Creating B-tree and Block Range Indexes". AXLE project.
A BlockRangeIndex or BRIN is a database indexing technique. They are intended to improve performance with extremely large tables. BRIN indexes provide...
than one non-clustered index on a database table. Clustering alters the data block into a certain distinct order to match the index, resulting in the row...
newest block in the index in order to add the new value. If many users attempt to insert at the same time, they all must write to that block and have...
distributions, radiation with a UV index of 12 is twice as intense as radiation at a UV index of 6. For a wide range of timescales, sunburn in response...
boxes, or other symbols. Mathematical Alphanumeric Symbols is a Unicode block comprising styled forms of Latin and Greek letters and decimal digits that...
Dynamical Systems or Brin Prize, a mathematics award BlockRangeIndex (BRIN), a database indexing technique Brin Londo, the DC Comics superhero Timber...
is sargable. It can use an index to find all the myNameField values that start with the substring 'Jimmy'. BlockRangeIndex Query optimization ^1 Gulutzan...
which blocks are A blocks and which are B blocks. When an A block at index i is swapped with a B block at index j (where the first evenly sized A block is...
(SP-GiST) and BlockRangeIndexes (BRIN). In addition, user-defined index methods can be created, although this is quite an involved process. Indexes in PostgreSQL...
Russell 3000 Index Russell 2000 Index "Market capitalization Ranges". FTSE Russell. "Russell 1000 (^RUI)". Retrieved December 8, 2021. "Index factsheet"...
The Perceptual Organization Index (POI) included: Block Design Matrix Reasoning Picture Completion The Processing Speed Index (PSI) included: Digit Symbol-Coding...
minimization, large block trading or patient/flexible trading strategies that allow for greater tracking error but lower market impact costs. Index funds may also...
Range Rover, generally shortened to Range Rover, is a 4x4 luxury SUV produced by Land Rover, a marque and sub-brand of Jaguar Land Rover. The Range Rover...
the value of 100. The viscosity index of synthetic oils ranges from 80 to over 400.[citation needed] The viscosity index can be calculated using the following...
programming table B is O(n log n). The value of B[i, j] is the index of the minimum of the range A[i…i+2j-1]. Filling the table takes time O(n log n), with...
(IBerian IndEX) is the benchmark stock market index of the Bolsa de Madrid, Spain's principal stock exchange. Initiated in 1992, the index is administered...
Santa Ana Mountains, Temescal Mountains, and other mountains and ranges of the Perris Block, San Jacinto Mountains, and Laguna Mountains of southern California...
In descriptive statistics, the interquartile range (IQR) is a measure of statistical dispersion, which is the spread of the data. The IQR may also be...
the memory block, it can only occupy a single cache line. The cache can be framed as a n × 1 column matrix. The set is determined by the index bits derived...
an index, as part of a system's self-maintenance activities. When a portion of an index is locked by a transaction, other transactions may be blocked from...