Postgres Pro
Downloads
Home   >   mailing lists

Re: Creating an index-type for LIKE '%value%' - Mailing list pgsql-general

From Larry Rosenman
Subject Re: Creating an index-type for LIKE '%value%'
Date
Msg-id Pine.uw2.4.61.0502080727020.29519@lerami.lerctr.org
Whole thread Raw
In response to Re: Creating an index-type for LIKE '%value%'  (Oleg Bartunov <oleg@sai.msu.su>)
Responses Re: Creating an index-type for LIKE '%value%'  (Oleg Bartunov <oleg@sai.msu.su>)
List pgsql-general
Tree view 
On Tue, 8 Feb 2005, Oleg Bartunov wrote:

> On Mon, 7 Feb 2005, Larry Rosenman wrote:
>
>> Oleg Bartunov wrote:
>
> Larry, I pointed you to pg_trgm module mostly following Martijn's
> suggestions. Now, I see you need another our module - ltree,
> see http://www.sai.msu.su/~megera/postgres/gist/ltree/
> for details.

I maybe dense, but could you give me an example?

I'm not seeing it for some reason :).

Thanks,
LER

--
Larry Rosenman                     http://www.lerctr.org/~ler
Phone: +1 972-414-9812                 E-Mail: ler@lerctr.org
US Mail: 1905 Steamboat Springs Drive, Garland, TX 75044-6749

pgsql-general by date:

Previous
From: sid tow
Date:
Subject: Performance tuning using copy
Next
From: Doug McNaught
Date:
Subject: Re: Update command too slow