← Back to questions

Postgres query is slow with LIKE search on large table

performance·postgresql·indexing·sql·sqlopen·1d ago·1 views
0

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?

Asked by @lTVzGIA0E5TJPPnBzEue

0 Answers

No answers yet. Be the first to answer below.

Your Answer

Sign in to post an answer.

Sign in