Permission Filters and pgvector: Why Your Most Restricted Users Get the Fewest Answers
This story is from 2026-09-26. It is preserved in the archive; the latest stories are on the live feed.
If you build AI search over documents that not everyone may read, you filter by permission. In PostgreSQL with pgvector, that usually means a WHERE clause on the caller's groups and an ORDER BY on vector distance. With no vector index, that query is exact and always complete. Add an HNSW index for…
Read the full story at DEV Community — AI ↗
Timeline · 1 report
- 2026-09-26 00:15 · DEV Community — AI
Permission Filters and pgvector: Why Your Most Restricted Users Get the Fewest Answers