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>
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? |