BM25 in Postgres is a solid move, most teams skip full-text search entirely and jump straight to vector DBs, missing that hybrid ranking often outperforms either alone for real product relevance.