How to Efficiently Search for 1milion+ Users in Postgresql and Rails?
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 lo...
![](https://secure.gravatar.com/avatar/61a2f68a50b92c2d9242e4e9c0ad1884.png?default=mp&rating=pg&size=48)