Eight of fourteen models named pgvector first on the direct prompt; zero named Milvus. Both were named by all fourteen models and pgvector carries 66 labels and Milvus 41, so the shares are not directly comparable.
Named in one category this edition.
Named in one category this edition.
Share is the count of first choices across the direct, paraphrase, budget and scale prompts over all fourteen models, for a mid-market B2B company; rank is within the category; every quote names the model and the prompt it came from. Both figures come from the vector databases page.
Across every category in the October 2026 Edition, pgvector and Milvus were named in the same answer ninety-seven times, of the 179 answers naming pgvector and the 140 naming Milvus. In those answers Milvus took the first choice four times and pgvector thirty-seven.
| Model | DirectPG | ParaphrasePG | ComparativePG | Budget-constrainedPG | Scale-constrainedPG | NegativePG |
|---|---|---|---|---|---|---|
| Claude Haiku 4.5 | PG | PG | PG | |||
| GPT-5.4 mini | PG | PG | ||||
| Gemini 3.5 Flash | PG | PG | PG | PG | PG | PG |
| Perplexity Sonar | PG | PG | PG | PG | ||
| Grok 4.1 Fast | PG | PG | PG | PG | PG | PG |
| Mistral Small | PG | PG | PG | |||
| DeepSeek V4 Flash | PG | PG | PG | PG | PG | PG |
| Llama 4 Maverick | PG | PG | PG | |||
| Qwen 3.7 Flash | PG | PG | PG | |||
| Kimi K2 | PG | PG | PG | PG | PG | |
| GLM 4.7 FlashX | PG | PG | PG | PG | PG | |
| MiniMax M2.5 | PG | PG | PG | PG | ||
| GPT-6 Luna | PG | PG | PG | PG | PG | PG |
| Muse Glimmer 30B | PG | PG | PG |
Bold names in an answer are the products the judge labeled a first choice; a model naming several gives each of them that label. The full answer text for every row is in the record.
Every negative label with a quote, up to three, then the highest-weighted positives, up to three. Six of eight in this category shown.
“| Poor filtered search | pgvector, basic setups | ... | Reindexing locks | pgvector | Large HNSW rebuilds block reads/writes” Grok 4.1 Fast · negative prompt · soft negative
“pgvector when you expect very high vector-search throughput or huge scale without testing” GPT-6 Luna · negative prompt · soft negative
“Be cautious at massive scale ... you must be cautious of its ceilings” Gemini 3.5 Flash · negative prompt · soft negative
“Unless you have 2-3 people who can own this infrastructure, lean managed or existing DB extension first.... Already run Postgres heavily, <10M vectors | pgvector” Kimi K2 · scale prompt · first choice
“The best vector database for a mid-market B2B company is pgvector, which is a PostgreSQL extension. It is the strongest default for mid-market enterprises.” Llama 4 Maverick · direct prompt · first choice
“evaluating pgvector might save you the overhead of learning a new technology, as it handles vector search well within a relational environment” Qwen 3.7 Flash · scale prompt · first choice
Every negative label with a quote, up to three, then the highest-weighted positives, up to three. Six of eight in this category shown.
“heavy self-hosted systems like Milvus (requires Kubernetes know-how) ... neither is friendly to a limited budget” DeepSeek V4 Flash · budget prompt · hard negative
“Caution: If you run Milvus self-hosted, you must be on 2.4.24+, 2.5.21+ or 2.6.5+ and strip `sourceID` at the gateway” Muse Glimmer 30B · negative prompt · soft negative
“handles billions of vectors at lower cost; requires engineering resources... more resource-intensive to operate” Claude Haiku 4.5 · comparative prompt · soft negative
“likely to be an open-source option such as Milvus or Chroma, as they offer free or low-cost options” Llama 4 Maverick · budget prompt · first choice
“I'd recommend starting with either self-hosted Milvus/Qdrant (if you have DevOps capacity)” Claude Haiku 4.5 · budget prompt · first choice
“Massive Scale / Billions of vectors | Milvus” Qwen 3.7 Flash · comparative prompt · first choice
Comparisons are drawn for the top eight products in each category, each against each. The output is the models' output; nothing here is a recommendation by the index.