From: Tarabas (Manuel Rorarius) <tarabas@tarabas.de>
To: Hakan Kocaman <Hakan.Kocaman@digame.de>
Cc: pgsql-performance@postgresql.org
Subject: Re: [bulk] RE: Problem with LIKE-Performance
Date: Tue, 18 Apr 2006 17:43:53 +0200
Message-ID: <14334544.20060418174353@tarabas.de> (raw)
In-Reply-To: <84AAD313D71B1D4F9EE20E739CC3B6EDE96F24@ATLANTIK-CL.intern.digame.de>
References: <84AAD313D71B1D4F9EE20E739CC3B6EDE96F24@ATLANTIK-CL.intern.digame.de>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: tarabas@tarabas.de, Hakan.Kocaman@digame.de
Subject: Re: [bulk] RE: Problem with LIKE-Performance
In-Reply-To: <14334544.20060418174353@tarabas.de>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox