How to boost performance of queries containing pattern matching characters
От
Gnanakumar
Тема
How to boost performance of queries containing pattern matching characters
Дата
Msg-id
004601cbcc14$acfe99d0$06fbcd70$@com
Список
Дерево обсуждения
How to boost performance of queries containing pattern matching characters "Gnanakumar" <gnanam@zoniac.com>
Re: How to boost performance of queries containing pattern
matching characters Richard Huxton <dev@archonet.com>
Re: How to boost performance of queries containing pattern matching characters "Gnanakumar" <gnanam@zoniac.com>
Re: How to boost performance of queries containing pattern matching characters Artur Zając <azajac@ang.com.pl>
Re: How to boost performance of queries containing pattern
matching characters Richard Huxton <dev@archonet.com>
Re: How to boost performance of queries containing pattern matching characters Artur Zając <azajac@ang.com.pl>
Re: How to boost performance of queries containing pattern matching characters Steve Atkins <steve@blighty.com>
Re: How to boost performance of queries containing pattern
matching characters Richard Huxton <dev@archonet.com>
Re: How to boost performance of queries containing pattern matching characters "Gnanakumar" <gnanam@zoniac.com>
Re: How to boost performance of queries containing pattern
matching characters Richard Huxton <dev@archonet.com>
Re: How to boost performance of queries containing pattern matching characters "Gnanakumar" <gnanam@zoniac.com>
Re: How to boost performance of queries containing pattern
matching characters Greg Smith <greg@2ndquadrant.com>
Re: How to boost performance of queries containing pattern
matching characters Shaun Thomas <sthomas@peak6.com>
Hi, How can we boost performance of queries containing pattern matching characters? In my case, we're using a percent sign (%) that matches any string of zero or more characters. QUERY: DELETE FROM MYTABLE WHERE EMAIL ILIKE '%domain.com%' EMAIL column is VARCHAR(256). As it is clear from the above query, email is matched "partially and case-insensitively", which my application requirement demands. In case, if it were a full match, I could easily define a functional INDEX on EMAIL column (lower(EMAIL)) and I could rewrite my DELETE where criteria like lower(EMAIL) = 'someemail@domain.com'. MYTABLE currently contains 2 million records and grows consistently. Regards, Gnanam
В списке pgsql-performance по дате отправления
От: Richard Huxton
Дата: