X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (mx2.hub.org [200.46.204.254]) by postgresql.org (Postfix) with ESMTP id AA71911F6004 for ; Tue, 18 Apr 2006 12:44:08 -0300 (ADT) X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Score: -2.599 X-Spam-Level: X-Spam-Status: No, score=-2.599 required=5 tests=[AWL=0.000, BAYES_00=-2.599] Received: from postgresql.org ([200.46.204.71]) by localhost (mx2.hub.org [200.46.204.254]) (amavisd-new, port 10024) with ESMTP id Zy06R6NuG+vz for ; Tue, 18 Apr 2006 12:43:57 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from mail.mediaskill.de (destiny.mediaskill.de [212.91.236.1]) by postgresql.org (Postfix) with ESMTP id 7BB6511F607B for ; Tue, 18 Apr 2006 12:43:55 -0300 (ADT) Received: from localhost ([127.0.0.1]) by mail.mediaskill.de (Merak 8.3.8) with SMTP id WTJ32854; Tue, 18 Apr 2006 17:43:54 +0200 Date: Tue, 18 Apr 2006 17:43:53 +0200 From: "Tarabas (Manuel Rorarius)" X-Mailer: The Bat! (v3.62.14) Professional Reply-To: "Tarabas (Manuel Rorarius)" Organization: mediaskill X-Priority: 3 (Normal) Message-ID: <14334544.20060418174353@tarabas.de> To: "Hakan Kocaman" CC: pgsql-performance@postgresql.org Subject: Re: [bulk] RE: Problem with LIKE-Performance In-Reply-To: <84AAD313D71B1D4F9EE20E739CC3B6EDE96F24@ATLANTIK-CL.intern.digame.de> References: <84AAD313D71B1D4F9EE20E739CC3B6EDE96F24@ATLANTIK-CL.intern.digame.de> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Archive-Number: 200604/381 X-Sequence-Number: 18465 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