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.
