Postgres Pro
Downloads
Home   >   mailing lists

Re: Incorrect FTS query results with GIN index - Mailing list pgsql-general

From Teodor Sigaev
Subject Re: Incorrect FTS query results with GIN index
Date
Msg-id 4B544C48.5080203@sigaev.ru
Whole thread Raw
In response to Incorrect FTS query results with GIN index  (Vyacheslav Kalinin <vka@mgcp.com>)
Responses Re: Incorrect FTS query results with GIN index  (Vyacheslav Kalinin <vka@mgcp.com>)
List pgsql-general
Tree view 
> Basically, I started testing prefix matching in FTS and got into
> troubles. Self-contained example follows:

Thank you, fixed. The reason was in incorrect optimization of GIN scan: GIN
reuses scan result for equals key, but comparison of key didn't take into
account a difference of scan's strategy.


--
Teodor Sigaev                                   E-mail: teodor@sigaev.ru
                                                    WWW: http://www.sigaev.ru/

pgsql-general by date:

Previous
From: Brian
Date:
Subject: does ispell have allaffixes set to on?
Next
From: Vyacheslav Kalinin
Date:
Subject: Re: Incorrect FTS query results with GIN index