diff options
| author | Bruce Momjian <bruce@momjian.us> | 2022-08-31 22:35:09 -0400 |
|---|---|---|
| committer | Bruce Momjian <bruce@momjian.us> | 2022-08-31 22:35:09 -0400 |
| commit | 6fac58814c5d9fb75ac67d2bcf7732748d5634f2 (patch) | |
| tree | 3970e38583a3e02e43b248fd4a44c2278a2e8252 | |
| parent | d11a53a8e0a77c95c47e6f2514c1ba70c18d60e0 (diff) | |
| download | postgresql-6fac58814c5d9fb75ac67d2bcf7732748d5634f2.tar.gz postgresql-6fac58814c5d9fb75ac67d2bcf7732748d5634f2.zip | |
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
| -rw-r--r-- | doc/src/sgml/indices.sgml | 3 | ||||
| -rw-r--r-- | doc/src/sgml/ref/create_index.sgml | 17 |
2 files changed, 5 insertions, 15 deletions
diff --git a/doc/src/sgml/indices.sgml b/doc/src/sgml/indices.sgml index 2a70e02f7c4..0c3fcfd62f8 100644 --- a/doc/src/sgml/indices.sgml +++ b/doc/src/sgml/indices.sgml @@ -117,7 +117,8 @@ CREATE INDEX test1_id_index ON test1 (id); <para> <productname>PostgreSQL</productname> provides several index types: - B-tree, Hash, GiST, SP-GiST, GIN and BRIN. + B-tree, Hash, GiST, SP-GiST, GIN, BRIN, and the extension <link + linkend="bloom">bloom</link>. Each index type uses a different algorithm that is best suited to different types of queries. By default, the <link linkend="sql-createindex"><command>CREATE diff --git a/doc/src/sgml/ref/create_index.sgml b/doc/src/sgml/ref/create_index.sgml index 318f7f7d96a..7f4da975d6c 100644 --- a/doc/src/sgml/ref/create_index.sgml +++ b/doc/src/sgml/ref/create_index.sgml @@ -149,18 +149,6 @@ CREATE [ UNIQUE ] INDEX [ CONCURRENTLY ] [ [ IF NOT EXISTS ] <replaceable class= </varlistentry> <varlistentry> - <term><literal>USING</literal></term> - <listitem> - <para> - The optional <literal>USING</literal> clause specifies an index - type as described in <xref linkend="indexes-types"/>. If not - specified, a default index type will be used based on the - data types of the columns. - </para> - </listitem> - </varlistentry> - - <varlistentry> <term><literal>INCLUDE</literal></term> <listitem> <para> @@ -246,8 +234,9 @@ CREATE [ UNIQUE ] INDEX [ CONCURRENTLY ] [ [ IF NOT EXISTS ] <replaceable class= <para> The name of the index method to be used. Choices are <literal>btree</literal>, <literal>hash</literal>, - <literal>gist</literal>, <literal>spgist</literal>, <literal>gin</literal>, and - <literal>brin</literal>. + <literal>gist</literal>, <literal>spgist</literal>, <literal>gin</literal>, + <literal>brin</literal>, or user-installed access methods like + <link linkend="bloom">bloom</link>. The default method is <literal>btree</literal>. </para> </listitem> |