Re: Help with LIKE - Mailing list pgsql-performance

From David Olbersen
Subject Re: Help with LIKE
Date
Msg-id E7E213858379814A9AE48CA6754F5ECB0D6C32@mail01.stbernard.com
Whole thread Raw
In response to Help with LIKE  ("David Olbersen" <DOlbersen@stbernard.com>)
List pgsql-performance
Josh,

> That's what's called an "unanchored text search".   That kind
> of query cannot be indexed using a regular index.

Duh, should have tried the anchors to get what I wanted...

> What you need is called "Full Text Indexing" or "Full Text
> Search".   Check
> out two resources:

This isn't actually what I was looking for, the anchor works better (only 5.87 now!)

Thanks for the reminder!

--------------------------
David Olbersen
iGuard Engineer
11415 West Bernardo Court
San Diego, CA 92127
1-858-676-2277 x2152

pgsql-performance by date:

Previous
From: Florian Weimer
Date:
Subject: Re: postgresql meltdown on PlanetMath.org
Next
From: "David Olbersen"
Date:
Subject: Re: Help with LIKE