Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-sql by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group