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
обсуждение исходный текст
Ответ на 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  (Richard Huxton <dev@archonet.com>)
Re: How to boost performance of queries containing pattern matching characters  (Artur Zając <azajac@ang.com.pl>)
Список pgsql-performance
> 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
Дата:
Сообщение: Re: How to boost performance of queries containing pattern matching characters
Следующее
От: Richard Huxton
Дата:
Сообщение: Re: How to boost performance of queries containing pattern matching characters