Why PostgreSQL and not MySQL ?

[Maximilian_Tyrtania]

I hear what you are all saying about using CITEXT and ILIKE, but I have found they still search EVERY record so are just as slow as UPPER(). If I use LIKE ‘fred%’ it will not match ‘Frederick’, and username ILIKE ‘fred’ is as slow as UPPER(username) = ‘FRED’ since they both have to convert every field.

Try this (if username is a text column):

CREATE INDEX test_index ON test_table (username text_pattern_ops);