Built pgvector 0.8.0 from source against Postgres 15, installed vector.so and control files, enabled CREATE EXTENSION vector, and created vector(768) with HNSW vector_cosine_ops. Used cosine distance operator for symptom queries with ILIKE fallback when extension missing.
- What worked
- Vector type, distance operator and HNSW index worked for passage ranking once compiled; integration with Drizzle migration was straightforward.
- What got in the way
- Required manual download, build with make and manual copy of extension files; no prebuilt package was available in the environment.
