@@ -387,9 +387,13 @@ CREATE [ UNIQUE ] INDEX [ CONCURRENTLY ] [ [ IF NOT EXISTS ] <replaceable class=
387
387
388
388
<para>
389
389
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:
393
397
</para>
394
398
395
399
<variablelist>
@@ -401,7 +405,7 @@ CREATE [ UNIQUE ] INDEX [ CONCURRENTLY ] [ [ IF NOT EXISTS ] <replaceable class=
401
405
</term>
402
406
<listitem>
403
407
<para>
404
- The fillfactor for an index is a percentage that determines how full
408
+ Controls how full
405
409
the index method will try to pack index pages. For B-trees, leaf pages
406
410
are filled to this percentage during initial index builds, and also
407
411
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=
488
492
</term>
489
493
<listitem>
490
494
<para>
491
- Determines whether the buffered build technique described in
495
+ Controls whether the buffered build technique described in
492
496
<xref linkend="gist-buffering-build"/> is used to build the index. With
493
497
<literal>OFF</literal> buffering is disabled, with <literal>ON</literal>
494
498
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=
503
507
</variablelist>
504
508
505
509
<para>
506
- GIN indexes accept different parameters:
510
+ GIN indexes accept these parameters:
507
511
</para>
508
512
509
513
<variablelist>
@@ -515,8 +519,8 @@ CREATE [ UNIQUE ] INDEX [ CONCURRENTLY ] [ [ IF NOT EXISTS ] <replaceable class=
515
519
</term>
516
520
<listitem>
517
521
<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"/>.
520
524
<literal>ON</literal> enables fast update, <literal>OFF</literal> disables it.
521
525
The default is <literal>ON</literal>.
522
526
</para>
@@ -525,8 +529,9 @@ CREATE [ UNIQUE ] INDEX [ CONCURRENTLY ] [ [ IF NOT EXISTS ] <replaceable class=
525
529
<para>
526
530
Turning <literal>fastupdate</literal> off via <command>ALTER INDEX</command> prevents
527
531
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>
530
535
function afterward to ensure the pending list is emptied.
531
536
</para>
532
537
</note>
@@ -544,15 +549,16 @@ CREATE [ UNIQUE ] INDEX [ CONCURRENTLY ] [ [ IF NOT EXISTS ] <replaceable class=
544
549
</term>
545
550
<listitem>
546
551
<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.
548
554
This value is specified in kilobytes.
549
555
</para>
550
556
</listitem>
551
557
</varlistentry>
552
558
</variablelist>
553
559
554
560
<para>
555
- <acronym>BRIN</acronym> indexes accept different parameters:
561
+ <acronym>BRIN</acronym> indexes accept these parameters:
556
562
</para>
557
563
558
564
<variablelist>
@@ -580,8 +586,8 @@ CREATE [ UNIQUE ] INDEX [ CONCURRENTLY ] [ [ IF NOT EXISTS ] <replaceable class=
580
586
<listitem>
581
587
<para>
582
588
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) .
585
591
The default is <literal>off</literal>.
586
592
</para>
587
593
</listitem>
0 commit comments