I'm not the person you're replying to, but does Postgres nowadays have a straightforward way to do tf-idf or BM25-style information retrieval?
I commented below - I highly recommend Xapian for small projects to test the waters. It’s the SQLite if search.