Re: Fast tsearch2, trigram matching on short phrases

From: "Carlo Stonebanks" <stonec(dot)register(at)sympatico(dot)ca>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: Fast tsearch2, trigram matching on short phrases
Date: 2007-08-22 20:31:08
Message-ID: fai6ct$2o8s$1@news.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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)?

Carlo

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Sachchida Ojha 2007-08-22 20:40:09 Long running transaction in pg_activity_log
Previous Message Greg Smith 2007-08-22 20:30:35 Re: io storm on checkpoints, postgresql 8.2.4, linux