- PostgreSQL index basics: B-tree indexes, reading EXPLAIN, and why your index is not being usedDatabases · 29 Oct 2026
- PostgreSQL planner misestimates: statistics targets, extended statistics and correlated columnsDatabases · 29 Oct 2026
- pgvector query ignores the HNSW index: sequential scans caused by operator mismatches, ORDER BY expressions and parameter typesAI & GenAI · 28 Oct 2026