Pinecone vector search as a PostgreSQL extension — three engines behind one index.
183
Pinecone vector search as a PostgreSQL extension — three engines behind one index. https://github.com/pinecone-io/pg_pinecone#pg_pinecone
docker run -d -e POSTGRES_PASSWORD=secret pineconeteam/pg_pinecone:latest
CREATE EXTENSION vector;
CREATE EXTENSION pg_pinecone;
CREATE TABLE items (id bigint PRIMARY KEY, embedding vector(3));
INSERT INTO items VALUES (1,'[1,2,3]'), (2,'[4,5,6]'), (3,'[7,8,9]');
SELECT pinecone.create_index('items', 'embedding'); -- native engine, no API key
SELECT id FROM items ORDER BY embedding <=> '[1,2,4]' LIMIT 2;```
Content type
Image
Digest
sha256:7b6fa7784…
Size
158.7 MB
Last updated
1 day ago
docker pull pineconeteam/pg_pinecone