Re: Fast tsearch2, trigram matching on short phrases - Mailing list pgsql-performance

From Oleg Bartunov
Subject Re: Fast tsearch2, trigram matching on short phrases
Date
Msg-id Pine.LNX.4.64.0708230041260.2727@sn.sai.msu.ru
Whole thread Raw
In response to Re: Fast tsearch2, trigram matching on short phrases  ("Carlo Stonebanks" <stonec.register@sympatico.ca>)
Responses Re: Fast tsearch2, trigram matching on short phrases  ("Carlo Stonebanks" <stonec.register@sympatico.ca>)
List pgsql-performance
On Wed, 22 Aug 2007, Carlo Stonebanks wrote:

> Hi Oleg,
>
>> you didn't show us explain analyze of your select.
>
> I didn't because I didn't expect any reaction to it - my understanding is
> that trigram matching for phrases is not recommended because of the
> performance. Do you believe that I SHOULD expect good performance from
> trigram matching on phrases (a sopposed to words)?

The problem is in idea, not in performance.

>
> Carlo
>
> ---------------------------(end of broadcast)---------------------------
> TIP 7: You can help support the PostgreSQL project by donating at
>
>               http://www.postgresql.org/about/donate
>

     Regards,
         Oleg
_____________________________________________________________
Oleg Bartunov, Research Scientist, Head of AstroNet (www.astronet.ru),
Sternberg Astronomical Institute, Moscow University, Russia
Internet: oleg@sai.msu.su, http://www.sai.msu.su/~megera/
phone: +007(495)939-16-83, +007(495)939-23-83

pgsql-performance by date:

Previous
From: Greg Smith
Date:
Subject: Re: io storm on checkpoints, postgresql 8.2.4, linux
Next
From: "Sachchida Ojha"
Date:
Subject: Long running transaction in pg_activity_log