On 14/02/11 06:59, Gnanakumar wrote:
How can we boost performance of queries containing pattern matching characters?
QUERY: DELETE FROM MYTABLE WHERE EMAIL ILIKE '%domain.com%'
As it is clear from the above query, email is matched "partially and case-insensitively", which my application requirement demands.
Well, for that exact pattern you're not going to find an index that's much help. Do you really need something so wide-ranging though? The above will match all of the following:
[email protected] [email protected] [email protected] [email protected] [email protected] [email protected] [email protected] [email protected] [email protected] Is that really what you are after? Or, did you just want to match: [email protected] [email protected] -- Richard Huxton Archonet Ltd -- Sent via pgsql-performance mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
