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!
In response to
pgsql-performance by date
|Next:||From: Tom Lane||Date: 2006-04-18 15:45:39|
|Subject: Re: Problem with LIKE-Performance |
|Previous:||From: Guido Neitzer||Date: 2006-04-18 15:43:51|
|Subject: Re: Problem with LIKE-Performance|