Re: performance impact of non-C locale - Mailing list pgsql-performance

From Axel Rau
Subject Re: performance impact of non-C locale
Date
Msg-id 8922E1A9-A013-4200-96D3-CDAD99C29530@chaos1.de
Whole thread Raw
In response to Re: performance impact of non-C locale  (Peter Eisentraut <peter_e@gmx.net>)
Responses Re: performance impact of non-C locale  (Peter Eisentraut <peter_e@gmx.net>)
List 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
---


pgsql-performance by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: performance impact of non-C locale
Next
From: Peter Eisentraut
Date:
Subject: Re: performance impact of non-C locale