Horton

Re: performance impact of non-C locale

Axel Rau <axel.rau@chaos1.de>

View thread View on postgr.es
From: Axel Rau <Axel.Rau@chaos1.de>
To: Peter Eisentraut <peter_e@gmx.net>
Cc: PostgreSQL Performance <pgsql-performance@postgresql.org>
Date: 2008-09-11T09:57:04Z
Lists: pgsql-performance 
Am 11.09.2008 um 11:29 schrieb Peter Eisentraut:

>>
>> What other performance impacts can be expected?
>
> The performance impact is mainly with string comparisons and sorts.   
> I suggest you run your own tests to find out what is acceptable in  
> your scenario.
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)

Axel
---