Neil Saunders <n(dot)j(dot)saunders(at)gmail(dot)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