Integrating pinecone into pgvector

Hey everyone,

pgvector-remote is an extension designed to effortlessly incorporate remote vector stores, like Pinecone, into pgvector. With pgvector-remote, harnessing the power of a remote (Pinecone) index becomes as easy as utilizing ivfflat or hnsw.

Key Features:

  • Achieve <10ms latency and 200QPS throughput, similar to Pinecone.
  • Enjoy metadata filtering capabilities, just like Pinecone.
  • Benefit from SQL compatibility and transaction support akin to PostgreSQL.

Usage: CREATE INDEX ON items USING PINECONE (embedding);

We’re continuously enhancing pgvector-remote and would love to hear your feedback!