Re: pg_trgm performance - Mailing list pgsql-performance

From Guillaume Smet
Subject Re: pg_trgm performance
Date
Msg-id 1d4e0c10702260458w31c1f01bu64c924b543e811a9@mail.gmail.com
Whole thread Raw
In response to Re: pg_trgm performance  (Oleg Bartunov <oleg@sai.msu.su>)
Responses Re: pg_trgm performance
List pgsql-performance
On 2/26/07, Oleg Bartunov <oleg@sai.msu.su> wrote:
> Did you rewrite query manually or use rewrite feature of tsearch2 ?

Currently, it's manual. I perform a pg_trgm query for each word of the
search words (a few stop words excluded) and I generate the ts_query
with the similar words instead of using the search words.
Is there any benefit of using rewrite() in this case?

--
Guillaume

pgsql-performance by date:

Previous
From: Oleg Bartunov
Date:
Subject: Re: pg_trgm performance
Next
From: Oleg Bartunov
Date:
Subject: Re: pg_trgm performance