Hi, why not Sphinx search ? I am not familiar with PostgreSQL but would it not face issues with big communities and high activity? If so, then i recommend Sphinx, it is light and doesn’t add stress on the server. It is great actually =)
Is there any future plan for it? allowing two options may be ? One that can use the Sphinx and another to use PostgreSQL. I am not sure if Sphinx works with Ruby. I am not familiar with this part.
I only found this GitHub - pat/thinking-sphinx: Sphinx/Manticore plugin for ActiveRecord/Rails · GitHub