WHAT'S INSIDE
- Full-text search — tsvector / tsquery / ts_rank, GIN-indexed
- pgvector-compatible vector type — <-> L2, <#> inner, <=> cosine
- KNN queries: ORDER BY embedding <-> $1 LIMIT k
- HNSW / IVF approximate-nearest-neighbor index*
*In development — not yet production-ready.
vector KNN
CREATE TABLE items (id int, embedding vector(3));
SELECT id FROM items ORDER BY embedding <-> '[3,3,3]' LIMIT 5; -- <-> L2, <#> inner, <=> cosine
THE REST OF THE ENGINE