{"Entry":{"collection":"relopts","key":"brin-pages-per-range","name":"pages_per_range","aliases":["brin.pages_per_range"],"metadata":{"aliases":["brin.pages_per_range"],"category":"BRIN indexes","content_hash":"3f36d5dab3b22c5459404aecf91882e2aa4a5aceb6342650524ce746e4df7cdb","imported_at":"2026-09-30T17:44:22.121011+08:00","name":"pages_per_range","name_zh":"pages_per_range","slug":"brin-pages-per-range","summary":"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 ."}},"Definition":{"Collection":"relopts","Key":"brin-pages-per-range","SourceDatabase":"center","Version":"18","SourceTable":"relopt","SourceKey":"brin-pages-per-range","SourceRevision":"eb6c2292fdf28e1b4635ab478eec3919411cdf4a6c07553387870e26201f3744","Facts":{"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 ."],"facts":[{"label":"Applies to","value":"BRIN indexes"},{"label":"Value type","value":"integer"},{"label":"Default","value":"128"}],"related":[{"label":"CREATE INDEX","url":"/wiki/sql/create-index/?v=18"}],"release":{"channel":"stable","label":"18.6","major":"18","ref":"Local English manual 18.6","revision":"eb6c2292fdf28e1b4635ab478eec3919411cdf4a6c07553387870e26201f3744"},"sections":[{"paragraphs":["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."],"title":"Index access method"}],"signature":"WITH (pages_per_range = value)","sources":[{"label":"PostgreSQL 18 English manual","path":"sql-createindex.html","sha256":"6aa00da55815d13d0355dd25cb1cdb603fa36964993f164d1b6f486011282580","url":"/docs/18/sql-createindex.html#INDEX-RELOPTION-PAGES-PER-RANGE"}]},"ManualEvidence":{"release":{"channel":"stable","label":"18.6","major":"18","ref":"Local English manual 18.6","revision":"eb6c2292fdf28e1b4635ab478eec3919411cdf4a6c07553387870e26201f3744"},"sources":[{"label":"PostgreSQL 18 English manual","path":"sql-createindex.html","sha256":"6aa00da55815d13d0355dd25cb1cdb603fa36964993f164d1b6f486011282580","url":"/docs/18/sql-createindex.html#INDEX-RELOPTION-PAGES-PER-RANGE"}]},"MeasuredEvidence":{}},"Text":{"Collection":"relopts","Key":"brin-pages-per-range","SourceDatabase":"center","Version":"18","Locale":"en","Title":"pages_per_range","Summary":"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 .","BodyHTML":"\u003cp\u003eDefines 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 .\u003c/p\u003e","SourceRevision":"eb6c2292fdf28e1b4635ab478eec3919411cdf4a6c07553387870e26201f3744","ContentHash":"9f0497c20a609c415864527fd7f9558039c6f58ecd85bedc80e5b42b4b6cea49","Payload":{"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 ."],"related":[{"label":"CREATE INDEX","url":"/wiki/sql/create-index/?v=18"}],"sections":[{"paragraphs":["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."],"title":"Index access method"}]}},"RequestedLocale":"zh-Hans","Fallback":true,"Versions":["10","11","12","13","14","15","16","17","18","19","20"],"Locales":["en"],"Signatures":null,"Spellings":null,"SQLState":null,"Evidence":null}