Re: lower and unicode

Поиск
Список
Период
Сортировка
От Miroslav Šulc
Тема Re: lower and unicode
Дата
Msg-id 42358A3F.6090400@startnet.cz
обсуждение исходный текст
Ответ на Re: lower and unicode  (pginfo <pginfo@t1.unisoftbg.com>)
Список pgsql-sql
pginfo wrote:

> Hi,
> I am using --no-locale by init db.
> I readet that if I am using some locale the pg will work very slow.

I don't remember reading it will be very slow. I just remember that I've
read it will slow down some things (which I think is logical in this case).

> Have you noticed some speed penalty by using cs_CZ.utf8.

When using PostgreSQL, I need correct collating order for strings so I
have no other choice. I didn't do any speed tests but I think if you
need correct behaviour for your locale, you should use your locale. Just
try it and you will see the results. You can then make a decision for
yourself. I think you won't be the only one using locale for your
database ;-)

> regards,
> ivan.

Miroslav

Вложения

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

Предыдущее
От: pginfo
Дата:
Сообщение: Re: lower and unicode
Следующее
От: Rod Taylor
Дата:
Сообщение: Re: Newbie wonder...