</sect1>

<sect1 id="textsearch-indexes">

<title>GIN and GiSTIndex Types</title>

<title>PreferredIndex Types for Text Search</title>

<indexterm zone="textsearch-indexes">

<primary>text search</primary>

<para>

There are two kinds of indexes that can be used to speed up full text

searches.

searches:

<link linkend="gin"><acronym>GIN</acronym></link> and

<link linkend="gist"><acronym>GiST</acronym></link>.

Note that indexes are not mandatory for full text searching, but in

cases where a column is searched on a regular basis, an index is

usually desirable.

</para>

<para>

To create such an index, do one of:

<variablelist>