timescale / pgvectorscale

A complement to pgvector for high performance, cost efficient vector search on large workloads.
PostgreSQL License
1.37k stars 58 forks source link

adding pgvectorscale #114

Open legaltextai opened 4 months ago

legaltextai commented 4 months ago

does pgvectorscale require specific columns in my PG table, the same as in your example? e.g. I have 'id' , 'vector', and 'metadata' columns, no dates, with pgvector (hnsw) index over 'vector' can I add pgvectorscale? if I can, will I need to / can I delete the previous pgvector/hnsw index? thank you

cevian commented 3 months ago

No specific columns are required except for the vector column. Yes, you can just add pgvectorscale on the vector column and drop the hnsw index.