Documentation / Storage Parameters / BRIN indexes
pages_per_range
pages_per_range
Defines the number of table blocks that make up one block range for each entry of a BRIN index (see Section 65.5.1 for more details). The default is 128 .
Reading PostgreSQL 18.6.
Description
Defines the number of table blocks that make up one block range for each entry of a BRIN index (see Section 65.5.1 for more details). The default is 128 .
- Applies to
- BRIN indexes
- Value type
- integer
- Default
- 128
Usage
WITH (pages_per_range = value)Index access method
This entry applies to BRIN indexes. Set it with CREATE INDEX WITH or ALTER INDEX SET. Read defaults and behavior for this specific access method.
Related entries
Documentation and source
Source build
- Version
- 18.6
- Build
- Local English manual 18.6
- Source fingerprint
eb6c2292fdf28e1b4635ab478eec3919411cdf4a6c07553387870e26201f3744
Related entries
autosummarizeautosummarize
Back to Storage Parameters · Recorded in PostgreSQL 10 through 20; the first sample is not necessarily its introduction.