LlamaIndex
Log in

Find answers from the community

Updated 3 months ago

Hi, is there a way to use a postgres

MMauricio
·
Hi, is there a way to use a postgres vector store (pgvector) as a docstore? All the data is actually already there.

Specifically, what I want to do, is use the data we already store in pgvector to build a QueryFusionRetriever, with a vector_retriever and a bm25retriever. In theory, I should be able to perform bm25 retrieval in the postgres database, but the bm25retriever can only be initilised with a docstore.

I also found out this sparse vector_store_query_mode, but I believe thats only for hybrid text search, so not what I am looking for.

Any ideas on how can I achieve this?
L
M
3 comments
LLogan M
bm25 retriever can also be initialized with the list of nodes (this is all it uses the docstore for, it needs to build the index in memory)
MMauricio
and is there a way to get all the nodes from a vector store?
LLogan M
retrieve with a top k of 10000 ?
Add a reply
Sign up and join the conversation on Discord