pgembedding

Base model for all SQL stores.

Collection store.

Embedding store.

Result from a query.

Postgres with the pg_embedding extension as a vector store.

pg_embedding uses sequential scan by default. but you can create a HNSW index using the create_hnsw_index method.

• connection_string is a postgres connection string.
• embedding_function any embedding function implementing langchain.embeddings.base.Embeddings interface.
• collection_name is the name of the collection to use. (default: langchain)
  • NOTE: This is not the name of the table, but the name of the collection. The tables will be created when initializing the store (if not exists) So, make sure the user has the right permissions to create tables.
• distance_strategy is the distance strategy to use. (default: EUCLIDEAN)
  • EUCLIDEAN is the euclidean distance.
• pre_delete_collection if True, will delete the collection if it exists. (default: False)
  • Useful for testing.