What index for 'like (%keyword%)' ??? - Mailing list pgsql-performance

From Priem, Alexander
Subject What index for 'like (%keyword%)' ???
Date
Msg-id 2A07EC2D0BC2774AAD6F74769F60D52A08329A@ahmose.cict_ad.nl
Whole thread Raw
Responses Re: What index for 'like (%keyword%)' ???
Re: What index for 'like (%keyword%)' ???
List pgsql-performance
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?

Kind regards,
Alexander Priem.

pgsql-performance by date:

Previous
From: Richard Huxton
Date:
Subject: Re: select slow?
Next
From: Richard Huxton
Date:
Subject: Re: What index for 'like (%keyword%)' ???