New Discussion

Notifications

You’re not receiving notifications from this thread.

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

0
Databases
Denis Omerovic Denis Omerovic

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