Postgres Pro
Downloads
Home   >   mailing lists

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

From Carlo Stonebanks
Subject Re: Fast tsearch2, trigram matching on short phrases
Date
Msg-id fai6ct$2o8s$1@news.hub.org
Whole thread Raw
In response to Re: Fast tsearch2, trigram matching on short phrases  (Oleg Bartunov <oleg@sai.msu.su>)
Responses Re: Fast tsearch2, trigram matching on short phrases  (Oleg Bartunov <oleg@sai.msu.su>)
List pgsql-performance
Tree view 
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

pgsql-performance by date:

Previous
From: "Carlo Stonebanks"
Date:
Subject: Re: Fast tsearch2, trigram matching on short phrases
Next
From: Greg Smith
Date:
Subject: Re: io storm on checkpoints, postgresql 8.2.4, linux