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
- [GENERAL] GetHierarchy bhanu udaya
- Re: [GENERAL] GetHierarchy Alban Hertroys
- [GENERAL] Postgres DB crashing bhanu udaya
- Re: [GENERAL] Postgres DB crashing AI Rumman
- Re: [pgadmin-support] [GENERAL] Postgres DB ... bhanu udaya
- Re: [GENERAL] Postgres DB crashing John R Pierce
- Re: [GENERAL] Postgres DB crashing Richard Huxton
- Re: [GENERAL] Postgres DB crashing Merlin Moncure
- Re: [GENERAL] Postgres DB crashing Alan Hodgson
- Re: [GENERAL] Postgres DB crashing Tom Lane
- [GENERAL] Postgres case insensitive searches bhanu udaya
- Re: [GENERAL] Postgres case insensitive sear... Albe Laurenz
- Re: [GENERAL] Postgres case insensitive ... bhanu udaya
- Re: [GENERAL] Postgres case insensi... John R Pierce
- Re: [GENERAL] Postgres case insensi... Alban Hertroys
- Re: [pgadmin-support] [GENERAL]... bhanu udaya
- Re: [pgadmin-support] [GENE... Alban Hertroys
- Re: [GENERAL] Postgres case... Lee Hachadoorian
- Re: [pgadmin-support] [GENE... bhanu udaya
- Re: [GENERAL] Postgres case insensi... Albe Laurenz
- Re: [GENERAL] Postgres case ins... Ingmar Brouns
