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>
Subject: Re: "GIN and GiST Index Types" page is about usage in full text
 search, but looks general purpose
In-reply-to: 
 <CAH2-WzkjN2aYQJddOSPZ-KC894QahxpzJWSe4HLtz0U0gGpQeQ@mail.gmail.com>
References: <164978902252.1276550.9330175733459697101@wrigleys.postgresql.org>
 <CAH2-Wz=+5kzq8A6Uo_t7F0URwztb74-O+UuFcAh1iixTME-WXQ@mail.gmail.com>
 <911427.1649792973@sss.pgh.pa.us>
 <CAH2-Wzm-YYq2f1Hy7HoazKmC6co3YmYKArN1civ20PnCSVHpBA@mail.gmail.com>
 <915352.1649795327@sss.pgh.pa.us>
 <CAH2-WzkjN2aYQJddOSPZ-KC894QahxpzJWSe4HLtz0U0gGpQeQ@mail.gmail.com>
Comments: In-reply-to Peter Geoghegan <pg@bowt.ie>
	message dated "Tue, 12 Apr 2022 14:34:01 -0700"
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-ID: <1008195.1649802173.1@sss.pgh.pa.us>
Date: Tue, 12 Apr 2022 18:22:53 -0400
Message-ID: <1008196.1649802173@sss.pgh.pa.us>
Archived-At: 
 <https://www.postgresql.org/message-id/1008196.1649802173%40sss.pgh.pa.us>
Precedence: bulk

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