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

Re: What index for 'like (%keyword%)' ???

From: Richard Huxton <dev(at)archonet(dot)com>
To: "Priem, Alexander" <ap(at)cict(dot)nl>, pgsql-performance(at)postgresql(dot)org
Subject: Re: What index for 'like (%keyword%)' ???
Date: 2004-03-31 12:07:54
Message-ID: 200403311307.54680.dev@archonet.com (view raw or flat)
Thread:
Lists: pgsql-performance
On Wednesday 31 March 2004 10:51, Priem, Alexander wrote:
> Hi everyone,
>
> I am building a query which uses a clause like "Where doc_description like
> '%keyword%'". I know a normal index won't be of any use here, but since the
> table in question will get fairly big, I do want to use an index.
>
> Can anyone give me some advise on what kind of index I can use here? Or
> shouldn't I use one in this case?

You probably want to look at the contrib/tsearch2 full-text indexing module.

-- 
  Richard Huxton
  Archonet Ltd

In response to

pgsql-performance by date

Next:From: Jaime CasanovaDate: 2004-03-31 14:27:50
Subject: Re: select slow?
Previous:From: Priem, AlexanderDate: 2004-03-31 09:51:02
Subject: What index for 'like (%keyword%)' ???

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