Skip site navigation (1) Skip section navigation (2)

Re: performance impact of non-C locale

From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: Axel Rau <Axel(dot)Rau(at)chaos1(dot)de>
Cc: PostgreSQL Performance <pgsql-performance(at)postgresql(dot)org>
Subject: Re: performance impact of non-C locale
Date: 2008-09-11 10:33:41
Message-ID: 48C8F405.8080508@gmx.net (view raw or flat)
Thread:
Lists: pgsql-performance
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.

In response to

pgsql-performance by date

Next:From: Laszlo NagyDate: 2008-09-11 16:29:36
Subject: Choosing a filesystem
Previous:From: Axel RauDate: 2008-09-11 09:57:04
Subject: Re: performance impact of non-C locale

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group