Postgres Pro
Downloads
Home   >   mailing lists

Re: how to speed ilike - Mailing list pgsql-admin

From Dimitri Fontaine
Subject Re: how to speed ilike
Date
Msg-id 871vhd9qcs.fsf@hi-media-techno.com
Whole thread Raw
In response to Re: how to speed ilike  (Julius Tuskenis <julius@nsoft.lt>)
List pgsql-admin
Tree view 
Julius Tuskenis <julius@nsoft.lt> writes:
> Tried that too, but seem to me that ILIKE doesn't use the index. I'm using
> username ilike '%blablabla%' , so maybe theres no way for ilike to benefit
> from an index.

See pg_trgm and Full Text Search.

  http://www.postgresql.org/docs/8.4/interactive/pgtrgm.html
  http://www.postgresql.org/docs/8.4/interactive/textsearch.html

Regards,
--
dim

pgsql-admin by date:

Previous
From: "Igor Neyman"
Date:
Subject: relation between records in "main" and "toast" tables
Next
From: "Julien Theulier"
Date:
Subject: Settings for aggressive vacuum