Re: Fast tsearch2, trigram matching on short phrases

From: Oleg Bartunov <oleg(at)sai(dot)msu(dot)su>
To: Carlo Stonebanks <stonec(dot)register(at)sympatico(dot)ca>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Fast tsearch2, trigram matching on short phrases
Date: 2007-08-22 20:43:07
Message-ID: Pine.LNX.4.64.0708230041260.2727@sn.sai.msu.ru
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)sai(dot)msu(dot)su, http://www.sai.msu.su/~megera/
phone: +007(495)939-16-83, +007(495)939-23-83

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Sachchida Ojha 2007-08-22 20:54:29 Re: Long running transaction in pg_activity_log
Previous Message Sachchida Ojha 2007-08-22 20:40:09 Long running transaction in pg_activity_log