Five of fourteen models named pgvector first on the direct prompt; one named Weaviate. Both were named by all fourteen models and pgvector carries 73 labels and Weaviate 60, 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 November 2026 Edition, pgvector and Weaviate were named in the same answer 139 times, of the 192 answers naming pgvector and the 183 naming Weaviate. In those answers Weaviate took the first choice seven times and pgvector forty-one.
| Model | Direct | Paraphrase | Comparative | Budget-constrained | Scale-constrained | Negative |
|---|---|---|---|---|---|---|
| Claude Haiku 4.5 | ||||||
| GPT-5.4 mini | ||||||
| Gemini 3.5 Flash | ||||||
| Perplexity Sonar | ||||||
| Grok 4.20 | ||||||
| Mistral Small | ||||||
| DeepSeek V4 Flash | ||||||
| Llama 4 Maverick | ||||||
| Qwen 3.7 Flash | ||||||
| Kimi K2 | ||||||
| GLM 4.7 FlashX | ||||||
| MiniMax M2.5 | ||||||
| GPT-6 Luna | ||||||
| Muse Glimmer 30B |
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.
“pgvector does not natively support GPU acceleration or disk-optimized indexes, and at billion-scale workloads typically require more advanced sharding strategies” Claude Haiku 4.5 · negative prompt · soft negative
“Using vectors beside your application data in Postgres via pgvector is often the safest default until measured retrieval requirements force a dedicated engine.” Muse Glimmer 30B · negative prompt · soft negative
“pgvector for large, high-throughput workloads with selective filters or many tenants... approximate-index filtering can return too few results” GPT-6 Luna · negative prompt · soft negative
“the recommendation is to start with pgvector unless your scale, query patterns, or operational constraints provide specific evidence otherwise” Claude Haiku 4.5 · scale prompt · first choice
“Start simple: Use pgvector (in Postgres) or SQLite with vector extensions for most apps—it's battle-tested, avoids new tech debt” Grok 4.20 · negative prompt · first choice
“If your company already uses PostgreSQL for standard application data, pgvector is almost always the most cost-effective choice.” Gemini 3.5 Flash · budget 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.
“What to Avoid on a Budget ... Weaviate — More complex to set up and resource-intensive” MiniMax M2.5 · budget prompt · hard negative
“Managed Weaviate — $25–45/month minimums plus hidden infrastructure costs” DeepSeek V4 Flash · budget prompt · hard negative
“Running a dedicated service (like Weaviate, Pinecone, or Qdrant) alongside your primary database increases infrastructure costs” Qwen 3.7 Flash · negative prompt · soft negative
“Most teams should evaluate Qdrant (for performance and flexibility) or Weaviate (for AI-native features) as their primary options” GLM 4.7 FlashX · comparative prompt · first choice
“For most mid-market B2B companies, Weaviate or Qdrant offer the best balance of cost, performance, and flexibility” MiniMax M2.5 · direct prompt · first choice
“we often recommend starting with a specialized open-source solution like Weaviate (using their cloud tier)” Qwen 3.7 Flash · paraphrase 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.