Eight of fourteen models named pgvector first on the direct prompt; zero named MongoDB Atlas Vector Search. pgvector was named by fourteen of the fourteen models and MongoDB Atlas Vector Search by eight and pgvector carries 66 labels and MongoDB Atlas Vector Search 12, 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.
| 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. Four of four in this category shown.
“MongoDB Atlas gets pricing gripes in broader DB contexts” Grok 4.1 Fast · negative prompt · soft negative
“the sweet spot today is MongoDB Atlas Vector Search (if your data already lives in MongoDB)” GLM 4.7 FlashX · paraphrase prompt · first choice
“Stick with MongoDB Atlas if your existing data pipeline is already built around MongoDB documents.” Qwen 3.7 Flash · direct prompt · alternative
“Use pgvector or Atlas Vector Search” Kimi K2 · scale prompt · alternative
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.