Postgres Full-Text Search: A search engine in a database
I used Postgres full-text search for mail log feature on my email forward app https://hanami.runEssentially 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 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.