Re: Wildcard searches & performance question

From: "scott(dot)marlowe" <scott(dot)marlowe(at)ihs(dot)com>
To: Grega Bremec <grega(dot)bremec(at)noviforum(dot)si>
Cc: <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Wildcard searches & performance question
Date: 2003-05-28 22:46:26
Message-ID: Pine.LNX.4.33.0305281612040.28136-100000@css120.ihs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Wed, 28 May 2003, Grega Bremec wrote:

> Thank you very much for all your suggestions.
>
> I am planning on investing some time into trying out a couple FT indexes. Not
> minding the fact most of the queries are going to be exact phrase substring
> searches, performance will most probably benefit from it, so at least some of
> what I'm after is achieved that way.
>
> I shall be getting back with reports, in case anyone is interested.

Be sure to look at OpenFTS http://sourceforge.net/projects/openfts/

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Tom Lane 2003-05-28 23:44:01 Re: IN list processing performance (yet again)
Previous Message Matthew Nuzum 2003-05-28 21:30:01 recursive srf