Re: How to boost performance of queries containing pattern matching characters - Mailing list pgsql-performance

From Gnanakumar
Subject Re: How to boost performance of queries containing pattern matching characters
Date
Msg-id 004701cbcc18$c54c8980$4fe59c80$@com
Whole thread Raw
In response to Re: How to boost performance of queries containing pattern matching characters  (Richard Huxton <dev@archonet.com>)
Responses 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>)
List 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 by date:

Previous
From: Richard Huxton
Date:
Subject: Re: How to boost performance of queries containing pattern matching characters
Next
From: Richard Huxton
Date:
Subject: Re: How to boost performance of queries containing pattern matching characters