aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorTom Lane <tgl@sss.pgh.pa.us>2022-04-12 18:21:04 -0400
committerTom Lane <tgl@sss.pgh.pa.us>2022-04-12 18:21:17 -0400
commit8320a34d38e220d99eb24fbd09536b12711fb102 (patch)
tree27360444d2b8eda7b4b6c6dca8ee50e3e472df83
parent3a95dfe4025f48fb57262ce590ba397a80a1a7b6 (diff)
downloadpostgresql-8320a34d38e220d99eb24fbd09536b12711fb102.tar.gz
postgresql-8320a34d38e220d99eb24fbd09536b12711fb102.zip
Doc: tweak textsearch.sgml for SEO purposes.
Google seems to like to return textsearch.html for queries about GIN and GiST indexes, even though it's not a primary reference for either. It seems likely that that's because those keywords appear in the page title. Since "GIN and GiST Index Types" is not a very apposite title for this material anyway, rename the section in hopes of stopping that. Also provide explicit links to the GIN and GiST chapters, to help anyone who finds their way to this page regardless. Per gripe from Jan Piotrowski. Back-patch to supported branches. (Unfortunately Google is likely to continue returning the 9.1 version of this page, but improving that situation is a matter for the www team.) Discussion: https://postgr.es/m/164978902252.1276550.9330175733459697101@wrigleys.postgresql.org
-rw-r--r--doc/src/sgml/textsearch.sgml10
1 files changed, 8 insertions, 2 deletions
diff --git a/doc/src/sgml/textsearch.sgml b/doc/src/sgml/textsearch.sgml
index 20db7b7afe6..6afaf9e62c4 100644
--- a/doc/src/sgml/textsearch.sgml
+++ b/doc/src/sgml/textsearch.sgml
@@ -3618,7 +3618,7 @@ SELECT plainto_tsquery('supernovae stars');
</sect1>
<sect1 id="textsearch-indexes">
- <title>GIN and GiST Index Types</title>
+ <title>Preferred Index Types for Text Search</title>
<indexterm zone="textsearch-indexes">
<primary>text search</primary>
@@ -3627,10 +3627,16 @@ SELECT plainto_tsquery('supernovae stars');
<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>