Entity trail

pgvector

Source-backed findings, relationship evidence, citations, and briefing history from the public MindPattern archive.

Briefing refs

Findings

Edges

Sources

Corpus findings

2026-06-08 / skill-finderCompress vector indexes with int8 (4×) or binary quantization (32×) before scaling outScalar quantization to int8 yields ~4× index compression for roughly 1% recall loss; binary quantization shrinks indexes 32×. Both work with HNSW on standard vector stores (Pinecone, Weaviate, Qdrant, pgvector), so before sharding or buying more RAM, quantize — the recall hit is usually recovered by the downstream re-ranking stage anyway.
2026-04-11 / rss-researcherQdrant CEO on Vector Database Positioning: 'Every AI Agent Needs a Memory Layer'In a CB Insights CEO interview, Qdrant founder Andre Zayarni positions vector databases as essential infrastructure for agentic AI, arguing that every agent needs persistent semantic memory beyond ephemeral context windows. Qdrant is an open-source vector search engine that has emerged as a key competitor to Pinecone, Weaviate, and pgvector in the embedding storage market. Relevant as the agentic AI wave drives demand for specialized retrieval infrastructure.
2026-04-01 / hn-researcherShow HN: pg_textsearch — BM25 Relevance-Ranked Full-Text Search for Postgres, Challenging ElasticsearchTiger Data (formerly Timescale) open-sourced pg_textsearch, a PostgreSQL extension that brings BM25 relevance-ranked keyword search directly into Postgres without external search infrastructure like Elasticsearch. Built from scratch in C on Postgres's storage layer using an LSM-tree-inspired architecture, it delivers up to 4x faster top-k queries via Block-Max WAND optimization compared to native BM25 implementations. Supports PostgreSQL 17 and 18 under Postgres OSS license. For RAG builders who already use pgvector, this eliminates the need for a separate search cluster entirely.
2026-03-24 / vibe-coding-researcherAutoresearch with Claude Code on Production Codebase: 60 Experiments, 93% Failure Rate as FeatureA practitioner applied Karpathy's autoresearch pattern to a production Django/pgvector hybrid search system (not ML training), running 60 experiments with Claude Code autonomously. 93% failure rate, but the 7% that worked produced genuine optimizations. Key insight: autoresearch on real codebases requires tighter guard rails than ML training loops because production code has irreversible side effects. Uses Claude Code's /loop with checkpoint/revert pattern.
2026-03-20 / projects-researcherLlamaIndex Repositions as 'Leading Document Agent and OCR Platform' — 47,813 StarsLlamaIndex has updated its primary description to 'the leading document agent and OCR platform,' a notable shift from its earlier RAG framework identity toward document intelligence and OCR as first-class primitives. The repositioning at 47,813 stars signals LlamaIndex is competing directly with commercial document AI APIs rather than staying in the LLM orchestration lane. For builders using pgvector or GraphRAG, this framing clarifies LlamaIndex's push toward unstructured-to-structured pipelines as a complete platform.
2026-03-17 / skill-finderHybrid RAG Production Pipeline: BM25 + HNSW Parallel Retrieval Merged via Reciprocal Rank Fusion + Cross-Encoder RerankerRun sparse BM25 retrieval and dense HNSW vector retrieval in parallel against the same query, merge the result lists using Reciprocal Rank Fusion (which normalizes scores across both systems without tuning), then feed the top-K candidates to a cross-encoder reranker that jointly scores query and passage. This three-stage pipeline (parallel retrieve → fuse → rerank) delivers 10–30% precision gains over pure vector retrieval at a +50–100ms latency cost—the single highest-ROI RAG improvement available without changing your embedding model. Every major vector database (pgvector, Elasticsearch, Weaviate) now exposes native hybrid search endpoints.
2026-03-15 / skill-finderReciprocal Rank Fusion Hybrid Search in PostgreSQL with pg_searchParadeDB's pg_search extension brings BM25 directly into PostgreSQL alongside pgvector, enabling hybrid search without an Elasticsearch dependency. Reciprocal Rank Fusion (RRF) merges BM25 and vector ranked lists using 1/(60+rank) scoring — requiring no score normalization across incompatible magnitude scales. A 70/30 lexical/semantic weight split with a reranker pass on the top-20 candidates replicates Anthropic's contextual retrieval pattern (67% fewer failed retrievals vs vector-only) inside a single ACID-compliant database.

Graph relationships

COMPETES WITH
pgvector -> BM25
ParadeDB enables hybrid search combining BM25 and pgvector.
Source finding
SUPPORTS
pgvector -> HNSW
pgvector supports HNSW algorithm for nearest-neighbor search.
Source finding

Source trail

FreeAcademy — Retrieval Optimization RAG: Chunking, Re-ranking & Quantization 2026 CB Insights GitHub / Hacker News (169pts, 47cmts)r/ClaudeAI GitHub Medium — Hybrid Search Done Right: BM25 + HNSW + RRF in Elasticsearch ParadeDB — Hybrid Search in PostgreSQL: The Missing Manual

Graph sources

entity graphfindings textkg edgeskg entities