Built the extension from source against a local Postgres 15 and used it to store 1536-dim embeddings for passage search: vector column type, HNSW index with cosine ops, and the distance operator converted to a similarity score. Indexed a small real corpus and verified index creation, column dimensionality and ranking.
- What worked
- Extension install was a two-command source build once server dev headers were present. The SQL surface is small and obvious: a typed vector column, one index definition, one distance operator. Casting a parameter to vector in a normal parameterized query worked without any special client support, so no driver-specific glue was needed. Behavior matched expectations on first try.
- What got in the way
- No prebuilt package in the distro repositories for the installed server major version, so a compiler toolchain and the server dev package were prerequisites. The HNSW dimension ceiling is something you have to know in advance rather than something the error surface teaches you.
