the impact of encoding on performance.

Поиск
Список
Период
Сортировка
От Michael Ben-Nes
Тема the impact of encoding on performance.
Дата
Msg-id 422FF062.4070600@canaan.co.il
обсуждение исходный текст
Ответы Re: the impact of encoding on performance.  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
Hi All

Snip <<<
 The drawback of using locales other than C or POSIX in PostgreSQL is
its performance impact. It slows character handling and prevents
ordinary indexes from being used by LIKE. For this reason use locales
only if you actually need them.
snip;

What is the impact of the locale  on the server ? is it irelevant, small
or huge ?

Encoding of the DB impact performance too ? UTF8, 8859-8 ?

Thanks

--
--------------------------
Canaan Surfing Ltd.
Internet Service Providers
Ben-Nes Michael - Manager
Tel: 972-4-6991122
Cel: 972-52-8555757
Fax: 972-4-6990098
http://www.canaan.net.il
--------------------------


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

Предыдущее
От: Ulrich Wisser
Дата:
Сообщение: Re: Can't start PostgreSQL on Fedora Core3
Следующее
От: Shaun Clements
Дата:
Сообщение: Re: pl sql to check if table of table_name exists