Movatterモバイル変換

[0]ホーム
URL:

Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

 Sign up
Appearance settings

Commit78637a8

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 parameterdescriptions, 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 parente708ffe commit78637a8

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 acceptdifferent parameters:
510+
GIN indexes acceptthese 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 acceptdifferent parameters:
561+
<acronym>BRIN</acronym> indexes acceptthese 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)
[8]ページ先頭
©2009-2025 Movatter.jp