Re: ltree + gist index performance degrades significantly over a night - Mailing list pgsql-general

On Fri, Feb 24, 2006 at 09:02:04AM -0800, CG wrote:
> I have a search table which I use for partial-match text searches:
<snip>
> For a string "Hello World" the ltree is created like 'h.e.l.l.o.w.o.r.l.d' ...
> If I wanted to find all rows with "orl" in them i would construct an lquery
> like '*.o.r.l.*' and use the "~" operator in the where clause. I would link to
> the table "items" by the item_id ...

Is there some reason you can't use tsearch2? I suspect it would probably
work better; if nothing else you'd probably get better support since a
lot more people use it.
--
Jim C. Nasby, Sr. Engineering Consultant      jnasby@pervasive.com
Pervasive Software      http://pervasive.com    work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf       cell: 512-569-9461