Hacker News new | ask | show | jobs
by __newmoon__ 987 days ago
Postgres with PGVector is the best database, plus vectors.

All of the "Vector DBs" suffer horribly when trying to do basic things.

Want to include any field that matches a field in an array of keys? Easy in SQL. Requires an entire song and dance in Pinecone or Weaviate.

After implementing Chroma, Weaviate, Pinecone, Sqlite with HNSW indices and Qdrant-- I'm not impressed. Postgres is measurably faster since so much relies on pre-filtering, joins, etc.

1 comments

This will be solved in Weaviate https://github.com/weaviate/weaviate/issues/2424