Re: Incorrect information about GIN-index in RUM's docs

From: Andreas Joseph Krogh <andreas(at)visena(dot)com>
To: Oleg Bartunov <obartunov(at)gmail(dot)com>
Cc: Postgres General <pgsql-general(at)postgresql(dot)org>
Subject: Re: Incorrect information about GIN-index in RUM's docs
Date: 2016-11-15 08:12:30
Message-ID: VisenaEmail.5d.1a6dd575c41c2e12.15867051a74@tc7-visena
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

På tirsdag 15. november 2016 kl. 08:48:37, skrev Oleg Bartunov <
obartunov(at)gmail(dot)com <mailto:obartunov(at)gmail(dot)com>>:
    On Tue, Nov 15, 2016 at 10:37 AM, Andreas Joseph Krogh <andreas(at)visena(dot)com
<mailto:andreas(at)visena(dot)com>> wrote: This item isn't valid, is it?
 

* There isn't phrase search with GIN index. This problem relates with
previous problem. It is need position information to perform phrase search.
RUM being an extention, and having index-access-methods as extentions is new
in 9.6, where phrase-search was introduced, this isn't really true, or am I
missing something?
 
 
RUM is very good for phrase search, since it has access to coordinates in
index, check slides from PGconf.eu (
http://www.sai.msu.su/~megera/postgres/talks/pgconfeu-fts-2016.pdf
<http://www.sai.msu.su/~megera/postgres/talks/pgconfeu-fts-2016.pdf>).  Where
did you find the citation ?

 
https://github.com/postgrespro/rum#user-content-introduction
 
I assume I read the item wrong tho. As it's phrased, it (for me at least but
I'm Norwegian) seems like phrase-search is not possible with GIN, which it
definitely is. So I assume the real issue, that this item is trying to point
out, is that phrase-search isn't reallyoptimized with GIN, just syntactic
sugar. And with RUM it is optimized, not just syntactic sugar. Am I correct
assuming this?
 
-- Andreas Joseph Krogh
CTO / Partner - Visena AS
Mobile: +47 909 56 963
andreas(at)visena(dot)com <mailto:andreas(at)visena(dot)com>
www.visena.com <https://www.visena.com>
<https://www.visena.com>

 

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Artur Zakirov 2016-11-15 08:26:58 Re: Incorrect information about GIN-index in RUM's docs
Previous Message John R Pierce 2016-11-15 08:02:13 Re: How the Planner in PGStrom differs from PostgreSQL?