X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 4E961D7CF2 for ; Wed, 31 Aug 2005 08:43:17 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 07809-09 for ; Wed, 31 Aug 2005 11:43:11 +0000 (GMT) Received: from server051.webpack.hosteurope.de (server051.webpack.hosteurope.de [80.237.130.59]) by svr1.postgresql.org (Postfix) with ESMTP id E68FCD7CED for ; Wed, 31 Aug 2005 08:43:10 -0300 (ADT) Received: by server051.webpack.hosteurope.de running Exim 4.51 using esmtpa from [213.172.114.97] (helo=geisslinger) id 1EAQzo-0007HB-AR; Wed, 31 Aug 2005 13:43:12 +0200 Message-ID: <001901c5ae21$139060b0$340aa8c0@geisslinger> From: "MG" To: Subject: Question to localization Date: Wed, 31 Aug 2005 13:42:31 +0200 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0016_01C5AE31.D6155540" X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2900.2180 X-MIMEOLE: Produced By Microsoft MimeOLE V6.00.2900.2180 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.096 required=5 tests=[HTML_50_60=0.095, HTML_MESSAGE=0.001] X-Spam-Level: X-Archive-Number: 200508/412 X-Sequence-Number: 18731 This is a multi-part message in MIME format. ------=_NextPart_000_0016_01C5AE31.D6155540 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hello, I have a question to the usage of locale. In the PostgreSQL 8.0.3 Documentation is written: "The drawback of using locales other than C or POSIX in PostgreSQL is = its performance impact. It slows character handling and prevents = ordinary indexes from being used by LIKE. For this reason use locales = only if you actually need them. " Is there a general perfomance deficit, when using locales or only when = using LIKE? Regards Michaela ------=_NextPart_000_0016_01C5AE31.D6155540 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
Hello,
 
I have a question to the usage of locale.
 
In the PostgreSQL 8.0.3 Documentation is written:
"The drawback of using locales other than C or=20 POSIX in PostgreSQL is its=20 performance impact. It slows character handling and prevents ordinary = indexes=20 from being used by LIKE. For this reason use = locales only=20 if you actually need them. "
 
Is there a general perfomance deficit, when using locales = or only=20 when using LIKE?
 
Regards
Michaela
------=_NextPart_000_0016_01C5AE31.D6155540--