Skip to content

Commit 78637a8

Browse files
tglsfdcpolobo
andcommitted
Doc: do a little copy-editing on Index Storage Parameters list.
Add a paragraph break per suggestion from David G. Johnston. Use a consistent voice for all the different parameter descriptions, and fix a couple of grammatical issues. Reported-by: Igor Korot <ikorot01@gmail.com> Co-authored-by: "David G. Johnston" <david.g.johnston@gmail.com> Co-authored-by: Tom Lane <tgl@sss.pgh.pa.us> Discussion: https://postgr.es/m/CA+FnnTz=EW1VQRpWB9J+G-NSchrPFcw4nR7d0JqzEK9jWKB35A@mail.gmail.com
1 parent e708ffe commit 78637a8

File tree

1 file changed

+20
-14
lines changed

1 file changed

+20
-14
lines changed

doc/src/sgml/ref/create_index.sgml

Lines changed: 20 additions & 14 deletions
Original file line numberDiff line numberDiff line change
@@ -387,9 +387,13 @@ CREATE [ UNIQUE ] INDEX [ CONCURRENTLY ] [ [ IF NOT EXISTS ] <replaceable class=
387387

388388
<para>
389389
The optional <literal>WITH</literal> clause specifies <firstterm>storage
390-
parameters</firstterm> for the index. Each index method has its own set of allowed
391-
storage parameters. The B-tree, hash, GiST and SP-GiST index methods all
392-
accept this parameter:
390+
parameters</firstterm> for the index. Each index method has its own set
391+
of allowed storage parameters.
392+
</para>
393+
394+
<para>
395+
The B-tree, hash, GiST and SP-GiST index methods all accept this
396+
parameter:
393397
</para>
394398

395399
<variablelist>
@@ -401,7 +405,7 @@ CREATE [ UNIQUE ] INDEX [ CONCURRENTLY ] [ [ IF NOT EXISTS ] <replaceable class=
401405
</term>
402406
<listitem>
403407
<para>
404-
The fillfactor for an index is a percentage that determines how full
408+
Controls how full
405409
the index method will try to pack index pages. For B-trees, leaf pages
406410
are filled to this percentage during initial index builds, and also
407411
when extending the index at the right (adding new largest key values).
@@ -488,7 +492,7 @@ CREATE [ UNIQUE ] INDEX [ CONCURRENTLY ] [ [ IF NOT EXISTS ] <replaceable class=
488492
</term>
489493
<listitem>
490494
<para>
491-
Determines whether the buffered build technique described in
495+
Controls whether the buffered build technique described in
492496
<xref linkend="gist-buffering-build"/> is used to build the index. With
493497
<literal>OFF</literal> buffering is disabled, with <literal>ON</literal>
494498
it is enabled, and with <literal>AUTO</literal> it is initially disabled,
@@ -503,7 +507,7 @@ CREATE [ UNIQUE ] INDEX [ CONCURRENTLY ] [ [ IF NOT EXISTS ] <replaceable class=
503507
</variablelist>
504508

505509
<para>
506-
GIN indexes accept different parameters:
510+
GIN indexes accept these parameters:
507511
</para>
508512

509513
<variablelist>
@@ -515,8 +519,8 @@ CREATE [ UNIQUE ] INDEX [ CONCURRENTLY ] [ [ IF NOT EXISTS ] <replaceable class=
515519
</term>
516520
<listitem>
517521
<para>
518-
This setting controls usage of the fast update technique described in
519-
<xref linkend="gin-fast-update"/>. It is a Boolean parameter:
522+
Controls usage of the fast update technique described in
523+
<xref linkend="gin-fast-update"/>.
520524
<literal>ON</literal> enables fast update, <literal>OFF</literal> disables it.
521525
The default is <literal>ON</literal>.
522526
</para>
@@ -525,8 +529,9 @@ CREATE [ UNIQUE ] INDEX [ CONCURRENTLY ] [ [ IF NOT EXISTS ] <replaceable class=
525529
<para>
526530
Turning <literal>fastupdate</literal> off via <command>ALTER INDEX</command> prevents
527531
future insertions from going into the list of pending index entries,
528-
but does not in itself flush previous entries. You might want to
529-
<command>VACUUM</command> the table or call <function>gin_clean_pending_list</function>
532+
but does not in itself flush existing entries. You might want to
533+
<command>VACUUM</command> the table or call
534+
the <function>gin_clean_pending_list</function>
530535
function afterward to ensure the pending list is emptied.
531536
</para>
532537
</note>
@@ -544,15 +549,16 @@ CREATE [ UNIQUE ] INDEX [ CONCURRENTLY ] [ [ IF NOT EXISTS ] <replaceable class=
544549
</term>
545550
<listitem>
546551
<para>
547-
Custom <xref linkend="guc-gin-pending-list-limit"/> parameter.
552+
Overrides the global setting of
553+
<xref linkend="guc-gin-pending-list-limit"/> for this index.
548554
This value is specified in kilobytes.
549555
</para>
550556
</listitem>
551557
</varlistentry>
552558
</variablelist>
553559

554560
<para>
555-
<acronym>BRIN</acronym> indexes accept different parameters:
561+
<acronym>BRIN</acronym> indexes accept these parameters:
556562
</para>
557563

558564
<variablelist>
@@ -580,8 +586,8 @@ CREATE [ UNIQUE ] INDEX [ CONCURRENTLY ] [ [ IF NOT EXISTS ] <replaceable class=
580586
<listitem>
581587
<para>
582588
Defines whether a summarization run is queued for the previous page
583-
range whenever an insertion is detected on the next one.
584-
See <xref linkend="brin-operation"/> for more details.
589+
range whenever an insertion is detected on the next one
590+
(see <xref linkend="brin-operation"/> for more details).
585591
The default is <literal>off</literal>.
586592
</para>
587593
</listitem>

0 commit comments

Comments
 (0)