8000 doc: mention "bloom" as a possible index access method · postgres/postgres@f4435ac · GitHub
[go: up one dir, main page]
Skip to content

Commit f4435ac

Browse files
bmomjianbmomjian
committed
doc: mention "bloom" as a possible index access method
Also remove USING erroneously added recently. Reported-by: Jeff Janes Discussion: https://postgr.es/m/CAMkU=1zhCpC7hottyMWM5Pimr9vRLprSwzLg+7PgajWhKZqRzw@mail.gmail.com Backpatch-through: 10
1 parent d333a1a commit f4435ac

File tree

2 files changed

+5
-15
lines changed

2 files changed

+5
-15
lines changed

‎doc/src/sgml/indices.sgml

Lines changed: 2 additions & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -118,7 +118,8 @@ CREATE INDEX test1_id_index ON test1 (id);
118118

119119
<para>
120120
<productname>PostgreSQL</productname> provides several index types:
121-
B-tree, Hash, GiST, SP-GiST, GIN and BRIN.
121+
B-tree, Hash, GiST, SP-GiST, GIN, BRIN, and the extension <link
122+
linkend="bloom">bloom</link>.
122123
Each index type uses a different
123124
algorithm that is best suited to different types of queries.
124125
By default, the <command>CREATE INDEX</command> command creates

‎doc/src/sgml/ref/create_index.sgml

Lines changed: 3 additions & 14 deletions
Original file line numberDiff line numberDiff line change
@@ -149,18 +149,6 @@ CREATE [ UNIQUE ] INDEX [ CONCURRENTLY ] [ [ IF NOT EXISTS ] <replaceable class=
149149
</listitem>
150150
</varlistentry>
151151

152-
<varlistentry>
153-
<term><literal>USING</literal></term>
154-
<listitem>
155-
<para>
156-
The optional <literal>USING</literal> clause specifies an index
157-
type as described in <xref linkend="indexes-types"/>. If not
158-
specified, a default index type will be used based on the
159-
data types of the columns.
160-
</para>
161-
</listitem>
162-
</varlistentry>
163-
164152
<varlistentry>
165153
<term><literal>INCLUDE</literal></term>
166154
<listitem>
@@ -245,8 +233,9 @@ CREATE [ UNIQUE ] INDEX [ CONCURRENTLY ] [ [ IF NOT EXISTS ] <replaceable class=
245233
<para>
246234
The name of the index method to be used. Choices are
247235
<literal>btree</literal>, <literal>hash</literal>,
248-
<literal>gist</literal>, <literal>spgist</literal>, <literal>gin</literal>, and
249-
<literal>brin</literal>.
236+
<literal>gist</literal>, <literal>spgist</literal>, <literal>gin</literal>,
237+
<literal>brin</literal>, or user-installed access methods like
238+
<link linkend="bloom">bloom</link>.
250239
The default method is <literal>btree</literal>.
251240
</para>
252241
</listitem>

0 commit comments

Comments
 (0)
0