Question

Postgres query is slow with LIKE search on large table

4993220e-2406-489f-89b1-dd847e7da617

I have a users table with 2 million rows and this query is taking over 10 seconds:

SELECT * FROM users WHERE email LIKE "%@example.com"

I have an index on the email column but it is not being used. How can I make this search faster?