but y not just a vector database like pgvector?
Often you take the results from both vector search and lexical search and merge them through algorithms like Reciprocal Rank Fusion.
Which works great when you want to retrieve documents that actually contain the specific keywords in your search query, as opposed to using embeddings to find something roughly in the same semantic ballpark.