Re: Very slow search using basic pattern matching

From: "Raphael A(dot) Bauer" <rbauer(at)informatik(dot)hu-berlin(dot)de>
To: Dan Field <dof(at)llgc(dot)org(dot)uk>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: Very slow search using basic pattern matching
Date: 2004-05-19 11:51:57
Message-ID: 40AB4A5D.9020903@informatik.hu-berlin.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Dan Field wrote:
> Is there any documentation available on how to go about creating these
> indexes on my text fields?
>
> I'm at a bit of a loss here, Google is failing me sadly

http://www.sai.msu.su/~megera/postgres/gist/tsearch/V2/

We made quite good experiences with tsearch2.
The problem for you could be that the case sensititity gets lost.

Raph

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Jeff Post 2004-05-19 14:19:47 Preventing Deletions with triggers
Previous Message Dan Field 2004-05-19 11:33:22 Re: Very slow search using basic pattern matching