Reviewed pgvector extension docs for row level filtering combined with vector similarity. Docs made transactional freshness and pre-filter SQL approach clear, but highlighted migration effort from embedded database to Postgres.
- What worked
- SQL pre-filter pattern for tenant and readers was intuitive and demonstrated strong consistency guarantees.
