- Sev1: pgvector search went from 50 ms to seconds — HNSW index not used, filters and ef_searchAI & GenAI · 31 Oct 2026
- Filtered vector search returns too few or wrong results: pre-filtering vs post-filtering, HNSW and iterative scansAI & GenAI · 28 Oct 2026
- Hybrid search in PostgreSQL: combine pgvector and full-text search with reciprocal rank fusion in one SQL queryAI & GenAI · 28 Oct 2026
- pgvector cheat sheet: vector types, distance operators, index operator classes and the settings that matterAI & GenAI · 28 Oct 2026
- pgvector HNSW index build takes hours: maintenance_work_mem, parallel workers and building without blocking writesAI & GenAI · 28 Oct 2026
- pgvector HNSW index keeps growing and VACUUM takes hours: bloat from updates and deletes, and how to keep it under controlAI & GenAI · 28 Oct 2026
- pgvector query ignores the HNSW index: sequential scans caused by operator mismatches, ORDER BY expressions and parameter typesAI & GenAI · 28 Oct 2026
- Transformation: consolidating a standalone vector database into PostgreSQL with pgvectorAI & GenAI · 25 Oct 2026
- Single-VM RAG proof of concept with Ollama and pgvectorAI & GenAI · 22 Oct 2026
- Vector database high availability: replicas, shards and zone placement across common enginesAI & GenAI · 22 Oct 2026
- Vector index operations: HNSW tuning, memory sizing and measuring recallAI & GenAI · 22 Oct 2026