Re: [bulk] RE: Problem with LIKE-Performance

From: "Tarabas (Manuel Rorarius)" <tarabas(at)tarabas(dot)de>
To: "Hakan Kocaman" <Hakan(dot)Kocaman(at)digame(dot)de>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: [bulk] RE: Problem with LIKE-Performance
Date: 2006-04-18 15:43:53
Message-ID: 14334544.20060418174353@tarabas.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Hi Hakan,

HK> i remember something that you need a special index with locales<>"C".
HK> You nned a different operator class for this index smth. like:
HK> CREATE INDEX idx_image_title
HK> ON image
HK> USING btree
HK> (title varchar_pattern_ops);

I also forgot that, thanks a lot for the hint. that speeded up my
searches a lot!

Best regards
Manuel

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Tom Lane 2006-04-18 15:45:39 Re: Problem with LIKE-Performance
Previous Message Guido Neitzer 2006-04-18 15:43:51 Re: Problem with LIKE-Performance