Andres Freund <andres@xxxxxxxxxxx> writes: > On Monday 05 April 2010 16:28:35 Oliver Kindernay wrote: >> i am using this request: >> select url from test2 where url ~* '^URLVALUE\\s*$'; > Depending on your locale it might be sensible to create a text_pattern_ops > index - see the following link: > http://www.postgresql.org/docs/current/static/indexes-opclass.html text_pattern_ops won't help for a case-insensitive search. The best bet here would be to index on a case-folded, blank-removed version of the url, viz create index ... on (normalize(url)) select ... where normalize(url) = normalize('URLVALUE') where normalize() is a suitably defined function. Or if it's okay to only store the normalized form of the string, you could simplify that a bit. regards, tom lane -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
