performance impact of non-C locale

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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
---



[Postgresql General]     [Postgresql PHP]     [PHP Users]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Yosemite]

  Powered by Linux