Postgres case insensitive searches

Поиск
Список
Период
Сортировка
От bhanu udaya
Тема Postgres case insensitive searches
Дата
Msg-id COL127-W20F6AB97900F1D8ACC8169D3760@phx.gbl
обсуждение исходный текст
Ответ на Postgres DB crashing  (bhanu udaya <udayabhanu1984@hotmail.com>)
Ответы Re: Postgres case insensitive searches  (Albe Laurenz <laurenz.albe@wien.gv.at>)
Re: Postgres case insensitive searches  ("Joshua D. Drake" <jd@commandprompt.com>)
Список pgsql-general
Hello,
 
Grettings,
 
What is the best way of doing case insensitive searches in postgres using Like.
 
Ilike - does not use indexes
function based indexes are not as fast as required.
CITEXT - it still taking 600 ms - 1 second on a 2.2 million rows... does not use index
Collation Indexes creation with POSIX - does not really work.
GIST/GIN indexes are faster when using like, but not case insenstive.
 
Is there a better way of resolving this case insenstive searches with fast retrieval.
 
Thanks and Regards
Radha Krishna
 

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

Предыдущее
От: Vincent Veyron
Дата:
Сообщение: Re: utf8 errors
Следующее
От: Phoenix Kiula
Дата:
Сообщение: How to REMOVE an "on delete cascade"?