Contents
In brief
For an AI agent a vector store is not only “find similar chunks fast.” It is memory with rules: who owns the row, what kind of memory it is, and whether keywords can mix with meaning. A Dev.to roundup compares Qdrant, Pinecone, Weaviate, pgvector, and Milvus on filtering, hybrid search, tenant isolation, and billion-scale quantization — not raw ANN alone.
What happened
Selection criteria have shifted. Teams once ranked engines by nearest-neighbour latency. Agent workloads care more about payload filters during graph traversal, hybrid exact-plus-dense retrieval, namespaces across sessions, and compression that cuts RAM by large fractions in production.
The matrix sketches clear fits. Qdrant (Rust, open source) is praised for in-HNSW filtering and binary quantization — a common pick for agent memory. Pinecone Serverless splits storage from compute and removes cluster ops. Weaviate is strong on modular retrieval and hybrid modes. pgvector keeps vectors next to relational data and ACID transactions. Milvus targets very large corpora on distributed Kubernetes.
The author’s short advice: Qdrant for filtered self-hosted memory; Pinecone when you refuse to operate an index; pgvector when the product already lives in PostgreSQL; Milvus when the scale is hundreds of millions of vectors.
Why it matters
An agent without solid memory isolation becomes a leak of other users’ preferences. Post-search filtering hurts recall; in-graph filtering is an engineering requirement, not a brochure checkbox. Hybrid search matters where code symbols and phrase meaning both count. Quantization is not a later optimisation — it is how you keep memory cost under control as sessions accumulate.
For a production-oriented treatment of the same class of systems, see vector databases in production.
In practice
- Write the agent scenario: multi-tenancy, memory updates, whether you need SQL joins against user profiles.
- Test filters during search, not after: reproduce over-filtering collapse on your own corpus.
- If PostgreSQL is already there and volume is moderate, measure
pgvectorbefore standing up a second cluster. - For self-hosted agent memory, compare Qdrant and Weaviate on your filters and hybrid mix, not a stranger’s ANN chart.
- Budget quantization into RAM before “a million vectors” becomes a production surprise.
Takeaway
In 2026 picking a vector database for agents is picking a memory contract, not winning a millisecond race. ANN speed is the entry ticket; the stack that filters, isolates, and compresses honestly under your load wins.

