X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.224.192]) by svr1.postgresql.org (Postfix) with ESMTP id 7E85BD1C929 for ; Mon, 21 Jul 2003 08:28:58 +0000 (GMT) Received: from svr1.postgresql.org ([64.117.224.193]) by localhost (svr4.postgresql.org [64.117.224.192]) (amavisd-new, port 10024) with ESMTP id 67197-02 for ; Mon, 21 Jul 2003 08:28:56 +0000 (GMT) Received: from mail.deltav.hu (oldmail.deltav.hu [213.163.0.192]) by svr1.postgresql.org (Postfix) with ESMTP id BF967D1C928 for ; Mon, 21 Jul 2003 05:28:55 -0300 (ADT) Received: from fejleszt4 ([213.163.10.103]) by mail.deltav.hu (Netscape Messaging Server 3.6) with SMTP id AAA2F12 for ; Mon, 21 Jul 2003 10:25:55 +0200 Message-ID: <012201c34f61$b20993e0$0403a8c0@fejleszt4> From: =?ISO-8859-1?Q?SZUCS_G=E1bor?= To: References: <1057587455.6466.26.camel@takin.private.nexcerpt.com> <200307071540.30041.dev@archonet.com> Subject: Re: Optimizer differences between 7.2 and 7.3 Date: Mon, 21 Jul 2003 10:25:51 +0200 MIME-Version: 1.0 Content-Type: text/plain; charset="ISO-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2800.1158 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165 X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200307/320 X-Sequence-Number: 2613 A bit OT: do regex ops (~, ~*) use index scan in non-"C" locales? Is it worth to convert LIKE to regex? G. ------------------------------- cut here ------------------------------- ----- Original Message ----- From: "Richard Huxton" Sent: Monday, July 07, 2003 4:40 PM Check the locale the database was initdb'd to. You'll probably find 7.2.4 is in the "C" locale whereas 7.3.3 isn't. The "like" comparison can only use indexes in the "C" locale. I believe you might need to initdb again to fix this. -- Richard Huxton ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html