Ask A Question


You’re not receiving notifications from this thread.

How to Efficiently Search for 1milion+ Users in Postgresql and Rails?

Denis Omerovic asked in Databases

I have a user model and around 1milion user records in my database and I'm using ILIKE to match the users by name or email. Sometimes it's very slow since I have a lot of records in my DB so I'm looking for a better way to search users. I would appreciate any suggestions.

Join the discussion
Create an account Log in

Want to stay up-to-date with Ruby on Rails?

Join 83,038+ developers who get early access to new tutorials, screencasts, articles, and more.

    We care about the protection of your data. Read our Privacy Policy.