Re: An inconsistency in the documentation about full text search

On Tue, Nov 7, 2023, at 7:12 AM, Erki Eessaar wrote: > Section > > 12.2.2. Creating Indexes > https://www.postgresql.org/docs/current/textsearch-tables.html#TEXTSEARCH-TABLES-INDEX > > wrtites the following: "Another approach is to create a separate tsvector > column to hold the output of to_tsv

An inconsistency in the documentation about full text search

Hello I write about the documentation of full-text search. Section 12.2.2. Creating Indexes https://www.postgresql.org/docs/current/textsearch-tables.html#TEXTSEARCH-TABLES-INDEX wrtites the following: "Another approach is to create a separate tsvector column to hold the output of to_tsv

Re: Full Text Search

Thank you David for your response, it makes sense now. Julien > Le 29 oct. 2023 à 22:02, David G. Johnston a > écrit : > > On Sun, Oct 29, 2023, 13:58 PG Doc comments form > wrote: > The following documentation comment has been logged on the website: > > Page:

Re: Full Text Search

On Sun, Oct 29, 2023, 13:58 PG Doc comments form wrote: > The following documentation comment has been logged on the website: > > Page: https://www.postgresql.org/docs/14/textsearch-limitations.html > Description: > > Hello, > > In the FTS/Limitations part of the documentation, it says : > > "Ano

Full Text Search

The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/14/textsearch-limitations.html Description: Hello, In the FTS/Limitations part of the documentation, it says : "Another example — the PostgreSQL mailing list archives contained 910,989 uniq

Pattern matching also includes Full-text search, Trigram and Fuzzysearch

ut there's a Full-text search, Trigram and Fuzzysearch extensions. Shouldn't they be listed in the tip? Regards, B Banchev

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

Peter Geoghegan writes: > On Tue, Apr 12, 2022 at 1:28 PM Tom Lane 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

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

On Tue, Apr 12, 2022 at 1:28 PM Tom Lane 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 in

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

Peter Geoghegan writes: > On Tue, Apr 12, 2022 at 12:49 PM Tom Lane wrote: >> 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". > Agreed. Prop

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

On Tue, Apr 12, 2022 at 12:49 PM Tom Lane wrote: > 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". Agreed. > After the recent changes discussed on the -w

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

exing) 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 thi

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

On Tue, Apr 12, 2022 at 12:12 PM PG Doc comments form wrote: > Even more effective would be to update the page title and/or headline to > make clear that it is about using GIN and GiST indexes in context of full > text search only. I agree that the overall structure is unclear, and se

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

esult from postgresql.org: https://www.postgresql.org/docs/current/textsearch-indexes.html This led me an others in our team to initially misunderstand that GiST and GIN indexes are purely a full text search thing in PostgreSQL. But they are of course so much more, but from this page you would not