Alternatively you could use a trigram index which i've used in the past successfully to speed up queries using like '%gmail.com'. Blogpost discussing this appr

Alternatively you could use a trigram index which i've used in the past successfully to speed up queries using like '%gmail.com'. Blogpost discussing this approach: https://about.gitlab.com/blog/2016/03/18/fast-search-using-postgresql-trigram-indexes/ https://about.gitlab.com/blog/2016/03/18/fast-search-using-p...