I used Postgres full-text search for mail log feature on my email forward app https://hanami.run https://hanami.run Essentially allow arbitraty query in from/t

I used Postgres full-text search for mail log feature on my email forward app https://hanami.run https://hanami.run Essentially allow arbitraty query in from/to/subject/body. One thing that make full-text serch work great for me is that I don't need to sort or rank the relevant of query. I just show a list of email that match the query order by their id. I also don't do pagination and counting, instead users has to load more paged and the ID of the email is pass to the query as a point to compare( where id < requests.get.before). And with those strategy, full text search works great for us since we don't really want to bring in ElasticSearch because only about 20% of users use this features.