Re: "GIN and GiST Index Types" page is about usage in full text search, but looks general purpose

Tom Lane <tgl@sss.pgh.pa.us>

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>, "Jonathan S. Katz" <jkatz@postgresql.org>
Date: 2022-04-12T22:22:53Z
Lists: pgsql-docs
Peter Geoghegan <pg@bowt.ie> writes:
> On Tue, Apr 12, 2022 at 1:28 PM Tom Lane <tgl@sss.pgh.pa.us> wrote:
>> Proposed patch attached.  The existing text already says "GIN indexes are
>> the preferred text search index type", so I'm not sure we need to go
>> further than that about guiding people which one to use.  In particular,
>> since GIN can't support included columns, we can't really deprecate GiST
>> altogether here.

> LGTM.

Done that way, then.

> I don't know enough about the topic to be able to claim that the
> robots.txt solution would also work out well, in about the same way.
> But I suspect that it might, and know that it's a reversible process.

Yeah, it's outside my expertise too.

			regards, tom lane



Commits

  1. Doc: tweak textsearch.sgml for SEO purposes.