Re: Index not used, performance problem

Поиск
Список
Период
Сортировка
От John K. Herreshoff
Тема Re: Index not used, performance problem
Дата
Msg-id 200303291149.00790.jkherr@centurytel.net
обсуждение исходный текст
Ответ на Re: Index not used, performance problem  (Andrew Sullivan <andrew@libertyrms.info>)
Ответы Re: Index not used, performance problem  (Jord Tanner <jord@indygecko.com>)
Список pgsql-performance
In Linux (Redhat) where, exactly, does one set the LOCALE to C?

TIA :-)

John.

On Saturday 29 March 2003 10:34 am, Andrew Sullivan wrote:
> 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


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

Предыдущее
От: Andrew Sullivan
Дата:
Сообщение: Re: Index not used, performance problem
Следующее
От: Andreas Kostyrka
Дата:
Сообщение: Re: Index not used, performance problem