Content-Length: 280690 | pFad | http://github.com/postgrespro/postgres_cluster/commit/79172a58ea3e858750c93c61d55411a209c5ac69

4D Document BRIN's pages_per_range in CREATE INDEX · postgrespro/postgres_cluster@79172a5 · GitHub
Skip to content

Commit 79172a5

Browse files
committed
Document BRIN's pages_per_range in CREATE INDEX
Author: Michael Paquier
1 parent 155c0f2 commit 79172a5

File tree

1 file changed

+17
-0
lines changed

1 file changed

+17
-0
lines changed

doc/src/sgml/ref/create_index.sgml

Lines changed: 17 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -380,6 +380,23 @@ CREATE [ UNIQUE ] INDEX [ CONCURRENTLY ] [ [ IF NOT EXISTS ] <replaceable class=
380380
</listitem>
381381
</varlistentry>
382382
</variablelist>
383+
384+
<para>
385+
<acronym>BRIN</> indexes accept a different parameter:
386+
</para>
387+
388+
<variablelist>
389+
<varlistentry>
390+
<term><literal>pages_per_range</></term>
391+
<listitem>
392+
<para>
393+
Defines the number of table blocks that make up one block range for
394+
each entry of a <acronym>BRIN</> index (see <xref linkend="brin-intro">
395+
for more details). The default is <literal>128</>.
396+
</para>
397+
</listitem>
398+
</varlistentry>
399+
</variablelist>
383400
</refsect2>
384401

385402
<refsect2 id="SQL-CREATEINDEX-CONCURRENTLY">

0 commit comments

Comments
 (0)








ApplySandwichStrip

pFad - (p)hone/(F)rame/(a)nonymizer/(d)eclutterfier!      Saves Data!


--- a PPN by Garber Painting Akron. With Image Size Reduction included!

Fetched URL: http://github.com/postgrespro/postgres_cluster/commit/79172a58ea3e858750c93c61d55411a209c5ac69

Alternative Proxies:

Alternative Proxy

pFad Proxy

pFad v3 Proxy

pFad v4 Proxy