Re: Index not used, performance problem

Поиск
Список
Период
Сортировка
От Andrew Sullivan
Тема Re: Index not used, performance problem
Дата
Msg-id 20030329103452.B16250@mail.libertyrms.com
обсуждение исходный текст
Ответ на Re: Index not used, performance problem  (Christopher Kings-Lynne <chriskl@familyhealth.com.au>)
Ответы Re: Index not used, performance problem  ("John K. Herreshoff" <jkherr@centurytel.net>)
Список pgsql-performance
On Sat, Mar 29, 2003 at 09:47:51PM +0800, Christopher Kings-Lynne wrote:
> the form 'FOO%', which is what you are doing.  However, I believe that
> PostgreSQL cannot do this if your database encoding is anything other than
> 'C'.  So, if you are using an Austrian encoding, it might not be able to

That is, you need to have had the LOCALE set to 'C' when you did
initdb.  It's not enough to change it afterwards.

A
--
----
Andrew Sullivan                         204-4141 Yonge Street
Liberty RMS                           Toronto, Ontario Canada
<andrew@libertyrms.info>                              M2P 2A8
                                         +1 416 646 3304 x110


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

Предыдущее
От: Christopher Kings-Lynne
Дата:
Сообщение: Re: Index not used, performance problem
Следующее
От: "John K. Herreshoff"
Дата:
Сообщение: Re: Index not used, performance problem