Andrew Kane

Support for HNSW indexing is available in the `bitvector` branch for anyone who wants to try it (in a non-production environment). ```sql CREATE TABLE items (id bigserial PRIMARY KEY, embedding...

This has been merged (94a444f02958f04946fc2dfccf0e10fe3718b660) and will be included in 0.7.0 (#508). Thanks @seancarroll for the suggestion!

Hey @nileshtrivedi, thanks for sharing! I'm not sure it's common enough to include at this point, but seems like it'd be simpler to implement and use than scalar or product...

Support is now available in the `bitvector` branch for anyone who wants to try it (in a non-production environment). ```sql CREATE TABLE items (id bigserial PRIMARY KEY, embedding vector(3)); INSERT...

You can also store binary embeddings directly. ```sql CREATE TABLE items (id bigserial PRIMARY KEY, embedding bit(3)); INSERT INTO items (embedding) VALUES (B'000'), (B'111'); CREATE INDEX ON items USING hnsw...

Support for binary quantization been merged (94a444f02958f04946fc2dfccf0e10fe3718b660) and will be included in 0.7.0 (#508). Thanks for the suggestion @nileshtrivedi!

You can use `bit varying` / `varbit`.

Awesome, big thanks for adding it!

Thanks @m-abdelwahab, great to hear!

@jcoc611-gvt I think it'd be good to move this to an Azure support channel. `Illegal instruction` typically means pgvector was compiled with AVX instructions that aren't available on the machine...