🔎pgvector
Also known as pgvector Extension, Postgres Vector Extension
A free add-on for Postgres. It lets the database store and search vectors.
Think of it like
It is like adding a new drawer to a desk you already own. No new desk needed.
Example
Lucy's shop already runs on Postgres. She adds pgvector and stores a vector for each product. One SQL query finds items like it.
Why it matters
Many teams already run Postgres. They get vector search without a new system to learn and pay for.
Definition
Example code
sql
CREATE EXTENSION vector;
CREATE TABLE items (id bigserial PRIMARY KEY, embedding vector(3));
SELECT * FROM items ORDER BY embedding <-> '[3,1,2]' LIMIT 5;Common mistake
Key takeaways
- 1Inside Postgres. Vectors sit beside your other data.
- 2Plain SQL. Sort by distance and limit.
- 3Add an index. HNSW or IVFFlat for speed.