Re: Query appears not to recognise index (enable_seqscan=off)

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