performance impact of non-C locale

Поиск
Список
Период
Сортировка
От Axel Rau
Тема performance impact of non-C locale
Дата
Msg-id 47B44B1F-2DE2-4E7F-97C6-1599510AD8F1@Chaos1.DE
обсуждение исходный текст
Ответы Re: performance impact of non-C locale  (Peter Eisentraut <peter_e@gmx.net>)
Список pgsql-performance
Hi everyone,

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?

Does postmaster keep track on any multibyte characters being inserted
in such columns, so that the planner can adapt?

What other performance impacts can be expected?

Axel
---


В списке pgsql-performance по дате отправления:

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: SAN and full_page_writes
Следующее
От: Duan Ligong
Дата:
Сообщение: Re: too many clog files