Re: How to boost performance of queries containing pattern matching characters

Поиск
Список
Период
Сортировка
Искать
От
Gnanakumar
Тема
Re: How to boost performance of queries containing pattern matching characters
Дата
Msg-id
004701cbcc18$c54c8980$4fe59c80$@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>
> Is that really what you are after? Or, did you just want to match:
>    user1@domain.com
>    user2@sub.domain.com

I understand that because I've (%) at the beginning and end, it's going to
match unrelated domains, etc., which as you said rightly, it is
wide-ranging.  But my point here is that how can I improve performance of
the queries containing pattern matching characters.

В списке pgsql-performance по дате отправления
От: Richard Huxton
Дата:
От: Richard Huxton
Дата:
FAQ