Re: how to speed ilike

From: Dimitri Fontaine <dfontaine(at)hi-media(dot)com>
To: Julius Tuskenis <julius(at)nsoft(dot)lt>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: how to speed ilike
Date: 2010-01-26 09:18:11
Message-ID: 871vhd9qcs.fsf@hi-media-techno.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Julius Tuskenis <julius(at)nsoft(dot)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

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Julien Theulier 2010-01-26 18:38:50 Settings for aggressive vacuum
Previous Message Igor Neyman 2010-01-25 19:50:01 relation between records in "main" and "toast" tables