Postgres Pro
Downloads
Home   >   mailing lists

Re: Query appears not to recognise index (enable_seqscan=off) - Mailing list pgsql-novice

From Tom Lane
Subject Re: Query appears not to recognise index (enable_seqscan=off)
Date
Msg-id 5728.1240937542@sss.pgh.pa.us
Whole thread Raw
In response to Query appears not to recognise index (enable_seqscan=off)  (Neil Saunders <n.j.saunders@gmail.com>)
Responses Re: Query appears not to recognise index (enable_seqscan=off)  (Neil Saunders <n.j.saunders@gmail.com>)
List pgsql-novice
Tree view 
Neil Saunders <n.j.saunders@gmail.com> writes:
> And we're still running the sequential scan - My questions is why?

You're probably not in C locale.  Change locale or use a
text_pattern_ops index instead of a plain index on lower(name).
See
http://wiki.postgresql.org/wiki/FAQ#Why_are_my_queries_slow.3F_Why_don.27t_they_use_my_indexes.3F

            regards, tom lane

pgsql-novice by date:

Previous
From: Neil Saunders
Date:
Subject: Query appears not to recognise index (enable_seqscan=off)
Next
From: Neil Saunders
Date:
Subject: Re: Query appears not to recognise index (enable_seqscan=off)