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

[Artur Zakirov]

On 15.11.2016 11:12, Andreas Joseph Krogh wrote:

På tirsdag 15. november 2016 kl. 08:48:37, skrev Oleg Bartunov
mailto:obartu...@gmail.com>>:



On Tue, Nov 15, 2016 at 10:37 AM, Andreas Joseph Krogh
mailto:andr...@visena.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).
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 really /optimized/ with
GIN, just syntactic sugar. And with RUM it is optimized, not just
syntactic sugar. Am I correct assuming this?


Yes. I suppose the original explanation about phrase search in GIN is 
confusing and ambiguous. GIN supports it, but it requires additional 
bitmap heap scan and so it slower.


I fixed it. Thank you.



--
*Andreas Joseph Krogh*
CTO / Partner - Visena AS
Mobile: +47 909 56 963
andr...@visena.com 
www.visena.com 





--
Artur Zakirov
Postgres Professional: http://www.postgrespro.com
Russian Postgres Company


--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

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

[Andreas Joseph Krogh]

På tirsdag 15. november 2016 kl. 08:48:37, skrev Oleg Bartunov <
obartu...@gmail.com >:
    On Tue, Nov 15, 2016 at 10:37 AM, Andreas Joseph Krogh mailto:andr...@visena.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 
).  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
andr...@visena.com 
www.visena.com 
 


 

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

[Oleg Bartunov]

On Tue, Nov 15, 2016 at 10:37 AM, Andreas Joseph Krogh 
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).  Where
did you find the citation ?



>
> --
> *Andreas Joseph Krogh*
> CTO / Partner - Visena AS
> Mobile: +47 909 56 963
> andr...@visena.com
> www.visena.com
> 
>