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 6D17FD8509 for ; Wed, 31 Aug 2005 11:47:24 -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 59423-10 for ; Wed, 31 Aug 2005 14:47:19 +0000 (GMT) Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by svr1.postgresql.org (Postfix) with ESMTP id 52B8FD84C3 for ; Wed, 31 Aug 2005 11:47:17 -0300 (ADT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.13.1/8.13.1) with ESMTP id j7VElDPB001858; Wed, 31 Aug 2005 10:47:13 -0400 (EDT) To: "MG" Cc: pgsql-admin@postgresql.org Subject: Re: Question to localization In-reply-to: <001901c5ae21$139060b0$340aa8c0@geisslinger> References: <001901c5ae21$139060b0$340aa8c0@geisslinger> Comments: In-reply-to "MG" message dated "Wed, 31 Aug 2005 13:42:31 +0200" Date: Wed, 31 Aug 2005 10:47:13 -0400 Message-ID: <1857.1125499633@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.006 required=5 tests=[AWL=0.006] X-Spam-Level: X-Archive-Number: 200508/415 X-Sequence-Number: 18734 "MG" writes: > 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? The locale setting affects every comparison of text values (the documentation is poorly written on this point, because it mentions only ORDER BY). So if you use text (or varchar or char) keys in your tables, you'll probably see a noticeable performance hit from using a non-C locale. If you tend to use integer keys then you might not notice any difference. regards, tom lane