Re: Problem with LIKE-Performance - Mailing list pgsql-performance

Dave Dutcher a écrit :
> It looks like you are getting a sequential scan instead of an index
> scan.  What is your locale setting?  As far as I know Postgres doesn't
> support using indexes with LIKE unless you are using the C locale.
>
It does if you create your index this way :

CREATE INDEX idx_image_title
  ON image
  USING btree
  (title varchar_pattern_ops);

Please see http://www.postgresql.org/docs/8.1/interactive/indexes-opclass.html


Thomas