Re: performance impact of non-C locale

From: Axel Rau <Axel(dot)Rau(at)chaos1(dot)de>
To: Peter Eisentraut <peter_e(at)gmx(dot)net>
Cc: PostgreSQL Performance <pgsql-performance(at)postgresql(dot)org>
Subject: Re: performance impact of non-C locale
Date: 2008-09-11 09:57:04
Message-ID: 8922E1A9-A013-4200-96D3-CDAD99C29530@chaos1.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
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
---

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Peter Eisentraut 2008-09-11 10:33:41 Re: performance impact of non-C locale
Previous Message Peter Eisentraut 2008-09-11 09:29:43 Re: performance impact of non-C locale