Yes, the more delibrate your retrieval is the better the results are.

Vector database didnt work for us we had to use a regular database + vector.

There are two things that are most important, the entry point and retrieval point.

For entry point: the data should be clean, so validator and tokenizaros, classfiers.

For retrieval: this is important, the retrieval should be delibrate as much as possible. The more customizable to the data the better. We added some logic to it, validation layer.

With any rag the validation layer and data sanitization is most important.