Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-performance by date

Next:From: Tom LaneDate: 2006-04-18 15:45:39
Subject: Re: Problem with LIKE-Performance
Previous:From: Guido NeitzerDate: 2006-04-18 15:43:51
Subject: Re: Problem with LIKE-Performance

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group