Commit6fac588

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 parentd11a53a commit6fac588Copy full SHA for 6fac588

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
`@@ -148,18 +148,6 @@ CREATE [ UNIQUE ] INDEX [ CONCURRENTLY ] [ [ IF NOT EXISTS ] <replaceable class=`
`148`	`148`	`</listitem>`
`149`	`149`	`</varlistentry>`
`150`	`150`
`151`		`- <varlistentry>`
`152`		`- <term><literal>USING</literal></term>`
`153`		`- <listitem>`
`154`		`- <para>`
`155`		`- The optional <literal>USING</literal> clause specifies an index`
`156`		`- type as described in <xref linkend="indexes-types"/>. If not`
`157`		`- specified, a default index type will be used based on the`
`158`		`- data types of the columns.`
`159`		`- </para>`
`160`		`- </listitem>`
`161`		`- </varlistentry>`
`162`		`-`
`163`	`151`	`<varlistentry>`
`164`	`152`	`<term><literal>INCLUDE</literal></term>`
`165`	`153`	`<listitem>`
`@@ -246,8 +234,9 @@ CREATE [ UNIQUE ] INDEX [ CONCURRENTLY ] [ [ IF NOT EXISTS ] <replaceable class=`
`246`	`234`	`<para>`
`247`	`235`	`The name of the index method to be used. Choices are`
`248`	`236`	`<literal>btree</literal>, <literal>hash</literal>,`
`249`		`- <literal>gist</literal>, <literal>spgist</literal>, <literal>gin</literal>, and`
`250`		`- <literal>brin</literal>.`
	`237`	`+ <literal>gist</literal>, <literal>spgist</literal>, <literal>gin</literal>,`
	`238`	`+ <literal>brin</literal>, or user-installed access methods like`
	`239`	`+ <link linkend="bloom">bloom</link>.`
`251`	`240`	`The default method is <literal>btree</literal>.`
`252`	`241`	`</para>`
`253`	`242`	`</listitem>`

Comments

(0)