Re: Help with LIKE

Поиск
Список
Период
Сортировка
От David Olbersen
Тема Re: Help with LIKE
Дата
Msg-id E7E213858379814A9AE48CA6754F5ECB0D6C32@mail01.stbernard.com
обсуждение исходный текст
Ответ на Help with LIKE  ("David Olbersen" <DOlbersen@stbernard.com>)
Список 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 по дате отправления:

Предыдущее
От: Florian Weimer
Дата:
Сообщение: Re: postgresql meltdown on PlanetMath.org
Следующее
От: "David Olbersen"
Дата:
Сообщение: Re: Help with LIKE