Commitdd03dfe

committed

doc: mention "bloom" as a possible index access method

Also remove USING erroneously added recently.Reported-by: Jeff JanesDiscussion:https://postgr.es/m/CAMkU=1zhCpC7hottyMWM5Pimr9vRLprSwzLg+7PgajWhKZqRzw@mail.gmail.comBackpatch-through: 10

1 parent4ea07e7 commitdd03dfeCopy full SHA for dd03dfe

File tree

-15

lines changed

-15

lines changed

Lines changed: 2 additions & 1 deletion

Original file line number	Diff line number	Diff line change
`@@ -117,7 +117,8 @@ CREATE INDEX test1_id_index ON test1 (id);`
`117`	`117`
`118`	`118`	`<para>`
`119`	`119`	`<productname>PostgreSQL</productname> provides several index types:`
`120`		`- B-tree, Hash, GiST, SP-GiST, GIN and BRIN.`
	`120`	`+ B-tree, Hash, GiST, SP-GiST, GIN, BRIN, and the extension <link`
	`121`	`+ linkend="bloom">bloom</link>.`
`121`	`122`	`Each index type uses a different`
`122`	`123`	`algorithm that is best suited to different types of queries.`
`123`	`124`	`By default, the <link linkend="sql-createindex"><command>CREATE`

Lines changed: 3 additions & 14 deletions

Original file line number	Diff line number	Diff line change
`@@ -149,18 +149,6 @@ CREATE [ UNIQUE ] INDEX [ CONCURRENTLY ] [ [ IF NOT EXISTS ] <replaceable class=`
`149`	`149`	`</listitem>`
`150`	`150`	`</varlistentry>`
`151`	`151`
`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`		`-`
`164`	`152`	`<varlistentry>`
`165`	`153`	`<term><literal>INCLUDE</literal></term>`
`166`	`154`	`<listitem>`
`@@ -250,8 +238,9 @@ CREATE [ UNIQUE ] INDEX [ CONCURRENTLY ] [ [ IF NOT EXISTS ] <replaceable class=`
`250`	`238`	`<para>`
`251`	`239`	`The name of the index method to be used. Choices are`
`252`	`240`	`<literal>btree</literal>, <literal>hash</literal>,`
`253`		`- <literal>gist</literal>, <literal>spgist</literal>, <literal>gin</literal>, and`
`254`		`- <literal>brin</literal>.`
	`241`	`+ <literal>gist</literal>, <literal>spgist</literal>, <literal>gin</literal>,`
	`242`	`+ <literal>brin</literal>, or user-installed access methods like`
	`243`	`+ <link linkend="bloom">bloom</link>.`
`255`	`244`	`The default method is <literal>btree</literal>.`
`256`	`245`	`</para>`
`257`	`246`	`</listitem>`

Comments

(0)