From: Peter Eisentraut <peter_e@gmx.net>
To: Axel Rau <Axel.Rau@chaos1.de>
Cc: PostgreSQL Performance <pgsql-performance@postgresql.org>
Subject: Re: performance impact of non-C locale
Date: Thu, 11 Sep 2008 12:29:43 +0300
Message-ID: <48C8E507.1090100@gmx.net> (raw)
In-Reply-To: <47B44B1F-2DE2-4E7F-97C6-1599510AD8F1@Chaos1.DE>
References: <47B44B1F-2DE2-4E7F-97C6-1599510AD8F1@Chaos1.DE>
Axel Rau wrote:
> some erp software requires a change of my pgsql cluster from
> locale C encoding UTF-8
> to
> locale de_DE.UTF-8 encoding UTF-8
>
> Most of my databases have only ASCII text data (8 bit UTF8 code range)
> in the text columns.
> Does the above change influence index performance on such columns?
Yes.
> Does postmaster keep track on any multibyte characters being inserted in
> such columns, so that the planner can adapt?
No.
> 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.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: peter_e@gmx.net, Axel.Rau@chaos1.de
Subject: Re: performance impact of non-C locale
In-Reply-To: <48C8E507.1090100@gmx.net>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox