select like...not using index

Поиск
Список
Период
Сортировка
От Merlin Moncure
Тема select like...not using index
Дата
Msg-id 6EE64EF3AB31D5448D0007DD34EEB34101AE43@Herge.rcsinc.local
обсуждение исходный текст
Ответы Re: select like...not using index
Re: [pgsql-hackers-win32] select like...not using index
Список pgsql-hackers
Sometime between yesterday and today queries in the form of
"select * from t where t.f like 'k%'" have been broken so that they
never use the index (on win32, not sure about others).

On win32, at least, they have been broken for a while but this was due
to a known issue based on the locales.  AFAICT, the current cvs has
addressed this issue and (show lc_collate returns C) there seems to be
no reason why the queries aren't working properly.

Merlin


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

Предыдущее
От: Alvaro Herrera
Дата:
Сообщение: Re: SELECT * FROM LIMIT 1; is really slow
Следующее
От: "Marc G. Fournier"
Дата:
Сообщение: Re: Win32, PITR, nested transactions, tablespaces