{"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","derived_content_hash":"acd2dc8e48541a379708bcdd46a3cfd8cc2fcab21d6e764bb89337103335775a","imported_at":"2026-09-30T17:44:22.121011+08:00","name":"pages_per_range","name_zh":"pages_per_range","repair_provenance":{"original_source_revision":"","receipt_sha256":"9ad6aa78a1d01101b2788e7984ee6821bb2f2dfe5a2fcd49e2f47b3fb7cdb6d6","repair":"wiki-repair-20261023"},"slug":"brin-pages-per-range","source_rev":"wiki-repair-20261023:eb9680c0566a41cf86f86a6aea855238d99ca842b3f98f3a6cbf38f651983e6a","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 ."],"description_zh":"定义每个 BRIN 索引项对应的一个块范围由多少个表块组成（详见第 65.5.1 节）。默认值为 128。","description_zh_html":"\u003cp\u003e\n     定义每个 \u003cacronym class=\"acronym\"\u003eBRIN\u003c/acronym\u003e 索引项对应的一个块范围由多少个表块组成（详见\u003ca class=\"xref\" href=\"/zh/docs/18/brin.html#BRIN-INTRO\" title=\"65.5.1. 简介\"\u003e第 65.5.1 节\u003c/a\u003e）。默认值为 \u003ccode class=\"literal\"\u003e128\u003c/code\u003e。\n    \u003c/p\u003e","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"}],"translation_provenance":{"inputs":[{"kind":"current-pgdoc-translation","path":"/Users/vonng/pgsty/pgdoc/zh/18/html/sql-createindex.html","sha256":"ce2d5ba3eb6a7da215b754fefccac3a37794c6ec20de7eac0bf4f97034328d82"}],"kind":"same-version-pgdoc","locale":"zh-Hans","source_revision":"b1b500221dbe5437cfca004d6b04d3f6e422765d","version":"18"},"zh_from":"same-version-pgdoc"},"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":"en","Fallback":false,"Versions":["10","11","12","13","14","15","16","17","18","19","20"],"Locales":["en","zh-Hans"],"Signatures":null,"Spellings":null,"SQLState":null,"Evidence":null}