From: Tom Lane <tgl@sss.pgh.pa.us>
To: Peter Geoghegan <pg@bowt.ie>
cc: piotrowski@prisma.io, Pg Docs <pgsql-docs@lists.postgresql.org>
Subject: Re: "GIN and GiST Index Types" page is about usage in full text
 search, but looks general purpose
In-reply-to: 
 <CAH2-Wz=+5kzq8A6Uo_t7F0URwztb74-O+UuFcAh1iixTME-WXQ@mail.gmail.com>
References: <164978902252.1276550.9330175733459697101@wrigleys.postgresql.org>
 <CAH2-Wz=+5kzq8A6Uo_t7F0URwztb74-O+UuFcAh1iixTME-WXQ@mail.gmail.com>
Comments: In-reply-to Peter Geoghegan <pg@bowt.ie>
	message dated "Tue, 12 Apr 2022 12:34:52 -0700"
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-ID: <911426.1649792973.1@sss.pgh.pa.us>
Date: Tue, 12 Apr 2022 15:49:33 -0400
Message-ID: <911427.1649792973@sss.pgh.pa.us>
Archived-At: 
 <https://www.postgresql.org/message-id/911427.1649792973%40sss.pgh.pa.us>
Precedence: bulk

Peter Geoghegan <pg@bowt.ie> writes:
> The page in question is "12.9. GIN and GiST Index Types", but it's
> really supplementary information for "12.2.2. Creating Indexes". The
> fact that the former has greater prominence than the latter (a general
> discussion of FTS indexing) seems like a problem in itself.

> At one point GiST was competitive with GIN for full text search
> performance (or at least more competitive). These days use of GiST for
> FTS should be rare. So the title should suggest that GiST FTS indexing
> is the nonstandard choice.

I think we should take the index type names out of the section title
entirely, and name it something generic like "Preferred Index Types for
Full Text Search".  Unfortunately, with the EOL'd documentation versions
being pretty much frozen in time, it's not clear that we can prevent
Google from continuing to find that 9.1 page when the search terms
include GIN and GIST.  I suspect it's keying off those terms appearing
in the page title :-(

After the recent changes discussed on the -www list, it's possible
that Google will eventually stop indexing the 9.1 page altogether,
but I'm not holding my breath.

			regards, tom lane