Received: from localhost (unknown [200.46.204.183])
	by postgresql.org (Postfix) with ESMTP id CFA7264FCD2
	for <pgsql-performance-postgresql.org@postgresql.org>;
	Thu, 11 Sep 2008 07:33:35 -0300 (ADT)
Received: from postgresql.org ([200.46.204.86])
	by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024)
	with ESMTP id 75078-06 for
	<pgsql-performance-postgresql.org@postgresql.org>;
	Thu, 11 Sep 2008 07:33:35 -0300 (ADT)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.6
Received: from gattler.pezone.net (eisentraut.org [85.214.91.16])
	by postgresql.org (Postfix) with ESMTP id 3224464FD17
	for <pgsql-performance@postgresql.org>;
	Thu, 11 Sep 2008 07:33:33 -0300 (ADT)
Received: from dhcp-eesp05-101-109.Finland.Sun.COM (gmp-ea-fw-1.sun.com
	[192.18.1.36])
	by gattler.pezone.net (Postfix) with ESMTP id 233A715F0824;
	Thu, 11 Sep 2008 10:33:29 +0000 (UTC)
Message-ID: <48C8F405.8080508@gmx.net>
Date: Thu, 11 Sep 2008 13:33:41 +0300
From: Peter Eisentraut <peter_e@gmx.net>
User-Agent: Thunderbird 2.0.0.16 (Macintosh/20080707)
MIME-Version: 1.0
To: Axel Rau <Axel.Rau@chaos1.de>
CC: PostgreSQL Performance <pgsql-performance@postgresql.org>
Subject: Re: performance impact of non-C locale
References: <47B44B1F-2DE2-4E7F-97C6-1599510AD8F1@Chaos1.DE>
	<48C8E507.1090100@gmx.net>
	<8922E1A9-A013-4200-96D3-CDAD99C29530@chaos1.de>
In-Reply-To: <8922E1A9-A013-4200-96D3-CDAD99C29530@chaos1.de>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 8bit
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Archive-Number: 200809/133
X-Sequence-Number: 31446

Axel Rau wrote:
> Im not yet convinced to switch to non-C locale. Is the following 
> intended behavior:
> With lc_ctype  C:          select lower('ÄÖÜ'); => ÄÖÜ
> With lc_ctype  en_US.utf8  select lower('ÆÅË'); => æåë
> ? (Both have server encoding UTF8)

I would expect exactly that.