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 t

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.